Hi, Some databases (SQL Server for one) allow returning multiple recordsets from stored procedures. I was thinking of looking into adding support for this for NH. Does anyone have any thoughts about this? Are there any strong feelings for/against doing this?
* Doing this is similar to multiquery, but it's not identical; in some cases, the stored proc will use the same data to return separate data sets (e.g. by processing a large amount of data into a temp table, then returning multiple resultsets from that.) There can be performance benefits for doing this from the DB point of view. * I'm not sure how many DB vendors support this - whether it would be SQL Server-specific or not. It would need to be implemented using the ADO.NET DbDataReader#NextResult method. It might be best to put this into NHContrib, but it might require some changes to the nh-mapping schema. * I'm not sure whether EF4 supports this out of the box, but in EF3 it was apparently relatively straightforward to add: http://blogs.msdn.com/b/meek/archive/2008/03/26/ado-entity-framework-stored-procedure-customization.aspx (search for 'Multiple result sets') Let me know if you have any thoughts/suggestions/pointers on how to implement. Cheers, Nick
