实现MVC4中的连接功能 [英] achieving joining functionality in MVC4

问题描述

我是MVC4的新手。谁能告诉我如何在mvc中编写连接查询。在sql server中，内部连接查询是选择p.Name，p.Phone来自dbo.Properties P inner join dbo.DevelopersProperties DP on p.Id = DP.PropertyId inner join dbo.Developers D on d.Id = dp.DeveloperId where d.Id = 1

i am new to MVC4. can anyone tel me how to write join queries in mvc. in sql server the inner join query was select p.Name,p.Phone from dbo.Properties P inner join dbo.DevelopersProperties DP on p.Id = DP.PropertyId inner join dbo.Developers D on d.Id=dp.DeveloperId where d.Id=1

推荐答案

请看这个链接



http://www.dotnet-tricks.com/Tutorial/linq/UXPF181012-SQL-Joins-with-C [ ^ ]

var ab =来自tblproperties中的ba

加入ba.developerId中的tbldevelopers等于a.developerid

select新的

{

ba.name，

ba.phone

};

var ab = from ba in tblproperties
join a in tbldevelopers on ba.developerId equals a.developerid
select new
{
ba.name,
ba.phone
};

这篇关于实现MVC4中的连接功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！