Join with ADO.NET Linq to Entity in C#

Posted by aladdin on Stack Overflow See other posts from Stack Overflow or by aladdin
Published on 2010-12-23T23:36:16Z Indexed on 2010/12/24 2:54 UTC
Read the original article Hit count: 207

Filed under:
|
|
|

Hello

I'm try to migrate a system to ADO.NET Entity I have 3 table

A => (Id, Name, ...)
B => (Id, Domain, ...)
c => (IdA, IdB)

VS.NET generate 2 entity A and B and both have reference to the other table but this reference is a collection. I need make a join between tables.

from a in A join b in B on a.? equal b.?
where condition
select new { Name = a.Name, Domain = b.Domain };

I cant do that follow the reference in entity bu when the problem grows can be a problem. Any Help?

© Stack Overflow or respective owner

Related posts about c#

Related posts about entity-framework