ASP.Net Core Web API - Call Stored Procedure Implementation

Download source code 👇👇🙂

This video will give developers a practical way to build Web API with ASP.NET Core and Entity Framework to call Stored procedure.
This method is simple and universal, you can use that to call any stored procedure, with a simple entity framework like method, and take the advantage of ASP.NET Core. You will avoid all the trouble work of ADO.NET and the need to format the input / output like the previous version of Web API.

Steps:
Step 1, Create a ASP.NET Core Web API application
Step 2, Set up database
Step 3, Create Entity classses
Step 4, Set up DbContext and data connection
Step 5, Installing Microsoft.EntityFrameworkCore.SqlServer from NuGet Package Manager
Step 6, Create Controller to access stored procedure from entity framework

asp net ado net stored procedure
asp net core web api stored procedure
asp net gridview bind stored procedure
asp net crud stored procedure
asp net core stored procedure output parameter
asp net execute stored procedure return value

[mimrankhan]

does not contain a defiition for output error

[magicsoftu]

So why I shouldnt use the normal system.data.sql, and call the procedure and provide the parameter, at least I dont need the output class, which mean i can get dynamic result and manuipulate the way I want

So here if I want to add filter to the selection i am not sure how it will works