请教这个SQL语句怎么转成Linq的写法

请问这个SQL语句如何转成Linq的写法？

SQL code

select a.ActivityTheme, u.username,c.CustomerName,i.ActivityClassName,a.ActivityAddress,a.ActivityTimefrom tblActivity as a left join tblUser as u on a.UserId = u.UserIdleft join tblCustomer as c on a.CustomerId = c.CustomerIdleft join tblActivityClass as i on a.ActivityClassNo = i.ActivityClassNo

请指点，谢谢！

[解决办法]
var query = from a in tblActivity
join u in tblUser on a.UserId equals u.UserId into tempUser
join c in tblCustomer on a.CustomerId equals c.CustomerId into tempCustomer
join i in tblActivityClass on a.ActivityClassNo equals i.ActivityClassNo into tempActivityClass
from tu in tempUser.DefaultIfEmpty()
from tc in tempCustomer.DefaultIfEmpty()
from ti in tempActivityClass.DefaultIfEmpty()
select new
{
a.ActivityTheme,
tu.username,
tc.CustomerName,
ti.ActivityClassName,
a.ActivityAddress,
a.ActivityTime
};
[解决办法]
from a in tblActivity 
join u in tblUser on a.UserId equals u.UserId
join c in tblCustomer on a.CustomerId equals c.CustomerId
join i in tblActivityClass on a.ActivityClassNo equals i.ActivityClassNo 
select new
{
a.ActivityTheme, 
u.username,
c.CustomerName,
i.ActivityClassName,
a.ActivityAddress,
a.ActivityTime
};

查看更多 下一篇