Referring to http://www.revenmerchantservices.com/page/Linq-to-Sql.aspx

Filter Items into DB using Linq to SQl


Create DataBaseContext objct
AdventureWorksDataContext advDBc = new AdventureWorksDataContext();

var query = from entities in advDBc.Products   // select entities from product

where entities.Name.StartsWith("B")       // This will give all products starting with B

select entities;    // all linq statements must end with select or groupby clauses

GridView1.DataSource = query;

GridView1.DataBind();

 

Referring to http://www.revenmerchantservices.com/page/Linq-to-Sql.aspx

Insert new Item into DB using Linq to SQl

First we will add Locations in to .DBML file. Drag and drop the Locations table into .DBML file

and perform below action to insert new location and show it on grid.

AdventureWorksDataContext dbc = new AdventureWorksDataContext();    // Create an object of Database context

Location locationinfo = new Location();   // Create entity of Location

locationinfo.Name = "Pune";    // Populate entity with Names,and other field

locationinfo.Availability = 1.5M;

locationinfo.CostRate = 1.6M;

locationinfo.ModifiedDate = DateTime.Now;

dbc.Locations.InsertOnSubmit(locationinfo);    // Pass this location entity to Database context for insertation

dbc.SubmitChanges();     // update changes into SQL

var query = from locationEntity in dbc.Locations     // Query the locations table for newly inserted field locations

where locationEntity.Name == "Pune"

select locationEntity;

GridView1.DataSource = query;     // Bind the query to Grid

GridView1.DataBind();

- Satalaj