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

Markdown is supported
Copy & paste or drag & drop images (max 30 MB per image)

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.

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)
  • User Avatar
    0
    ismcagdas created
    Support Team

    Thanks @strix20 :)

    Markdown is supported
    Copy & paste or drag & drop images (max 30 MB per image)