Web developers use optional LINQ Skip clause when they want to bypass, specified by the count parameter, elements at the beginning of a results list and return the remaining elements. Web developers can combine the Skip clause with the Take clause to return a range of data from any segment of a query, by passing the index of the first element of the range to the Skip clause and the size of the range to the Take clause.

C# 8.0 and .NET Core 3.0 – Modern Cross-Platform Development: Build applications with C#, .NET Core, Entity Framework Core, ASP.NET Core, and ML.NET using Visual Studio Code, 4th Edition
ASP.NET Core 3 and Angular 9: Full stack web development with .NET Core 3.1 and Angular 9, 3rd Edition
C# in Depth, 4th Edition

Web developers can use the SkipWhile clause to specify that only certain elements are ignored, depending on a supplied condition.

The next code example uses the combination of Skip and Take clause to return data from a query in pages. The GetProducts function uses the Skip clause to bypass the products in the list until the supplied starting index value, and uses the Take clause to return a page of products starting from that index value:


Public Sub PagingProducts()

Dim pgNum As Integer = 0

Dim pgSz    As Integer = 15

Dim productsPg =  GetProducts(pgNum*pgSz, pgSz)

Do While producsPg IsNot Nothing

Console.WriteLine(vbCrLf & “Page: ” & pgNum + 1 & vbCrLf)

For Each prd In productsPg

Console.WriteLine(prd.ProductID & “, ” & prd.Company)



pgNum = pgNum + 1

productsPg =  GetProducts(pgNum*pgSz, pgSz)


End Sub



Public Function GetProducts(ByVal begIndex as Integer, _

ByVal pgSz as Integer) as List (Of Product)

Dim products = GetProductList()

Dim result = From prod In products _

Skip begIndex Take pgSz

If result.Count = 0 Then Return Nothing

Return result

End Function


Your hosting company should support SQL 2008 hosting to host ASP.NET with MS SQL 2008.