This question is locked. New answers and comments are not allowed.
Michael Falconer
Top achievements
Rank 1
Rank 1
Michael Falconer
asked on 10 Aug 2009, 04:50 AM
Is there a way to have multiple queries called in a batch, as multiple resultsets? I'm doing this to reduce the number of trips spent to populate a screen - a group of queries are exectuted that populated different regions of the screen, and are returned as a multiple result set...
1 Answer, 1 is accepted
0
Hello Michael Falconer,
There is no direct way with OpenAccess to combine several queries to one client server call.
If the data is connected like in a Master/Detail view you can use our FetchPlan API to let us load the data in minimal C/S calls.
http://www.telerik.com/help/openaccess-orm/fetchplans.html
If you implement a web or application server you can use our second level cache to keep the data if it is fetched once.
http://www.telerik.com/help/openaccess-orm/2nd-level-cache.html
Sincerely yours,
Jan Blessenohl
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.
There is no direct way with OpenAccess to combine several queries to one client server call.
If the data is connected like in a Master/Detail view you can use our FetchPlan API to let us load the data in minimal C/S calls.
http://www.telerik.com/help/openaccess-orm/fetchplans.html
If you implement a web or application server you can use our second level cache to keep the data if it is fetched once.
http://www.telerik.com/help/openaccess-orm/2nd-level-cache.html
Sincerely yours,
Jan Blessenohl
the Telerik team
Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.