我是Entity Framework的新手,正在尝试将一个多表连接转换为使用Entity Framework。原始的SQL大致如下:
JOIN tab_NewsCommunities S1 ON S1.News_ID = tab_News.NewsID
inner join tab_communities com on S1.Community_ID = com.Community_ID and com.RecordStatus_ID = 2
JOIN tab_Communities c ON S1.Community_ID = c.Community_ID
JOIN tab_Favorites uf ON S1.Community_ID = uf2.Community_ID
WHERE uf.[User_ID] = @UserId
新的实体模型大致如下,我对其进行了简化。有人能帮我将SQL转换为LINQ或Lambda吗?我在网上看到了很多示例,但它们都是单表连接。谢谢。