How to access Stored Procedure in MVC core using linq

Adalat Khan

I have a Stored Procedure and i want to access it in my MVC core project using Entity Framework Core. I searched in google and i found too much links but i did not find any link related to MVC Core. Please give me idea. Thanks in advance.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Puneet Kankar7y ago
Hi Adalat,

Please check below link maybe it is helpful for your application.

https://docs.microsoft.com/en-us/aspnet/core/tutorials/first-mvc-app/search?view=aspnetcore-2.2

https://docs.microsoft.com/en-us/dotnet/standard/modern-web-apps-azure-architecture/work-with-data-in-asp-net-core-apps

https://www.youtube.com/watch?v=5lWlU--E5J8
Amit Kumar7y ago
Hi,
Use the below code.
var productCategory= new SqlParameter("productCategory", "Electronics");

var product = context.Product
    .FromSql("EXECUTE dbo.GetProductByName  @productCategory", productCategory)
    .ToList();
or
var categoryName = "Electronics";
dataContext.Database
           .ExecuteSqlCommand("dbo.InsertCategory @p0", categoryName);
or
var productCategory= "Electronics";

var product = context.Products
    .FromSql("EXECUTE dbo.GetProductByCategory {0}", productCategory)
    .ToList();
Or
var products= context.Products
    .FromSql("EXECUTE dbo.GetProducts")
    .ToList();