LINQ to SQL Inner Join

In LINQ to SQL, Inner Join will return only the records or rows, which maps both the tables based on the defined conditions.

Syntax of LINQ to SQL Inner Join

Here is the syntax of using the LINQ to SQL Inner Join to get the data from the multiple tables.

C# Code

 var result = from ed in db.EmployeeDetails

join d in db.Departments on ed.DeptId equals d.DeptId

select new

{

Name = ed.EmpName,

Department = d.DeptName

};

From the above syntax, we joined the "EmployeeDetails", "Departments" tables to get the required data by using the inner joins.

Example of LINQ to SQL Inner Join

Before the implementation of LINQ to SQL inner join, we need to create a database with required tables and map those tables to LINQ to SQL file(.dbml).

To know the process of the mapping, click on the link LINQ to SQL.

Once we create and map the required tables to .dbml file. Now we want to show the data in our application. For that we have to right-click on the application->Select Add->New Item-> Select web Form-> Give name as Default.aspx and click OK button.

Now open Default.aspx page and write the code as shown below

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server"
>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <asp:GridView ID="gvDetails" runat="server"></asp:GridView>
        </div>
    </form>
</body>
</html>

Now open the code behind the file and write the code as shown below:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
    private object db;

    protected void Page_Load(object sender, EventArgs e)
    {
        var result = from ed in db.Employeedetail

                     join d in db.Department on ed.DeptId equals d.DeptId

                     where d.DeptName.Equals("software")

                     select new

                     {

                         Name = ed.EmpName,

                         Location = ed.Location,

                         Gender = ed.Gender,

                         Department = d.DeptName

                     };

        gvDetails.DataSource = result;

        gvDetails.DataBind();

    }
}

From the above example, we are trying to get the data from "EmployeeDetails" and "Departments" table using the inner join.

OUTPUT