SELECT COUNT in LINQ to SQL C#

Question

How can I write LINQ to SQL with COUNT?

Example:

var purch = from purchase in myBlaContext.purchases
            select purchase;

How can I get the count here?

question from:https://stackoverflow.com/questions/6330682/select-count-in-linq-to-sql-c-sharp

Answer 1

Like that

var purchCount = (from purchase in myBlaContext.purchases select purchase).Count();

or even easier

var purchCount = myBlaContext.purchases.Count()