Multiple RecordSets

Nov 13, 2014 at 6:52 AM
If you ever build out for multiple recordset support, be aware that the column metadata is PER recordset, so the current structure of reading through ALL the recordsets and then grabbing the metadata will NOT work. Rather, the metadata needs to be stored for each cached group of rows.
Nov 14, 2014 at 6:58 AM
Thanks for the hint. I am aware of the fact that the shape for each result in a resultset can be different (I happen to be the author of the EF Code First Functions which does support multiple resultsets) and that each recordset is basically independent on any other in the same response. As a result I will need a copy of metadata, the number of affected rows and data for each of the recordsets.