How to use SQL stored procedures with MVC Entity Framework

Question

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!

jao · Accepted Answer · 2017-02-24 18:22:50Z

1

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).

answered Feb 24, 2017 at 18:22

jao

18.7k16 gold badges68 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mohammad Akbari · Accepted Answer · 2017-02-24 18:37:28Z

0

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.

answered Feb 24, 2017 at 18:37

Mohammad Akbari

4,8146 gold badges53 silver badges80 bronze badges

Collectives™ on Stack Overflow

How to use SQL stored procedures with MVC Entity Framework

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related