Task Lead

Crystal Rouse

<div>
I am sorry, My question is misleading. &nbsp;I need to be able to add my Stored Procedure to my Visual Studio Project EDMX Model and then use that as the data source for my View (I use MVC). I need to use each of the output parameters in the view.
</div>


I am sorry, My question is misleading.  I need to be able to add my Stored Procedure to my Visual Studio Project EDMX Model and then use that as the data source for my View (I use MVC). I need to use each of the output parameters in the view.

<div>
<div class="content wysiwyg-content">
I have been tasked to create a Spotlight type of report. &nbsp;I am thinking the best way to get all the data I need for each &quot;cell&quot; of the report would be to create a Stored Procedure the contains multiple output parameters with the result of each cell rather than creating multiple methods in a partial model or something like that. &nbsp;<br />
<br />
I need some advice, tips or any help on how to add a Stored Procedure with out put parameters to my EDMX and then use that data in a View.
</div>
</div>


I have been tasked to create a Spotlight type of report.  I am thinking the best way to get all the data I need for each "cell" of the report would be to create a Stored Procedure the contains multiple output parameters with the result of each cell rather than creating multiple methods in a partial model or something like that.  

I need some advice, tips or any help on how to add a Stored Procedure with out put parameters to my EDMX and then use that data in a View.

Using Output Parameters as the Data for a View

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

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

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 tax and financial software topic covers both personal and organizational software, ranging from checkbook managers and tax calculation systems to sophisticated general ledger, accounts receivable and payable, payroll, inventory and planning packages. Two of the most common titles are Quickbooks and Microsoft Dynamics.