Base solution for your next web application
Open Closed

How to call Stored Procedure with join on multiple tables ? #4619


User avatar
0
manojreddy created

I have posted the same question on SO, please help.

[https://stackoverflow.com/questions/48594103/how-to-call-stored-procedure-with-join-on-multiple-tables-in-entity-framework-co])


2 Answer(s)
  • User Avatar
    0
    strix20 created

    As you can see here: here, this is not supported in EF core, at least not using FromSql.

    The feature you are looking for is " Invoking stored procedures in an ad hoc manner to return arbitrary types (covered by #1862)"

    It will be included in EF core 2.1.

    If you want to map this now, you can use a fake entity as described (not an appropriate approach, in my opinion), or you can use the data reader to handle the mapping yourself as described in the EF repo topic.

  • User Avatar
    0
    ismcagdas created
    Support Team

    Thanks @strix20 :)