syntaxhelp.com Your online cheat sheet!

NorthwindDataConext  db = new NorthwindDataContext(); 

// query Gets list of Customers,City starts with "S"
var custname = from c in db.Customers
                where c.City.StartsWith("S")
                orderby c.City ascending
                select c; 

//.Will be translated to SELECT MAX(UnitPrice)FROM products in Sql
var val= (from p in db.Products select (p.UnitPrice)).Max()  ;