groupby and count in linq for mvc5

See more:

MVC

hai
i want to display the count of number of employees by department wise.
with that count i want to display the total table information based on department
like totalnoofvisitors visitorname companyname(these are columns) i want like this i was write a query like below

var x = from u in db.Appointment group u  by u.VisitingDepartmentName  into g select new { VisitingDepartmentName = g.Key,
                                                                                                                  TotalNoofVisitors = g.Count(),
                                                                                                                // TotalNoofVisitors=g==null ? 0:g.Count(),
                                                                                                                 Records = g
                       };

this query gives count is zero and gives the information whosedepartmentname is zero
please help me