LINQPad Notes

Table of Contents

1. LINQ Syntax Examples

1. LINQ Syntax Examples

1.1. Select

Select statement:

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

Select with a join

(from r in Regions
    join t in Territories
    on r.RegionID equals t.RegionID
    select new{
        Region = r,
        Territory = t
}).Dump();

1.2. Insert

Insert statement:

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

1.3. Update

Update statement:

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

1.4. Delete

Delete statement:

var removeRegion = Regions.Where( r => r.RegionID == 99 ).Single();
Regions.DeleteOnSubmit( removeRegion );
SubmitChanges();