LINQ to SQL Storing query results in a variable

c# linq linq-to-sql data-retrieval
user962206 picture user962206 · Feb 23, 2012 · Viewed 12.5k times · Source

For example I am searching for a specific persons ID and I want to store that ID to a local variable or instance variable. How do I retrieve Query results and stores them in a int Variable with LINQ to SQL? Assuming we have this query

from user in dbo.DoctorsName
where doctorsName  = "Foo Bar"
select DOC_ID;

Answer

Mahmoud Gamal picture Mahmoud Gamal · Feb 23, 2012

You can use FirstOrDefault() like this:

var results = from user in dbo.DoctorsName
              where user.doctorsName  == "Foo Bar"
              select user;

string personName = results.FirstOrDefault().Name;

Related questions

Difference Between Select and SelectMany

I've been searching the difference between Select and SelectMany but I haven't been able to find a suitable answer. I need to learn the difference when using LINQ To SQL but all I've found are standard array examples. Can someone …

Read More
Convert Linq Query Result to Dictionary

I want to add some rows to a database using Linq to SQL, but I want to make a "custom check" before adding the rows to know if I must add, replace or ignore the incomming rows. I'd like to …

Read More
Returning IEnumerable<T> vs. IQueryable<T>

What is the difference between returning IQueryable<T> vs. IEnumerable<T>, when should one be preferred over the other? IQueryable<Customer> custs = from c in db.Customers where c.City == "<City>" select …

Read More