linq to sql使用lambda联接多列 [英] linq to sql join on multiple columns using lambda

问题描述

有人可以帮我翻译吗

var query = from s in context.ShoppingMalls
join h in context.Houses
on
new { s.CouncilCode, s.PostCode }
equals
 new { h.CouncilCode, h.PostCode }
select s;

进入lambda查询?

into lambda query?

谢谢.

推荐答案

var query = context.ShoppingMalls
                   .Join(
                       context.Houses,
                       s => new { s.CouncilCode, s.PostCode },
                       h => new { h.CouncilCode, h.PostCode },
                       (s, h) => s);

这篇关于linq to sql使用lambda联接多列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！