Add/Update/Delete With LINQPad

LINQPad.cs

// select (LINQ Syntax)
var regions =
    from r in Regions
    where r.RegionID > 0
    select r;
regions.Dump();

// insert
Region newRegion = new Region(){
    RegionID = 99,
    RegionDescription = "Lorem ipsum…"
};
Regions.InsertOnSubmit( newRegion );
SubmitChanges();

// select (LINQ Syntax, no temp variable)
(from r in Regions
    where r.RegionID > 0
    select r).Dump();

// update
Region region =
    (from r in Regions
        where r.RegionID == 99
        select r).Single();
region.RegionDescription = "…dolor sit amet…";
SubmitChanges();

// select (.Where Lambda expression)
( Regions.Where( r => r.RegionID > 0 ) ).Dump();

// delete
Region removeRegion = Regions.Where( r => r.RegionID == 99 ).Single();
Regions.DeleteOnSubmit( removeRegion );
SubmitChanges();

// select (Regions & Territories, joined and combined by anonymous type)
(from r in Regions
    join t in Territories
    on r.RegionID equals t.RegionID
    select new{
        Region = r,
        Territory = t
}).Dump();