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 continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.