Join with ADO.NET Linq to Entity in C#
- by aladdin
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?
