Blog

Play with SequenceEqual using LINQ

Posted by Vijay Prativadi Blogs | LINQ 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

COMMENT USING
PREMIUM SPONSORS
SPONSORED BY
  • MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.