[Solved]-Linq to SQL get distinct records grouped by date-LINQ,C#

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.