0

I'm new to Entity Framework Core, and I have a stored procedure that contains multiple joins and retrieves columns from multiple tables.

How can I execute this stored procedure in EF Core 3.1?

I checked this link, and it says that I cannot do that https://www.entityframeworktutorial.net/efcore/working-with-stored-procedure-in-ef-core.aspx

Can you help me to overcome these limitations?

enter image description here

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Ehab
  • 19
  • 2
  • 1
    There **are** the limitations of the EF Core at this present time - there's no way or trick to "overcome" these. If you can't live with these - then EF Core is the wrong tool for you - then you'd need to use "raw" ADO.NET or something like Dapper to handle this ... – marc_s Oct 30 '20 at 05:16
  • 1
    What exact limitation are you hitting? And btw, you'd better look at the [official documentation](https://learn.microsoft.com/en-us/ef/core/querying/raw-sql) first rather than external sources. For instance, "The SQL query can't contain related data": does not mean it cannot contain JOINs. etc. – Ivan Stoev Oct 30 '20 at 05:52
  • Maybe it will be your solution: https://stackoverflow.com/a/48596681/12781348 – Saeed Gholamzadeh Oct 30 '20 at 07:15

0 Answers0