.net - How to get data from 2 tables without joining them? -

i need write on linq2sql analogue of following query:

select a.field1, b.field2 tablea a, tableb b 

how can that?

i start this

from in dbcontext.tablea,  ... select new {field1=a.field1, field2=b.field2}; 

but should write instead of "..."? how mention 2nd table linked?

thanks.

p.s. hope clear

to cross join, try

from in dbcontext.tablea b in dbcontext.tableb select new {field1=a.field1, field2=b.field2};