Play with SequenceEqual using LINQ

Introduction

Today, in this blog let's play around with one of the interesting and most useful concept in LINQ.

Question: What is play with SequenceEqual using LINQ?

In simple terms "It provides flexibility to query on requested data sources to make sure whether the data are equal or not as per the requirements considered".

Step 1: Create a new WebForm project

Step 2: The complete code of WebForm1.aspx looks like this

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="LINQApp.WebForm1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

<div>

<table>

<tr>

<asp:Label ID="Label1" runat="server" Text="Play with Sequence Equal using LINQ"

Font-Bold="true" Font-Size="Large" Font-Names="Verdana" ForeColor="Maroon"></asp:Label>

</td>

</tr>

</table>

</div>

</center>

</form>

</body>

</html>

Step 3: The complete code of WebForm1.aspx.cs looks like this

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

namespace LINQApp

{

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

{

protected void Page_Load(object sender, EventArgs e)

{

var query1 = objEntities.Employee.ToList().Select(r => r.Location);

var query2 = objEntities.Department.ToList().Select(r => r.Location);

bool result = query1.SequenceEqual(query2);

Label obj_Label = new Label();

obj_Label.Text = "The Result is: " + result;

obj_Label.ForeColor = System.Drawing.Color.Green;

this.Page.Controls.Add(obj_Label);

}

#region Instance Members
CompanyEntities objEntities = new CompanyEntities();

#endregion

}

}

Step 4: The output of the application looks like this