This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
Hi I have a join
Both EntityOne and EntityTwo have their own properties that should be eager loaded through the aggregate. If I do:
Neither of them has the properties specified in the aggregate eager loaded. I can see the SQL being issued actually sends a SQL query including the aggregates relevant for EntityOne, but doesn't hydrate entity properties (and the generated SQL completely omitted aggregates for EntityTwo). On the contrary, if I don't use the tuple and just load each of the entities collection separately, they get eager loaded correctly. Like this:
In this case 1st query gets EntityOnes with its aggregates, and 2nd query gets EntityTwo with its aggregates (and in both cases off the initial join). That's a bug, isn't it? |
|
|
Yes this sounds incorrect, the eager load should be applied in this situation. I have set up an equivalent scenario here with the code above and the eager loading is working correctly for me - are you able to send through a small repro project (ConsoleApplication or UnitTest) which I can use to reproduce this behavior and I can have a look into this for you. Also which version of LightSpeed are you using? Are you able to retry this with a current nightly build if you are not using this already?
|
|