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?
Bryian TanPosted Jan 25, 2018, 12:05 AM