Entity Framework: Count() very slow on large DbSet and complex WHERE clause
I need to perform a count operation on this Entity Framework (EF6) data set using a relatively complex expression as a WHERE
clause and expecting it to return about 100k records.