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.
Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.