how to select many tables on anonymous query

hi there

i have the follow linq query:

<div>

ctx.Contact.Include("Interlocutor").Include("ASI..Include("Attacth").include("customers")
.Where(c => idOKRAM == null || c.check_ram == idOKRAM)

</div>

how can i have an anonymous type?
if i write:
select new {d=>d.name..}

returns the data only from 1 table!
i need return from more table..how can i do?

Re: how to select many tables on anonymous query

You would have to do a Linq join to get data from more than one table

http://msdn.microsoft.com/en-us/library/bb311040.aspx

Re: how to select many tables on anonymous query

my manager suggested to use .Include("table") function

yes. i've seen the link above, thanks a lot
can you tel me if it is better use .Include than join?

thank you

Re: how to select many tables on anonymous query

You use include when you want the data for a related table to be included. So for example you were using the entity framework to pull a table from the northwind database. If you were querying the orders table you would need to use include to get the orderdetails loaded when the data is gotten from the database instead of when you use it.