LINQ To SQL:Take<TSource> operator

EmpDetails Table:

LinqTable.png


Code:


 To return a given number of elements in a sequence



using
System;
using
System.Collections.Generic;
using
System.Linq;
using
System.Text;
namespace
LINQ
{
class Program
{
static void Main(string[] args)
{
DataClassesDataContext dc = new DataClassesDataContext();
IQueryable<EmpDetail> empQuery = (from emp in dc.EmpDetails
                                   select emp).Take(2);
foreach (EmpDetail empDetail in empQuery)
{
Console.WriteLine("ID :{0}, Name :{1}, Location :{2}, Department :{3}", empDetail.ID, empDetail.Name, empDetail.Location, empDetail.Dept);
}
Console.ReadLine();
}
}
}


Output:


Returns the first two data from the EmpDetails table as shown in the following

Output.png


Note:

IQueryable<T> interface :Provides functionality to evaluate queries against a specific data source wherein the type of the data is known.
Next Recommended Reading LINQ To SQL: Sum operator