LINQ 2 SQL Cheat Sheet
- Posted: Aug 13, 2009 at 6:45AM
- 4 comments
Loading user information from Channel 9
Something went wrong getting user information from Channel 9
Loading user information from MSDN
Something went wrong getting user information from MSDN
Loading Visual Studio Achievements
Something went wrong getting the Visual Studio Achievements
Damien Guard has created a nice little cheat sheet for LINQ 2 SQL. Damien even went the extra yard and put it in both VB.Net and C# since the syntax is slightly different for each.
If you haven't tried LINQ2SQL, it is pretty powerful. Stuff that typically would have been a bit more complex has become extremely simple. Want to do a paged statement?
var page3 = (from c in db.Customers orderby c.ContactName, c.City descending select c).Skip(10).Take(5);
Update a record?
customer.ContactName = "Adam"; customer.Location = null; db.SubmitChanges();
The cheat sheet has a bunch of additional samples.