LINQ To SQL: First operator

In this blog we will be seeing how to Return the First Element in a Sequence

EmpDetails Table:




Code:

To Return the First Element 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();

EmpDetail empQuery = (from emp in dc.EmpDetails
                      where emp.Dept == "MOSS"
                      select emp).First();
Console.WriteLine("ID :{0}, Name :{1}, Location :{2}, Department :{3}", empQuery.ID, empQuery.Name, empQuery.Location, empQuery.Dept);
Console.ReadLine();
}
}
}

Output:


ID :1, Name :Vijai, Location :Bangalore, Department :MOSS


Alternate method:


DataClassesDataContext dc = new DataClassesDataContext();
EmpDetail empQuery = dc.EmpDetails.First();
Console.WriteLine("ID :{0}, Name :{1}, Location :{2}, Department :{3}", empQuery.ID, empQuery.Name, empQuery.Location, empQuery.Dept);
Console.ReadLine();