LINQ - Partitioning Operators

Manoj Kalla

LINQ Language Integrated QueryLINQ Partitioning OperatorsPartitioning Operators

35 Comments

Join the conversation! Your thoughts help the community grow.

Shobana J10y ago
Good One
Sonu Chaudhary10y ago
nice
Sadasiva V10y ago
Thank you, Manoj...It is very useful article
Avikshith Aradhya10y ago
If i want to skip second item from array using skipwhile() it is not working. Does it only take first item of the array?
Bhuvanesh Mohankumar10y ago
Good one...
Gowtham Rajamanickam10y ago
Good Show.
- Manoj Kalla10y ago
  Thank you, Gowtham
Mohammed Ibrahim10y ago
nice
- Manoj Kalla10y ago
  Thank you, Mohammed
Vignesh Mani10y ago
Nice
- Manoj Kalla10y ago
  Thank you, Vignesh
Karthikeyan K10y ago
Good one sir...
- Manoj Kalla10y ago
  Thank you, Karthikeyan, After so many days ... I had seen your appreciation... Thank you coming on page...
Humayun Kabir Mamun10y ago
Nice...
- Manoj Kalla10y ago
  Thank you, Humayun
Ammar Shaukat10y ago
I've also heard about "LINQ to Amazon".
- Manoj Kalla10y ago
  Thank you, Ammar
Roshan Mule10y ago
Thank you sir. Good Article.
- Manoj Kalla10y ago
  Thank you, Roshan
Shaili Dashora10y ago
Nice one..
- Manoj Kalla10y ago
  Thank You, Shaili
Debasis Saha10y ago
Good One..
- Manoj Kalla10y ago
  Thank you, Debasis
Gowtham K10y ago
Good One, Thanks for sharing:)
- Manoj Kalla10y ago
  Thank You, Gowtham
Shehzad10y ago
Tks for sharing Sir....However SKIP & FILTER command already there in FoxPro since early 80's
- Manoj Kalla10y ago
  Thank you for remind... I had worked 14 Years continues in Clipper, FoxBase/FoxPlus, Foxpro-Dos/Windows/Visual. In VFP 6 to 9 all versions. You can see BEGIN TRANSACTION .....END TRANSACTION in sql server comes late... We had used in Foxpro very early this kind of commands.
Gopi Chand10y ago
Great one
- Manoj Kalla10y ago
  Thank you, Gopi
Ankur Mistry10y ago
Nice share
- Manoj Kalla10y ago
  Thank you, Ankurbhai
Hari Shanker10y ago
Thanks For Sharing..Nice
- Manoj Kalla10y ago
  Thank you, Hari
Rahul Kumar Saxena10y ago
Very Clear Explanation
- Manoj Kalla10y ago
  Thank you, Rahulji

LINQ – Language Integrated Query

LINQ was introduced in Visual Studio 2008 and is available with .NET languages, it's very fast and short to write and to manipulate objects, contents, and values. Visual Studio includes LINQ provider assemblies that enable the use of LINQ.

We can use LINQ in the following ways:

LINQ to SQL
LINQ to Object
LINQ to XML

My previous article on LINQ

In this article we will learn about LINQ Partitioning Operator: Skip, SkipWhile and Take, TakeWhile keywords.

Partition operator is splitting, breaking and returning result sets.

Skip: Return result set after jumping /skipping elements from start point as per given value.
SkipWhile: Return result set after jumping with conditional from start point as per given value.
Take: Return result set from start point as per given value.
TakeWhile: Return result set from start point with conditional as per given value.

Picture taken from MSDN

We will do practical on the Subject array as given below:

string[] Subjects = { "Hindi", "Marathi", "Maths", "Science", "English", "Computer" };

Skip sample code

Return result set after jumping /skipping elements as given value.

Syntax: Subjects.Skip(?)
? = Numbers of item you want to skip.

Example: Subjects.Skip(2)

SkipWhile sample code

Return result set after jumping with conditional from start point as per given value.

Syntax: Subjects.Skip(?)
? = Numbers of items you want to skip.

Example: Subjects.Skip(2)

Take sample code

Return result set from start point as per given value.

Syntax: Subjects.Take(?);
? = Numbers of items you want to take from starting.

Example: Subjects.Skip(2)

TakeWhile sample code

Return result set from start point with conditional as per given value.

Syntax: Subjects.TakeWhile(?)
? = Numbers of item you want to take conditionally.

Example: Subjects.TakeWhile(x => x == "Hindi")

SkipAndSkipWhile.aspx code

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="SkipAndSkipWhile.aspx.cs" Inherits="SkipAndSkipWhile" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="lblSkipTitle" runat="server" Text="Skip Example" Font-Bold="true" Font-Size="Larger"></asp:Label>
<table title="Skip Example">
<tr>
<td>
All Subjects
<asp:GridView ID="GridView1" runat="server"></asp:GridView>
</td>
<td style="padding-left:100px">
Skip 2
<asp:GridView ID="GridView2" runat="server"></asp:GridView>
</td>
</tr>
</table>
</div>
<br />
<br />
<br />
<br />
<div>
<asp:Label ID="lblSkipWhile" runat="server" Text="SkipWhile Example" Font-Bold="true" Font-Size="Larger"></asp:Label>
<table title="Skip While Example">
<tr>
<td>
All Subjects
<asp:GridView ID="GridView3" runat="server"></asp:GridView>
</td>
<td style="padding-left:100px">
SkipWhile = Hindi
<asp:GridView ID="GridView4" runat="server"></asp:GridView>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>

SkipAndSkipWhile.aspx.cs code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class SkipAndSkipWhile: System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string[] AllSubjects =
{
"Hindi",
"Marathi",
"Maths",
"Science",
"English",
"Computer"
};
string[] Subjects =
{
"Hindi",
"Marathi",
"Maths",
"Science",
"English",
"Computer"
};
GridView1.DataSource = AllSubjects;
GridView1.DataBind();
GridView2.DataSource = Subjects.Skip(2);
GridView2.DataBind();
GridView3.DataSource = AllSubjects;
GridView3.DataBind();
GridView4.DataSource = Subjects.SkipWhile(x => x == "Hindi");
GridView4.DataBind();
}
}

TakeAndTakeWhile.aspx code

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="TakeAndTakeWhile.aspx.cs" Inherits="TakeAndTakeWhile" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label ID="lblTakeTitle" runat="server" Text="Take Example" Font-Bold="true" Font-Size="Larger"></asp:Label>
<table title="Take Example">
<tr>
<td>
All Subjects
<asp:GridView ID="GridView1" runat="server"></asp:GridView>
</td>
<td style="padding-left:100px">
Take 2
<asp:GridView ID="GridView2" runat="server"></asp:GridView>
</td>
</tr>
</table>
</div>
<br />
<br />
<br />
<br />
<div>
<asp:Label ID="lblTakeWhile" runat="server" Text="TakeWhile Example" Font-Bold="true" Font-Size="Larger"></asp:Label>
<table title="Take While Example">
<tr>
<td>
All Subjects
<asp:GridView ID="GridView3" runat="server"></asp:GridView>
</td>
<td style="padding-left:100px">
TakeWhile = Hindi
<asp:GridView ID="GridView4" runat="server"></asp:GridView>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>

TakeAndTakeWhile.aspx.cs code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class TakeAndTakeWhile: System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string[] AllSubjects =
{
"Hindi",
"Marathi",
"Maths",
"Science",
"English",
"Computer"
};
string[] Subjects =
{
"Hindi",
"Marathi",
"Maths",
"Science",
"English",
"Computer"
};
GridView1.DataSource = AllSubjects;
GridView1.DataBind();
GridView2.DataSource = Subjects.Take(2);
GridView2.DataBind();
GridView3.DataSource = AllSubjects;
GridView3.DataBind();
GridView4.DataSource = Subjects.TakeWhile(x => x == "Hindi");
GridView4.DataBind();
}
}

SkipAndSkipWhile.aspx output

output

TakeAndTakeWhile.aspx output

output

In the following link, you will get 101 Sample LINQ queries. These code samples cover the entire range of LINQ functionality and demonstrating LINQ with SQL, DataSets, and XML.