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?

Sonu K · Accepted Answer · 2022-01-25 05:47:55Z

91

Like that

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

or even easier

var purchCount = myBlaContext.purchases.Count();

edited Jan 25, 2022 at 5:47

Sonu K

2,8424 gold badges25 silver badges32 bronze badges

answered Jun 13, 2011 at 12:57

Andrei

56.8k10 gold badges92 silver badges114 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

George Duckett Over a year ago

@Bside: lblCount.Text = myBlaContext.purchases.Count().ToString()

Oshrib Over a year ago

@George Duckett, thank you. but i got the error: CS0103: The name 'lblCount' does not exist in the current context ... and i put lblCount on the aspx page...

George Duckett Over a year ago

@Bside: Depending on where on the page you put it, you might not be able to access it like that. This is a seperate question really now: how to access a control on an asp.net page. See msdn.microsoft.com/en-us/library/ms178509(v=vs.90).aspx

Raghuveer Over a year ago

@Anrei Are there any performance differences if we use myBlaContext.purchases.Count() vs (from purchase in myBlaContext.purchases select purchase.ID).Count()

Andrei Over a year ago

@irvgk, I suspect there might be. Actually you can use any sql profile you'd like to check the resulting sql query that linq generates, even for such similar queries it might differ. I will do that myself when I have a chance (not on windows at the moment)

Francis Gilbert · Accepted Answer · 2011-06-13 12:58:30Z

10

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();

answered Jun 13, 2011 at 12:58

Francis Gilbert

3,4522 gold badges24 silver badges27 bronze badges

Collectives™ on Stack Overflow

SELECT COUNT in LINQ to SQL C#

2 Answers 2

5 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related