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?

Answer 1

Like that

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

or even easier

var purchCount = myBlaContext.purchases.Count(); 

Answer 2

You should be able to do the count on the purch variable:

purch.Count();

e.g.

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

purch.Count();