plese write Linq code for GroupBy

Question

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

Manas Mohapatra · 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

Ghouse Hussain · Answer

Thanks Bro Mr.Vicent maverick its really Good