Linq to Sql
-
Hi, I have a Stored Procedure in SQL server which returns multiple tables... using IMultipleResults in Linq to SQl is there a way to fetch only one table from the result ....Please help me regarding the same....
Can't you cut down the stored proc to give just the results you want? Otherwise you're making the DB do more work than necessary, bad for performance and scalability.
Regards, Rob Philpott.
-
Can't you cut down the stored proc to give just the results you want? Otherwise you're making the DB do more work than necessary, bad for performance and scalability.
Regards, Rob Philpott.
-
Hi, I have a Stored Procedure in SQL server which returns multiple tables... using IMultipleResults in Linq to SQl is there a way to fetch only one table from the result ....Please help me regarding the same....
-
ya thats true but that is not giving me the desired result, we need to fetch other results also prior to this(need to follow the sequence of result sets returned from the sp)..if my result is last one in the SP.....
-
sounds like you have to seperate your mega SP into smaller SPs to me then, still cant see why this is a prob without some code
actually i cannot change my sp ,bcos this is used in many other places of code they fetch particular resultset which i require.... so please let me knoiw is there a way to fetch only the resultset i need from sp using Imultiplerersults..... As this is achievable in classic ado.net using tablemappings where we can fetch the desired resultset from SP. please let me know how this can be achieved in Linq to SQL....