LINQ 2 SQL Cheat Sheet

Sign in to queue

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

Add Your 2 Cents