lambda-LINQ-SQL对照表 - CSDN文库

lambda-LINQ-SQL

1星需积分: 10 71 浏览量更新于2023-03-16 评论收藏 18KB DOCX 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

资源详情

资源评论

资源推荐

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)))

本内容试读结束，登录后可阅读更多

下载后可阅读完整内容，剩余4页未读，立即下载

评论1

huaix黑夜

2013-01-15

这资料排版有问题，代码混成一团，看都看不懂

defaultname

粉丝: 0
资源: 3

会员权益专享

图片转文字

全年可省5，000元立即开通

最新资源

资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！点击此处反馈