Thanks again!

JD

  anOrder.Customer

 

If you do need to join entities which don't have an existing foreign key relationship, you can do so like you've done above.  For example, here's a contrived example to join Northwind Employees and Users based on their names:

 

var query = from e in entityManager.Employees
             join u in entityManager.Users
             on new { id1 = e.FirstName, id2 = e.LastName } equals new { id1 = u.FirstName, id2 = u.LastName }
             select e;

var results = query.ToList();

 

The types and names of properties in the anonymous types used in the join must be the same, and here the "id1" and "id2" names aren't required.
 

 

 

 

 

I'm trying to write an DevForce LINQ query where I need to join on multiple fields.  I looked in the documentation and found the examples for joins, but I didn't see an example that addressed this specific scenario.  I searched the web for linq queries with multiple field joins and here is what I found which does convey what I'm trying to do; I just need to figure out how to do it for DevForce.

Any help is greatly appreciated!!

JD