Here's my SQL query:

SELECT EmployeeID, EmployeeLastName + ', ' + EmployeeFirstName AS Name
FROM employees
ORDER BY Name

How can I go about doing the samething in LINQ to SQL?