Now I want to get list of Employee but skip first 2 Employee. So if I have say for e.g. 5 Employee then I want to get 3 - 5 Employee and skip Employee 1 and 2.

This code snippet for Linq Query To Select Top 3 Records.

I have a list that I need sorted by two fields. I've tried using OrderBy in LINQ but that only allows me to specify one field. I'm looking for the list to be sorted by the first field and then if there are any duplicates in the first field to sort by the second field.

I have a list that I need sorted by two fields. I've tried using OrderBy in LINQ but that only allows me to specify one field. I'm looking for the list to be sorted by the first field and then if there are any duplicates in the first field to sort by the second field.

This example explains Sorting operator OrderByDescending. A sorting operator arranges the elements of the collection in descending order.

This tutorial explains Sorting operators: OrderBy . A sorting operator arranges the elements of the collection in ascending order.

Linq where clause condition filtering operator with example. In linq where clause operator is used to filter list collection data based on filtering conditions.

here I am going to give you a simple example, how to write SQL Query using pagination and Get total row number in a single select statement in SQL Server.

Here I am going to give you a simple example, how to write and execute dynamic SQL Query in SQL Server. You can execute the Query using EXEC sql command and sp_executesql commands in SQL Server.

I see the use of the NOLOCK hint in existing code for my stored procedures and I am not exactly sure if this is helpful or not. It seems like this has been a practice that was put in place and now is throughout all of the code wherever there are SELECT statement

Page 2 of 19