LINQ To SQL Cheat Sheet
Document Sample


C# Version 1 - May 2007
Created by Ben Hall
Available free at
blog.benhall.me.uk
DATA CONTEXT
NorthwindDataContext db = new NorthwindDataContext (“server=.;”);
SELECT WHERE
var qry= from p in products var qry= from p in products
select p; WHERE p.val == 123 (Equals)
Or select p.val; Or WHERE p.val != 123 (Not Equals)
Or select new {a = p.val} Or WHERE p.val > 1 && p.val < 3 (Between)
select p;
INSERT
ORDER BY
db.Product.Add(new
Product()) var qry= from p in products
db.SubmitChanges(); orderby p.ProductName.Length
Or orderby p.ProductName
UPDATE Or orderby p.UnitsInStock descending
select p;
productObjectFromDB.Price =
123; JOIN
db.SubmitChanges();
from p in persons join w in workers
DELETE on new { p.FirstName, p.LastName } equals new
{ w.FirstName, w.LastName }
db.Product.Remove(productOb select p;
jectFromDB) Or
db.SubmitChanges(); Join o in orders on p.ProductID equals
o.ProductID
TAKE
SELECT SINGLE OBJECT
var qry= (from p in products
select p).Take(5) Product p = db.Products.Single(p => p.ProductID
== 123);
SKIP
MAX
var qry= (from p in products
select p).Skip(5) db.Products.Max(p => p.Price)
Related docs
Get documents about "