CODEWITHSUNDEEP
stored-proceduresasp.net-core-mvcentity-framework-core
Hal31000
Hal31000

Reputation: 11

How to use SQL stored procedures with MVC Entity Framework

My colleague tells me that ASP.NET MVC with Entity Framework Core does not support calling SQL stored procedures. Is this true? If not, where can I find information on how to do this? Thanks!

Upvotes: 1

Views: 543

Answers (2)

Mohammad Akbari
Mohammad Akbari

Reputation: 4766

Bosed on this roadmap in Entity framework core github page Entity framework core roadmap

For now stored procedure calling, not support in entity framework core.

You can use Dapper library for now, until support this feature in EF Core.

Upvotes: 0

jao
jao

Reputation: 18610

If you take a look at the EF Core / EF 6.x Feature Comparison you will see that EF Core indeed does not support SQL Stored Procedures:

Stored procedure mapping allows EF to use stored procedures to persist changes to the database (FromSql already provides good support for using a stored procedure to query, see Raw SQL Queries for details).

Upvotes: 1

Related Questions