0

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;
Damn Vegetables
  • 11,484
  • 13
  • 80
  • 135

0 Answers0