I was trying to use left join, but an existing answer said make my life easier by using from + from + select new. That worked, but instead of specifying each column in select new{}
can I just have all columns?
For example, from
var items = from a in context.Table1
from b in context.Table2.Where(x=> a.Column1 == b.Column1).DefaultIfEmpty()
select new
{
Column1 = a.Column1
Column2 = a.Column2
.....
Column10 = b.Column5
};
to something like
var items = from a in context.Table1
from b in context.Table2.Where(x=> a.Column1 == b.Column1).DefaultIfEmpty()
select all;