Simple.Data and support for futures

[Vagif Abilov]

Some ORMs (e.g. NHibernate) have nice feature that enables fetching multiple results within a single roundtrip to a database. Here's example of how this works:

http://ayende.com/blog/3979/nhibernate-futures

Ayende has a good use case example that a web site front page may fetch the following data (all in one db call!):

• A grid that allow us to page through the blogs.
• Most recent posts.
• All categories
• All tags
• Total number of comments
• Total number of posts

I wonder if there are any needs/plans of supporting this in Simple.Data.

Vagif

[Vagif Abilov]

To add to my post: there is a NextResult method defined in SimpleResultSet. Can it be applied to anything but a result set returned by a stored procedure call? I.e. can fetching of multiple results be triggered by Simple.Data API, not calls to stored procedures?

[Mark Rendle]

Not yet, but one of the features on the list for 2.x is batches, which could easily incorporate what you're proposing.

--
You received this message because you are subscribed to the Google Groups "Simple.Data" group.
To unsubscribe from this group and stop receiving emails from it, send an email to simpledata+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.