Inner Join using Linq to SQL

Vijay Prativadi
10y
2.1k
0
0
25
Blog

Introduction

In this blog we will see how to perform inner join using linq to sql.

Step 1: Create asp.net web application

Webform1.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="InnerJoin_LINQtoSQL.WebForm1" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server"></asp:GridView>
</div>
</form>
</body>
</html>

Webform1.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace InnerJoin_LINQtoSQL
{
public partial class WebForm1 : System.Web.UI.Page
{
DataClasses1DataContext objContext = new DataClasses1DataContext();
protected void Page_Load(object sender, EventArgs e)
{
var query = from r in objContext.Employees
join s in objContext.Departments
on r.DeptId equals s.DeptId
select new
{
FirstName = r.FirstName
,LastName = r.LastName
,Department = s.DeptName
};
GridView1.DataSource = query;
GridView1.DataBind();
}
}
}

Output of the application looks like this

Summary

In this blog we have seen how we can perform inner join using linq to sql.

Happy coding.

Inner Join using Linq to SQL