About Linq left join

Question

select A.Name,B.UserId
from [dbo].[SentryBoxs] as A
left join [dbo].[SentryBoxUsers] as B on A.ID = B.SentryBoxId
and B.UserId = '970500c2-51bd-443e-ae10-585455f2b326'

How to implement by linq???

Answered here:http://stackoverflow.com/questions/3404975/left-outer-join-in-linq — , Apr 30 '17 at 15:04

score 0 · Answer 1 · answered May 01 '17 at 19:07

var ans = from A in dboSentryBoxs
          join B in dboSentryBoxUsers on new { A.ID, UserID = "970500c2-51bd-443e-ae10-585455f2b326" } equals new { ID = B.SentryBoxId, B.UserID } into Bjoin
          from B in Bjoin.DefaultIfEmpty()
          select new { A.Name, B.UserID };

About Linq left join

1 Answers1