Issue with Imultiple result sets
-
Hi, suppose my SP returns 8 results sets i want to fetch only the 8th resultset....the issue which im facing with IMultipleResults.GetResult<> is it is not able to give the 8th resultset...and i need to call all the 7 resultsets before i call 8th resultset....and please let me know how to fetch the 8th resultset directly.... As this is possible in classic ado.net using tablemapping to fetch the desired result set ...please let me know how this can be achieved using Linq to Sql..
-
Hi, suppose my SP returns 8 results sets i want to fetch only the 8th resultset....the issue which im facing with IMultipleResults.GetResult<> is it is not able to give the 8th resultset...and i need to call all the 7 resultsets before i call 8th resultset....and please let me know how to fetch the 8th resultset directly.... As this is possible in classic ado.net using tablemapping to fetch the desired result set ...please let me know how this can be achieved using Linq to Sql..
siva455 wrote:
please let me know how this can be achieved using Linq to Sql.
Maybe by posting in the LINQ forum.
Unrequited desire is character building. OriginalGriff
-
Hi, suppose my SP returns 8 results sets i want to fetch only the 8th resultset....the issue which im facing with IMultipleResults.GetResult<> is it is not able to give the 8th resultset...and i need to call all the 7 resultsets before i call 8th resultset....and please let me know how to fetch the 8th resultset directly.... As this is possible in classic ado.net using tablemapping to fetch the desired result set ...please let me know how this can be achieved using Linq to Sql..
I'd recommend rewriting your SP so it only returns the information needed. Since you're returning 8 results set and throwing out 7 of them, you're wasting compute resources on the SQL Server.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak -
I'd recommend rewriting your SP so it only returns the information needed. Since you're returning 8 results set and throwing out 7 of them, you're wasting compute resources on the SQL Server.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak -
Thanks for ur solution...but as my SP used across other places of code where they coonsume some of the resultsets in 8 resultsets.... Please suggest me is there a way to fetch only the particukar resultset from SP...
Then write another SP that only returns the resultset in question. Having a single SP that returns all kinds of data your don't need is very wasteful. Or dont use an SP and just code the SELECT string to return the data required.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak -
Hi, suppose my SP returns 8 results sets i want to fetch only the 8th resultset....the issue which im facing with IMultipleResults.GetResult<> is it is not able to give the 8th resultset...and i need to call all the 7 resultsets before i call 8th resultset....and please let me know how to fetch the 8th resultset directly.... As this is possible in classic ado.net using tablemapping to fetch the desired result set ...please let me know how this can be achieved using Linq to Sql..