Rahul Zanwar

Rahul Zanwar

  • NA
  • 12
  • 4k

Issue with entity framework core 2.0 using stored proc

Jan 24 2018 8:48 AM
I am using Entity Framework Core 2.0 in my WebAPI project and I have written multiple sotred procedures to perform database operations. Now for accessing the database, I am using EF Code First. Also I have defined the entities according to database tables I have. Now when I am trying to call stored procedures, I am facing issue with EF core 2.0.
 
My sotred procedures are written in a way that they are returning either subset of my database table, or related data generated using Joins. But I could not find way to call these stored procedures and get the result data using EF Core 2.0. I found that EF 2.0 does not support mapping of related data, which is not bound to some entity. Is there any workaround for it? 

Answers (1)