Min / aggregate function
Can anyone please tell me what is wrong with my syntax? using C# in Linq. I need to display the employee with the earliest start date (i.e. min join date). Any assistance would be greatly appreciated. Many thanks.
from e in Employees
EmpNum = e.EmpNum,
EmpJoinDate = e.EmpJoinDate.Min()