views:

55

answers:

0

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