plese write Linq code for GroupBy

Question

help me how to convert below query into Linq   select deptname,count(*) from employee groupby department   And also select deptname,totalemployee count(*) from employee group by depart

Manas Mohapatra · Accepted Answer

Try like below:   var tempResult = from rec  in  employee   group rec by rec.department into g   orderby rec.department    select  new  { Dept = g.Key, Numbers = g.Count() };       foreach  (var g  in  tempResult)   {      Console.WriteLine( "Department: "  + g.Dept +  " TotalEmployee: "  + g.Numbers);   }

Vincent Maverick Durano · Answer

Hi,   Would it be nice if you learn it by yourself instead so can do things easily in the future.   https://msdn.microsoft.com/en-us/library/bb545971.aspx

Answer

Thanks Bro Mr.Vicent maverick its really Good