Element Operators

Home	Table Design

First - Simple

This sample uses First to return the first Name element as a result where age is less than 20.

SQL:

SELECT top 1 CustID, Name, Sex, Education, IsStudent, Age, ContactNo
FROM Customer
WHERE Age < 20

LINQ:

DataClassesDataContext db = new DataClassesDataContext();
var result = (from c in db.Customers
where c.Age < 20
select c).First();

Lambda:

var result = db.Customers.Where(c => c.Age < 20).First();

if (result!= null)
Response.Output.WriteLine("{0}<br> ", result.Name);
 
Result:

Ayush Patel

FirstOrDefault - Simple

This sample uses FirstOrDefault to try to return the first element of the sequence, unless there are no elements, in which case the default value for that type is returned.

DataClassesDataContext db = new DataClassesDataContext();

LINQ:

var result = (from c in db.Customers
where c.Age < 20
select c).FirstOrDefault();

Lambda:

var result = db.Customers.Where(c => c.Age < 20).FirstOrDefault();

if (result!= null)
Response.Output.WriteLine("{0}<br> ", result.Name);

Result:

Ayush Patel

==============================================
Shradhdha Zalavadiya |Senior Software Engineer

WebMingle Technology
Accelerated by knowledge. Driven by values.
www.webMingle.in