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 Articles