Please refer below code
C#
protected void Page_Load(object sender, EventArgs e)
{
List<Employee> emps = new List<Employee>()
{
new Employee { ID = 1, Name = "Mark", Gender = "Male",
Department = "IT", Salary = 45000 },
new Employee { ID = 2, Name = "Steve", Gender = "Male",
Department = "HR", Salary = 55000 },
new Employee { ID = 3, Name = "Ben", Gender = "Male",
Department = "IT", Salary = 65000 },
new Employee { ID = 4, Name = "Philip", Gender = "Male",
Department = "IT", Salary = 55000 },
new Employee { ID = 5, Name = "Mary", Gender = "Female",
Department = "HR", Salary = 48000 },
new Employee { ID = 6, Name = "Valarie", Gender = "Female",
Department = "HR", Salary = 70000 },
new Employee { ID = 7, Name = "John", Gender = "Male",
Department = "IT", Salary = 64000 },
new Employee { ID = 8, Name = "Pam", Gender = "Female",
Department = "IT", Salary = 54000 },
new Employee { ID = 9, Name = "Stacey", Gender = "Female",
Department = "HR", Salary = 84000 },
new Employee { ID = 10, Name = "Andy", Gender = "Male",
Department = "IT", Salary = 36000 }
};
var result = from employee in emps
group employee by employee.Department into g
select new { Group = g.Key, Count = g.Count() };
}
public class Employee
{
public int ID { get; set; }
public string Name { get; set; }
public string Gender { get; set; }
public string Department { get; set; }
public int Salary { get; set; }
}
I hope this will help you out.
