How to make "select count (*)" in the ADO.NET Entity Framework

Question

How can I do "select count (*)" using the ADO.NET Entity Framework?

Thanks!

Answer 1

Use the Count () LINQ operator. If you use C #, there is nothing in the syntax of the query expressions to cover this, so you need to do this using dot notation.