ASP.NET - Get Single value! - Asked By myzonal.com myzonal.com on 27-Jun-12 05:22 AM

How we get single value from database through Lamda Expression or linq..........

Hi Frndz,

 

Functionality:  Gettting Single value using LINQ

 

 

To achieve this task,

 

Use SingleOrDefault Function

 

 

 

 

 

Make your Logic as following way

 

Logic ::

 

  DataClassesDataContext db = new DataClassesDataContext();

 

        var obj = (from tbl in db.tbl_empdetails

                 select tbl).SingleOrDefault();

 

        string empname = obj.empname;

 

Hope this helpful!

Thanks

 

 

 

what name space would be used  for "DataClassesDataContext" ?

Use this code-

DataClassesDataContext db = new DataClassesDataContext();


      var obj = (from data in db.tablename

         select data.fieldname).SingleOrDefault();

 


 

DataClassesDataContext  is DBML class

You can use FirstOrDefault function like this

In Linq:

(from p in context.EventMasters
where p.EventId==5
select p).FirstOrDefault()

In Lambda Exp:

context.EventMasters.Where(e=>e.EventId==5).Select(p => p).FirstOrDefault()

Hope this might help you.

Hi,

You can achieve this in LINQ using the below .

hi..


to get a single value from a collection using Lambda or linq you can use the Following functions.

.Take(1); // Takes the Single value from Collection , it is the basically the first value.
.Single(); // gets you the single value but raises an error if the result is more than one value.
.SingleorDefault(); // same as above Explained but additonally it works for null values also
.First() // Takes the First Record fromthe result set.
.FirstOrDefault() ; // Same as Above but additonally it works for null values also

you can use any one of the Above methods to take single value from the Collection

Post your linq query or the current lambda expression you have. We will tweak that and give you a solution. 
Otherwise, you will only get replies like below.

A Problem well stated is half solved.

Post your linq query or the current lambda expression you have. We will tweak that and give you a solution. 
Otherwise, you will only get replies like above.

A Problem well stated is half solved.