Group by Multiple Columns using Anonymous Types in LINQ to SQL

with 3 comments

I believe LINQ is a very nice advancement in creating database oriented applications as it allows us to separate application logic from the database. I have been using LINQ to SQL in my recent reporting application and have used various queries with ease. With the power of Anonymous Types, I was ab... [More]

Written by Manoj

30. June 2009 12:00

Posted in Linq-to-SQL

Tagged with ,

Using jQuery Google Charts (JGCharts) with ASP.NET application

without comments

I had been looking for a light weight charting library that I could use with my ASP.NET application for a while now. There are a number of charting libraries with jQuery but I found the jQuery wrapper for Google Charts by Massimiliano Balestrieri to be efficient and simple to use. In this tutorial ... [More]

Written by Manoj

12. June 2009 00:13

Posted in ASP.NET

Tagged with ,

Finding Min or Max Date using LINQ to SQL

without comments

In one of my recent project, I had to retrieve Minimum and Maximum date from the result set using LINQ to SQL. I was really surprised how easy it was: //Retrieve Minimum Date var MinDate = (from d in dataRows select d.Date).Min();   //Retrieve Maximum Date ... [More]

Written by Manoj

11. June 2009 19:38

Posted in Linq-to-SQL

Tagged with ,

BlackNewspaper – free BlogEngine.NET theme

without comments

Introducing BlackNewspaper a free BlogEngine.NET theme. This theme is a modified version of an existing theme called Newspaper v1.1 by jankoatwrapspeed.com. BlackNewspaper theme is a simple White on Black theme with cleaner boundaries and gray sidebar text to give more emphasis to the contents in t... [More]

Written by Manoj

10. June 2009 23:01

Posted in BlogEngine.NET

Tagged with