Play with SequenceEqual using LINQ

By Vijay Prativadi Nov 21, 2012
Today, in this blog let's play around with one of the interesting and most useful concept in 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

Vijay Prativadi

Hey Everyone, It's Vijay. I am SDE mostly up on Microsoft Technologies. If you are thinking to know what I do mostly when at work. I get a chance to work upon few Microsoft technologies. All the way along my core tech... Read more

COMMENT USING

PREMIUM SPONSORS

Hire Mobile & Web Developer on demand. 100% satisfaction. Try for 1 week or Money Back. Local and remote developers available all over USA.

Latest Blogs