CRUD operations using LINQ

CRUD operations using LINQ
---------------------------
private void Create()
{
NorthwindDataContext db = new NorthwindDataContext();
var products = from p in db.Products where p.CategoryId == 2 select p;

var products = from p in db.Products where p.Category.CategoryName == "Candles"
orderby p.ProductId descending
select new { p.ProductId, p.ProductName, p.Category.CategoryName, Price = p.UnitPrice };
}
here
1) Category table is linked with Product table.
2) Price = .... is called shaping.

private void Insert()
{
NorthwindDataContext db = new NorthwindDataContext();
Product p1 = new Product { CategoryId=1, ProductName='xyz', unitprice=1.23m }; // object initializer
db.Products.InsertOnSubmit(p1);
db.SubmitChanges();
}

private void Update()
{
NorthwindDataContext db = new NorthwindDataContext();
Product p1 = db.Products.First( p => p.ProductName.StartsWith("scott"));
p1.UnitPrice += 1.10m;
db.SubmitChanges();
}

private void Delete()
{
NorthwindDataContext db = new NorthwindDataContext();
Product p1 = db.Products.Single( p => p.ProductName.StartsWith("scott"));
db.Products.DeleteOnSubmit(p1);
db.SubmitChanges();
}