LINQ Basic Queries

In this Blog we learn Basic LINQ Queries in Asp.Net .

       1- Fill Gridview record:

public void showgridview(){DataClassesDataContext dc = new DataClassesDataContext();var q =from a in dc.GetTable<bio>()select a;GridView1.DataSource = q;GridView1.DataBind();}

      2- Search record:

public void SearchQuery(){DataClassesDataContext dc = new DataClassesDataContext();var q =from a in dc.GetTable<bio>()where a.name == TextBox3.Textselect a;GridView1.DataSource = q;GridView1.DataBind();}

      3- Insert Record

Public void InsertQuery(){DataClassesDataContext dc = new DataClassesDataContext();bio obj = new bio();obj.name = TextBox3.Text;obj.passw = TextBox5.Text;obj.fname = TextBox4.Text;dc.bios.InsertOnSubmit(obj);dc.SubmitChanges();showgridview();}

      4- Update record

public void UpdateQuery(){DataClassesDataContext dc = new DataClassesDataContext();bio objbio = dc.bios.Single(bio => bio.name == TextBox3.Text);objbio.passw = TextBox5.Text;objbio.fname = TextBox4.Text;dc.SubmitChanges();}

      5- Delete Record

public void DeleteQuery(){DataClassesDataContext dc = new DataClassesDataContext();bio obb = dc.bios.Single(bio => bio.name == TextBox3.Text);dc.bios.DeleteOnSubmit(obb);dc.SubmitChanges();}

      6- Inner Join

There is two table fee and bio.

Bio Table:

Fee Table:

DataClassesDataContext dc = new DataClassesDataContext();var biofee = from bio in dc.biosjoin fee in dc.feeson bio.id equals fee.idselect new { bio.name, bio.fname, fee.Address };GridView1.DataSource = biofee;GridView1.DataBind();//You can also do this with the help of lambda operator// Inner joinning Usin lambda operatorDataClassesDataContext dc = new DataClassesDataContext();var query = dc.bios.Join(dc.fees, r => r.id, p => p.id, (r, p) => new { r.name, r.fname, p.Address });GridView1.DataSource = query;GridView1.DataBind();