I use Aurelius and XData.
I have 3 tables in relation to master detail such as tests / questions and their answers. and so on
I built with Aurelius several entities over these tables.
I try to preload in the client application (currently it is windows but I intend it to be an android application) an approximate number of 350 questions with their answers of approximately 350 x 5 records for the disconnected use of data.
This preload takes relatively long. About 1 minute.
Sql-urille results seem ok, have good execution plan.
The sql server runs a large number of sqls that probably make loading difficult.
I could write 3 sql to bring this data but the idea is to use the framework to do that.
I tried to remove LazyLoad but the loading time did not improve.
What would be the best strategy to load a number of entities with the related details?
What sections of the documentation should I read?