LIQN join on 后跟多个条件

最新推荐文章于 2023-07-05 20:39:42 发布

diaohuyi6830

最新推荐文章于 2023-07-05 20:39:42 发布

阅读量272

点赞数

原文链接：http://www.cnblogs.com/tiancai/p/5035415.html

版权

本文详细对比了SQL查询、LINQ查询以及Lambda表达式的使用方法，通过具体案例展示了从传统SQL查询转换到现代.NET平台上的LINQ及Lambda表达式的全过程，对理解不同查询方式的异同及应用场合有极大帮助。

摘要由CSDN通过智能技术生成

sql 版：SELECT [t0].[OrderID], [t0].[CustomerID], [t0].[EmployeeID], [t0].[OrderDate], [t0].[RequiredDate], [t0].[ShippedDate], [t0].[ShipVia], [t0].[Freight], [t0].[ShipName], [t0].[ShipAddress], [t0].[ShipCity], [t0].[ShipRegion], [t0].[ShipPostalCode], [t0].[ShipCountry]
FROM [Orders] AS [t0]
INNER JOIN [Order Details] AS [t1] ON ([t0].[OrderID] = [t1].[OrderID]) AND ([t0].[OrderID] = [t1].[OrderID])
WHERE ([t0].[OrderID] > @p0) AND ([t0].[EmployeeID] = @p1)

　

　LINQ版：from o in Orders join od in OrderDetails on new {oid= o.OrderID,oeid=o.OrderID} equals new {oid=od.OrderID,oeid=od.OrderID }
where o.OrderID>1000 && o.EmployeeID==5
select o

lambda表达式版：

Orders
   .Join (
OrderDetails,
o =>
   new
   {
oid = o.OrderID,
oeid = o.OrderID
   },
od =>
   new
   {
oid = od.OrderID,
oeid = od.OrderID
   },
(o, od) =>
   new
   {
o = o,
od = od
   }
   )
   .Where (temp0 => ((temp0.o.OrderID > 1000) && (temp0.o.EmployeeID == (Int32?)5)))
   .Select (temp0 => temp0.o)

转载于:https://www.cnblogs.com/tiancai/p/5035415.html