Merging nested tables in linq to sql -

Merging nested tables in linq to sql -

i have linq query gets info odata reporting service far good, when homecoming info :

select new {timesheetactual , timesheetline,timesheet, timesheetproject,timesheettask, subtv, timesheetresource, subres, pleft}

it returns collection of nested collections.

for service need 1 big table every column every record. know possible explicitly naming every column in select statement this:

select new { timesheetactual.column1, timesheetactual.column2, .., timesheetline.column1,.., timesheetproject.column1,..}

but due massive amount of columns i'm little reluctant way.

so question, there way either merge collections or way same result without having specify 100+ columns?

linq-to-sql