Load Multible Tables

Feb 28, 2015 at 2:43 PM
Is there any way i can load several tables at a time? (MultiResultSet)

On many ocasions i need to load several lists, like UnitOfMesure, VatType, PaymentCondition, etc...

Thanks,
Coordinator
Feb 28, 2015 at 3:54 PM
no, multiple selects in one roundtrip is not supported. Looking at table names, looks like these tables are ideal candidates for full-set cache - they will be preloaded in memory and stay there with regular expiration and reload. All selects, including custom LINQ queries will be rewritten into Linq2Objects and executed against in-memory data.
Look at EntityApp.CacheSettings, and register tables as fully cached in initialization of module or entity app.
Feb 28, 2015 at 4:46 PM
Very good :)

Thanks.