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
|
If we use WithAggregate() in LinqPad queries the generated SQL does not match the generated SQL from LightSpeed in our application. WithAggregate in LinqPad generates one SQL query per foreign key (same as without WithAggregate), while our application generates one SQL query per table (it does not use joins). |
|
|
Hmm, I've just tried this and it's working correctly for me, generating the eager-load statements as part of the initial batch. However, it looks like something is then causing associated entities to be re-queried, even though they have correctly been eager loaded. I think this may be lazy reverse associations as LINQPad eagerly traverses the lazy load graph. |
|