Comments by sowjanya bantupalli (Top 3 by date)

sorry to say this i didnt get result through this query pls check my query once
var x = from u in db.Appointment.AsEnumerable () where u.VisitingDepartmentName!=null group u by u.VisitingDepartmentName
into g select new { VisitingDepartmentName = g.Key ,
TotalNoofVisitors = g.Count(),
//TotalNoofVisitors=g==null ? 0:g.Count(),
Records = g
};
inresult count is zero it gives like this

System.Linq.IGrouping<string,ft.domain.appointment>' does not contain a definition for 'VisitingDepartmentName' and no extension method 'VisitingDepartmentName' accepting a first argument of type 'System.Linq.IGrouping<string,ft.domain.appointment>' could be found (are you missing a using directive or an assembly reference?) D:\sowjanya.b_old\Desktop\vmspractice\21-08\branches\VMS\FT.Data.Sql\Repositories\EmailConfigurationRepository.cs 175 69 FT.Data.Sql
this is error