SELECT *
FROM
HumanResources.Employee
from e in Employees
select e
Employees
.Select (e => e)
SELECT e.LoginID, e.JobTitle
FROM
HumanResources.Employee AS e
from 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 e
from 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 = 'test'
from e in Employees
where e.LoginID == "test"
select e
Employees
.Where (e => (e.LoginID ==
"test"))
SELECT e.*
FROM
HumanResources.Employee AS e
WHERE e.LoginID = 'test' AND
e.SalariedFlag = 1
from e in Employees
where e.LoginID == "test" &&
e.SalariedFlag
select e
Employees
.Where (e => ((e.LoginID ==
"test") && e.SalariedFlag))
SELECT e.*
FROM
HumanResources.Employee AS e
WHERE e.VacationHours >= 2
AND e.VacationHours <= 10
from e in Employees
where e.VacationHours >= 2 &&
e.VacationHours <= 10
select e
Employees
.Where (e => (((Int32)
(e.VacationHours) >= 2) &&
((Int32)(e.VacationHours) <=
10)))
评论1