.net 6开发linq与lambda写法对照

C#开发中linq与lambda写法对照，在使用C#编程过程中，有些码农在实现查询功能的时候纠结于到底使用linq还是lambda来写代码，有些还搞不清楚，现就两者之间写法的比较整理一个表格供参考，具体表格如下。linq与lambda写法对照对于新手来说有点用。

linq与lambda写法对照

SQL	LINQ	Lambda
SELECT * FROM Employee	from e in Employees select e	Employees.Select ()
SELECT e.LoginID,e.JobTitle FROM 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 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 } )

完整内容出自这儿： C#开发中linq与lambda写法对照