Linq Count with Condition

Question

I want to provide 2 condition's in the COUNT clause for checking ROLE & USERID.

Here is my code :-

var recordCount = ctx.Cases.Count();

How to give Where condition in Count()?

Answer 1

Just add a predicate to your Count() expression (and don't forget to include System.Linq):

var recordCount = ctx.Cases.Count(a => a.Role == "admin");

Answer 2

var recordCount = ctx.Cases.Count(a => a.Role == "admin" && a.Userid="userid");

Answer 3

First give Where and then count.

ctx.Cases.Where(c => your condition).Count();