score:1

Accepted answer

you can try the following sample code:

var results = _customertable.groupby(c => new {c.date, c.customer_type_id}).select(g => new {g.key.date, g.key.customer_type_id, mycount = g.count()});

using this way you can get number of recors per date and customer_type_id.


Related Query

More Query from same tag