Today I tried to used the LinqToSql in my project. In order to use LinqToSql, you have to learn LINQ. Here are the sample code to appreciate the benefits of LinqToSql, by the way, big thanks to Rob Conery for this example. Here is his blog http://blog.wekeroad.com/2007/12/14/aspnet-mvc-choosing-your-data-access-method/
NorthwindDataContext db=new NorthwindDataContext ();
var result = from p in db.Products
select p;
And to returns an IQueryable
foreach(var p in result){
//do something...
}
Data in List<> form
List<Northwind.Product> list=p.ToList<Northwind.Product>();
This sample in much complex but it is still readable :)
var customerOrderGroups =
from c in customers
select
new {c.CompanyName,
YearGroups =from o in c.Orders
group o by o.OrderDate.Year into yg
select new {Year = yg.Key,
MonthGroups = from o in yg
group o by o.OrderDate.Month into mg
select new { Month = mg.Key, Orders = mg }
}
};
Reference Url : http://blog.wekeroad.com/2007/12/14/aspnet-mvc-choosing-your-data-access-method/
 |
