Reader Level:

Skip Operator Using LINQ

By Vijay Prativadi on Oct 23, 2012
Today, in this article let’s play around with one of the interesting and most useful concepts in LINQ.


Today, in this article let's play around with one of the interesting and most useful concepts in LINQ.


Question: What is skip operator?


In simple terms "It provides flexibility to skip and pull out the requested amount of records with the help of the skip operator in LINQ"

Step 1: Create a new "ASP.NET Web Application", as in:


Step 2: The design of the Employee table looks like this:




Step 3: The complete code of WebForm1.aspx looks like this:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="LINQInnerJoinApp._Default" %>


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

                        <asp:Label ID="Label1" runat="server" Text="Skip Operator using LINQ" Font-Bold="true"

                            Font-Size="Large" Font-Names="Verdana" ForeColor="Maroon"></asp:Label>




                    <td colspan="2" align="center">

                        <asp:Button ID="Button1" runat="server" Text="Select Data" Font-Names="Verdana" Width="213px"

                            BackColor="Orange" Font-Bold="True" OnClick="Button1_Click" />




                    <td colspan="2" align="center">

                        <br />

                        <asp:GridView ID="GridView1" runat="server" BackColor="LightGoldenrodYellow" BorderColor="Tan"

                            BorderWidth="1px" CellPadding="2" EnableModelValidation="True" ForeColor="Black"

                            GridLines="None" AutoGenerateColumns="False">

                            <AlternatingRowStyle BackColor="PaleGoldenrod"></AlternatingRowStyle>

                            <FooterStyle BackColor="Tan"></FooterStyle>

                            <HeaderStyle BackColor="Tan" Font-Bold="True"></HeaderStyle>

                            <PagerStyle HorizontalAlign="Center" BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue">


                            <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite"></SelectedRowStyle>


                                <asp:BoundField DataField="FirstName" HeaderText="First Name" ReadOnly="true" />

                                <asp:BoundField DataField="LastName" HeaderText="Last Name" />

                                <asp:BoundField DataField="Age" HeaderText="Age" />












Step 4: 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 LINQInnerJoinApp


  public partial class _Default : System.Web.UI.Page


    protected void Page_Load(object sender, EventArgs e)



    protected void Button1_Click(object sender, EventArgs e)


        var query = objEntities.Employee.ToList().Skip(3);

        GridView1.DataSource = query;



    #region Instance MembersCompanyEntities objEntities = new CompanyEntities();





Step 5: The output of the application looks like this:


Step 6: The results retrieved 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



JetBrains ReSharper Ultimate
.NET code analysis, refactorings, navigation, unit testing, code coverage and profiling in Visual Studio, a bonus for C++ devs, bundled at 50% off.

Trending up