如何从SQL Server中使用Linq在c#中获得不同的记录名称及其每个记录计数以绑定到gridview

如何获得不同的记录名称和它的每条记录计数绑定到gridview在c#使用Linq从SQL Server?

var txtquery = from ep in ebsuite.enquiryprocess
               where(UserID == ep.UserID)
               select new 
                        {
                            CourseName = ep.CourseName.Distinct(),
                            RecordCount = ep.Count()
                        }.SingleOrDefault();
return txtquery;

var txtquery = (from ep in ebsuite.enquiryprocess
        where ep.UserID == UserID && (ep.Start.Date >= startDate.Date && ep.Start.Date <= endDate)
        select new 
        {
            CourseName = ep.CourseName
        }).Distinct();
var count = txtquery.Count();
return txtquery;