Is this query equivalent to a LEFT OUTER join?
var rows = from a in query
join s in context.ViewSiteinAdvise on a.Id equals s.SiteInAdviseId
where a.Order == s.Order
select new
{....};
I tried this but it did not result
from s in ViewSiteinAdvise
join q in query on s.SiteInAdviseId equals q.Id into sa
from a in sa.DefaultIfEmpty()
where s.Order == a.Order
select new {s,a}
I need all columns from View