LINQ 2 SQL Cheat Sheet

Description

linq 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.

[via Scott Hanselman via Jeff Handley]

Tags:

C4FNews, linq2sql

The Discussion

Comments closed

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.