Group by with Count in MVC

Question

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