SQL-LINQ-Lambda语法对照.docVIP

SQL,LINQ,Lambda语法对照图 2010-07-07 12:05 如果你熟悉SQL语句,当使用LINQ时,会有似曾相识的感觉.但又略有不同.下面是SQL和LINQ,Lambda语法对照图 SQLLINQLambdaSELECT *FROM HumanResources.Employeefrom e in Employees select eEmployees .Select (e = e)SELECT e.LoginID, e.JobTitle FROM HumanResources.Employee AS efrom e in Employees select new {e.LoginID, e.JobTitle}Employees.Select (????? e = new {??????????? LoginID = e.LoginID, ??????????? JobTitle = e.JobTitle???????? }?? )SELECT e.LoginID AS ID, e.JobTitle AS Title FROM HumanResources.Employee AS efrom e in Employees select new {ID = e.LoginID, Title = e.JobTitle}Employees.Select (????? e = new ???????? {??????????? ID = e.LoginID, ??????????? Title = e.JobTitle???????? }?? )SELECT DISTINCT e.JobTitle FROM HumanResources.Employee AS e(from e in Employees select e.JobTitle).Distinct()Employees?? .Select (e = e.JobTitle)?? .Distinct ()SELECT e.* FROM HumanResources.Employee AS e WHERE e.LoginID = testfrom e in Employees where e.LoginID == test select eEmployees?? .Where (e = (e.LoginID == test))SELECT e.* FROM HumanResources.Employee AS e WHERE e.LoginID = test AND e.SalariedFlag = 1from e in Employees where e.LoginID == test e.SalariedFlag select eEmployees?? .Where (e = ((e.LoginID == test) e.SalariedFlag))SELECT e.* FROM HumanResources.Employee AS e WHERE e.VacationHours = 2 AND e.VacationHours = 10from e in Employees where e.VacationHours = 2 e.VacationHours = 10 select eEmployees?? .Where (e = (((Int32)(e.VacationHours) = 2) ((Int32)(e.VacationHours) = 10)))SELECT e.* FROM HumanResources.Employee AS eORDER BY e.NationalIDNumberfrom e in Employees orderby e.NationalIDNumber select eEmployees?? .OrderBy (e = e.NationalIDNumber)SELECT e.* FROM HumanResources.Employee AS e ORDER BY e.HireDate DESC, e.NationalIDNumberfrom e in Employees orderby e.HireDate descending, e.NationalIDNumber select eEmployees?? .OrderByDescending (e = e.HireDate)?? .ThenBy (e = e.NationalIDNumber)SELECT e.* FROM HumanResour