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

Image1.jpg

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">

<html xmlns="http://www.w3.org/1999/xhtml">

<head id="Head1" runat="server">

    <title></title>

</head>

<body>

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

    <center>

        <div>

            <table>

                <tr>

                    <td colspan="2" align="center">

                        <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

Image2.jpg

MVC Corporation
MVC Corporation is consulting and IT services based company.