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