<div>
Any reason why you are not using Views or Linq etc.?
</div>


Any reason why you are not using Views or Linq etc.?

<div>
Thanks for your prompt reply.<br />
<br />
My requirement is to get the grid data on demand paging, for this i need one proc to get data from different tables with filter and page number.<br />
Secondly i need the total row count based on filter applied, for that i am using another proc to get the count only. <br />
<br />
I want to merge those two proc to get my required data(result table and count) in one go.<br />
As my query is big so I can't rely on Linq for optimization.<br />
<br />
Thanks and regards
</div>


Thanks for your prompt reply.

My requirement is to get the grid data on demand paging, for this i need one proc to get data from different tables with filter and page number.
Secondly i need the total row count based on filter applied, for that i am using another proc to get the count only.

I want to merge those two proc to get my required data(result table and count) in one go.
As my query is big so I can't rely on Linq for optimization.

Thanks and regards

Mahesh Yadav

<div>
<div class="content wysiwyg-content">
Hi, <br />
I am searching a solution to get the multiple table set from stored procedure using edmx entity framework. I found the below solution but that uses ADO.net. Is there any approach/sample code to get dataset(multiple tables) from stored procedure without ADO.<br />
<br />
<a href="https://github.com/KrisJohnstone/RandomCodeSamples/tree/master/MultipleResultSets" rel="ugc">https://github.com/KrisJohnstone/RandomCodeSamples/tree/master/MultipleResultSets</a><br />
Below are the project specifications:<br />
.Net Framework: 4.7.1<br />
VS2017<br />
SQLServer2016<br />
MVC: 5.2
</div>
</div>


Hi, 
I am searching a solution to get the multiple table set from stored procedure using edmx entity framework. I found the below solution but that uses ADO.net. Is there any approach/sample code to get dataset(multiple tables) from stored procedure without ADO.

https://github.com/KrisJohnstone/RandomCodeSamples/tree/master/MultipleResultSets
Below are the project specifications:
.Net Framework: 4.7.1
VS2017
SQLServer2016
MVC: 5.2

Use stored proc to get multiple table using entity framework

Microsoft’s ASP.NET MVC is a web application framework that implements the model–view–controller (MVC) pattern. As an open-source software, it’s set apart from the ASP.NET Web Forms component, which is proprietary.

.NET MVC

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.