sql连接查询到linq语法

SELECT column1, column2, ...
FROM table_name
WHERE condition
ORDER BY column1, column2, ... ASC|DESC;

var query = from item in table_name
            where condition
            orderby column1, column2, ... ascending/descending
            select new { column1, column2, ... };

SELECT FirstName, LastName
FROM Employees
WHERE Salary > 50000
ORDER BY LastName ASC;

var query = from employee in Employees
            where employee.Salary > 50000
            orderby employee.LastName ascending
            select new { employee.FirstName, employee.LastName };