Concat with Alias in LINQ to SQL

[Darkmatter5]

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?

[MattP]

Extend your Employee Linq class.

Partial Public Class Employee

    Public ReadOnly Property LastFirstName() As String
        Get
            Return FirstName & " " & LastName
        End Get
    End Property

End Class

        Dim employees = From e In ctx.Employees
                        Order By e.Name
                        Select e.EmployeeId, e.Name