join three tables using linq in c#

var res = (from x in dbcon.tblEmployeeCommissions
                       join y in dbcon.tblClientRegistrations on x.ClientID equals y.ClientID
                       join z in dbcon.tblEmployees on x.EmployeeID equals z.EmployeeSlNo
                       where z.COPID == txtCoOperativePersonID.Text
                       select new {
                       x.CommissionDate,
                       y.ClientCode,
                       x.FA,
                       x.UM,
                       x.CO}); 

  gvCommissionDetails.DataSource = res;
  gvCommissionDetails.DataBind();

LINQ Deleter Query in c#.net

LINQ Deleter Query:

MydbDataContext db = new MydbDataContext();

        tbl_student stu = db.tbl_students.Single(x => x.Id == 103);

        db.tbl_students.DeleteOnSubmit(stu);

        db.SubmitChanges();

C#.net Code

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

public partial class Delete : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        MydbDataContext db = new MydbDataContext();

        tbl_student stu = db.tbl_students.Single(x => x.Id == 103);

        db.tbl_students.DeleteOnSubmit(stu);

        db.SubmitChanges();

    }

}

Update Query in Linq

LINQ Update Query:

MydbDataContext db = new MydbDataContext();

        tbl_student stu = db.tbl_students.Single(x=>x.Id==102);

        stu.Name = "Jc.Pavan";

        db.SubmitChanges();

Before Table data

C#.net Code

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

public partial class Update : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

        MydbDataContext db = new MydbDataContext();

        tbl_student stu = db.tbl_students.Single(x=>x.Id==102);

        stu.Name = "Jc.Pavan";

        db.SubmitChanges();

    }

}

After Table data (Output):

linq insert query in c#.net

LINQ Insert Query:

tbl_student stu = new tbl_student();

        stu.Name = txt_name.Text.Trim();

        db.tbl_students.InsertOnSubmit(stu);

        db.SubmitChanges();

Before Table data

Asp.net Code

<form id="form1" runat="server">

    <div>

        <center>

            <table>

                <tr>

                    <td>

                        Name:

                    </td>

                    <td>

                        <asp:TextBox ID="txt_name" runat="server"></asp:TextBox>

                    </td>

                </tr>

                <tr>

                    <td>

                    </td>

                    <td>

                        <asp:Button ID="btn_submit" runat="server" Text="Submit"

                            onclick="btn_submit_Click" />

                    </td>

                </tr>

            </table>

        </center>

    </div>

    </form>

C#.net Code

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

public partial class Insert : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {

    }

    protected void btn_submit_Click(object sender, EventArgs e)

    {

        MydbDataContext db = new MydbDataContext();

        tbl_student stu = new tbl_student();

        stu.Name = txt_name.Text.Trim();

        db.tbl_students.InsertOnSubmit(stu);

        db.SubmitChanges();

      

    }

}

After Table data (Output):