Linq query to get count

Question

id | IsEnquiry  | 
=================
1      true
2      false
3      false
4      true

How can I get the count of id where IsEnquiry=true by using a Linq Query

Pls Help me to write the query.

Thanks, Bharath

Answer 1

int count = (from row in db.Table
             where row.IsEnquiry == true
             select row).Count();

Answer 2

try this

var count = db.Table.Where(x=>x.IsEnquiry).Count()