I am using MVC and following is my Database table Table Name : DeptTask TaskID EmpID Task Dept Status 1 101 xxc Admin C 2 102 xxxf Admin P 3 101 xxxr Admin P 4 101 xe Admin P 5 104 xh Admin P 6 104 xj Admin P I want output list like this in Index view How can I do please help, Thanks in advance. EmpID Staus Count Status 101 C 1 101 P 2 102 P 1 104 P 2

please try this code var authorCategoryRecipies = from r in db.DeptTasks group r by new { r.Emp.EmpName, r.Status } into g orderby g.Key.EmpName select new { EmpName = g.Key.EmpName, StatusTag = g.Key.Status, RecipeCount =g.Count(r=>r.Status) }; if any Query then tell me...

Can it is possible to use linq I trying for this var authorCategoryRecipies = from r in db.DeptTasks group r by new { r.Emp.EmpName, r.Status } into g orderby g.Key.EmpName select new { EmpName = g.Key.EmpName, StatusTag = g.Key.Status, RecipeCount = g.Count() }; But no idea how to use in mvc

Hi Raju, You can create store procedure as below and get expected result. Create model with whichever property you want and call store procedure to get expected result. Create Procedure Usp_GetStatusCount As Begin select empId as EmpId, Status as Status, count (Status) as [ Count Status] from DeptTask group by Status, EmpId End