Rank 1
Try 1
from a in table1
join b in table2 on new {a.code, a.aa} equals new {b.code, b.aa}
join c in table3 on b.id equals c.id
where ....
Try 2
from a in table1
from b in table2
from c in table 3
where a.code == b.code && a.aa == b.aa && b.id == c.id
...
Try 3
from a in table1
from d in ( from b in table2 join c in table3 on b.id equals c.id select new {t1 = b, t2 = c})
where a.code = d.t1.code && a.aa == d.t1.aa
...
3 Answers, 1 is accepted
We are experiencing some issue regarding more complex join situation such as yours. We are working on improving this. However the fix might not be included in the following release. We will add these scenarios in our test suite and work on them after the Q3 release.
However for the time being, can you please give us a little more insight on what you are trying to accomplish as surely this query could be split into two (or more) simpler queries that would execute.
I am looking forward to resolving this issue and I am sorry for any inconvenience caused.
Serge
the Telerik team
Rank 1
I'm using Q3 2010
and I have the same problem
the Composite Key Join is not working
it give an exception when compiling says error in join clause
Could you please elaborate a bit more on you case as I cannot reproduce this behaviour at the moment. Are you using the designer and if so are you reverse mapping or just creating your model through it.
What is the exact message of the exception you are seeing and if there is no exception please share with us the output of the build process. If it is not too much trouble I would ask you to open a separate support thread and send us your project there so that we can further investigate this issue.
I am looking forward to resolving this problem.
Serge
the Telerik team