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.

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

<html xmlns="">

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




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





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









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;



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




Step 4: The output of the application looks like this


Vijay  Prativadi
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 I'm at work. I get a chance to work upon few Microsoft technologies. All the way along my core tec... Read more