本文介绍了如何使转换SQL Inner连接查询与实体框架的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
这里有三个表Service_Orders,Project_Services和Company。服务订单和公司ID之间有3个表之间的内部连接。 我想要下面的查询使用C#或Vb将Lambda Express转换为Entity框架。
Here are three tables Service_Orders, Project_Services and Company. There is inner join between 3 tables by Service Order and CompanyID. I want below query to convert into Entity framework with Lambda Express using C# or Vb.
select top 10 * from [Service_Orders] a,[Project_Services] b,[Company] c where a.so_no = b.service_order and cpanyId = bpid推荐答案
Lambda语法:
var query = db.Service_Orders .Join(db.Project_Services, a => a.so_no equals, b => b.service_order, (a,b) => new { a, b }) .Join(db.Company, x => x.bpid, c => cpanyId, (x,c) => new { x.a, x.b, c }) .Take(10);更多可读查询语法:
var query = (from a in db.Service_Orders join b in db.Project_Services on a.so_no equals b.service_order join c in db.Company on bpid equals cpanyId select new { a, b, c }).Take(10);更多推荐
如何使转换SQL Inner连接查询与实体框架
发布评论