ROW_NUMBER Conversion

[John Gathogo]

Hi Guys, Am trying to LINQ the following statement: Please, if you can help out, please do.

SELECT
ROW_NUMBER() OVER (ORDER BY LastName, FirstName) AS RowNumber,
*
FROM
dbo.Customers
ORDER BY
CustomerID

[bonkers]

Customers.AsEnumerable().OrderBy(obj => obj.LastName).Select((obj, index) => new {Index = i++, obj}); Or something like that...