将Linq中的2个表连接到实体框架并将结果传递给MVC视图。 [英] Left joining 2 tables in Linq to entity framework and pass the result to MVC view.

问题描述

如何使用LINQ to EF在2个表（实体）上执行左连接，然后将结果（模型）传递给要显示的视图。我不想建立一个新模型只需使用2个实体。



我需要帮助！

How can i perform a left join on 2 tables(entities)using LINQ to EF and then pass the result(model) to the view to be displayed. I don''t want to build a new model just use the 2 entities.

I need help please!

推荐答案

使用此链接： -



http://msdn.microsoft.com/en-us/library/bb896266.aspx [ ^ ]

use This Link:-

http://msdn.microsoft.com/en-us/library/bb896266.aspx[^]

var query =
from contact in contacts
join order in orders
on contact.ContactID
equals order.Contact.ContactID into contactGroup
select new
{
ContactID = contact.ContactID,
OrderCount = contactGroup.Count(),
Orders = contactGroup
};

这篇关于将Linq中的2个表连接到实体框架并将结果传递给MVC视图。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！