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.

var firstemp1=
from e in Employees
select new
EmpNum = e.EmpNum,
EmpJoinDate = e.EmpJoinDate.Min()

Sign In or Register to comment.