Sql-Linq-Lambda对照表
| Sql | Linq | Lambda |
|
SELECT * FROM Employee |
from e in Employee select e |
Employee .Select(e => e) |
|
SELECT ID, Title FROM Employee |
from e in Employee select new {ID = e.ID, Title = e.Title} |
Employee .Select(e => new {ID = e.ID, Title = e.Title}) |
|
SELECT DISTINCT Title FROM Employee |
(from e in Employee select e.Title).Distinct() |
Employee .Select(e => e.Title).Distinct () |
|
SELECT e.* FROM Employee AS e WHERE e.ID = 1 |
from e in Employee where e.ID == 1 select e |
Employee .Where(e => (e.ID == 1)) |
|
SELECT e.* FROM Employee AS e WHERE e.ID = 1 AND(OR) e.Flag = 1 |
from e in Employee where e.ID == 1 &&(||) e.Flag select e |
Employee .Where(e => ((e.ID == 1) &&(||) e.Flag)) |
|
SELECT e.* FROM Employee AS e WHERE e.ID >= 1 AND(OR) e.ID <= 3 |
from e in Employee where e.ID >= 1 &&(||) e.ID <= 3 select e |
Employee .Where(e => ((e.ID >= 1) &&(||) (e.ID <= 3))) |
|
SELECT e.* FROM Employee AS e ORDER BY e.ID |
from e in Employee orderby e.ID select e |
Employee .OrderBy(e => e.ID) |
|
SELECT e.* FROM Employee AS e ORDER BY e.ID DESC, e.Title |
from e in Employee orderby e.ID descending, e.Title select e |
Employee .OrderByDescending(e => e.ID) .ThenBy(e => e.Title) |
|
SELECT SUM(e.Times) FROM Employee |
Employee .Sum(e => e.Times) |
|
|
SELECT e.Title, SUM(e.Times) AS TotalTimes FROM Employee AS e GROUP BY e.Title |
from e in Employee group e by e.Title into g select new {Title = g.Key, TotalTimes = g.Sum(e => e.Times)} |
Employee .GroupBy(e => e.Title) .Select( g => new {Title = g.Key, TotalTimes = g.Sum(e => e.Times)} ) |
|
SELECT e.Title, SUM(e.Times) AS TotalTimes FROM Employee AS e GROUP BY e.Title HAVING COUNT(*) > 1 |
from e in Employee group e by e.Title into g where g.Count() > 1 select new {Title = g.Key, TotalTimes = g.Sum(e => e.Times)} |
Employee .GroupBy(e => e.Title) .Where(g => (g.Count > 1)) .Select( g => new {Title = g.Key, TotalTimes = g.Sum(e => e.Times)} ) |
|
SELECT * FROM Product AS p INNER JOIN Employee AS e ON p.EmployeeID = e.ID |
from p in Product join e in Employee on p.EmployeeID equals e.ID select new {p, e} |
|
|
SELECT p.EmployeeID FROM Product AS p UNION SELECT e.ID FROM Employee AS e |
(from p in Product select p.EmployeeID).Union( from e in Employee select e.ID) |
Product.Select(p => p.EmployeeID).Union( Employee.Select(e => e.ID) ) |
|
SELECT TOP (10) * FROM Product AS p WHERE p.EmployeeID = 1 |
(from p in Product where p.EmployeeID = 1 select p).Take(10) |
Product .Where(p => (p.EmployeeID = 1)) .Take(10) |
|
SELECT * FROM Product AS p WHERE p.EmployeeID IN( SELECT e.ID FROM Employee AS e WHERE e.Flag = 1 ) |
from p in Product
where (from e in Employee where e.Flag == 1 select e.ID).Contains(p.EmployeeID) select p |
Product
.Where( p => Employee .Where(e => (e.Flag == 1)) .Select(e => e.ID).Contains(p.EmployeeID) ) |
