Hi,
I've noticed that if I use a where statement before a Count statement in a select after a group by, the where statement is completely ignored.
For example
from x in dataContext.Table
where x.Parameter == value
group x by x.Value into y
select new {y.Key, FilteredCount = y.Where(z => z.SomeValue == true).Count()}
The filter "z => z.SomeValue == true" never gets evaluated and the count includes all items, not just ones that pass the filter.