How to do "select count(*)" on ADO.NET Entity Framework

Question

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

Thanks!

Answer 1

Use the Count() LINQ operator. If you're using C#, there isn't anything in the query expression syntax to cover this, so you have to do call it with dot-notation.