How to Perform Self Outer JOIN using LINQ

Vijay Prativadi
9y
1.8k
0
0

Blog

Introduction

In this blog we will see how to perform self outer join using LINQ.

Step 1: Create asp.net web application

Webform1.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="SelfOuterJoin_LINQ.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 SelfOuterJoin_LINQ
{
public partial class WebForm1 : System.Web.UI.Page
{
EmployeeDBEntities objEmpEntities = new EmployeeDBEntities();
protected void Page_Load(object sender, EventArgs e)
{
var query = (from r in objEmpEntities.Employees
join q in objEmpEntities.Employees on r.EmpId equals q.ManagerId into result
from emp in result.DefaultIfEmpty()
select new
{
r.FirstName,
r.LastName,
emp.ManagerName
}).ToList();
GridView1.DataSource = query;
GridView1.DataBind();
}
}
}

Output of the application looks like this

Summary

In this blog we have seen how we can perform self-outer join using LINQ. Happy coding!

How to Perform Self Outer JOIN using LINQ

Up Next

LINQ

Working With Left Outer Join Using Lambda And LINQ

Ebook Download

View all

C# Corner Ebook

Printing in C# Made Easy

Read by 10.8k people

Download Now!

Learn

View all

Learn Image

MVC Corporation

MVC Corporation is consulting and IT services based company.