title: Reading stored procedure result with multiple tables using MVC EF
body: <p>I have searched for similar questions, but they are old.</p>
  <p>I am trying to optimize my work by using a stored procedure to retrieve all related tables to one to avoid multiple queries. I want to use this kind of <a href="https://www.red-gate.com/simple-talk/blogs/using-stored-procedures-sql-server-return-several-results/" rel="nofollow noreferrer">stored procedure</a> which returns multiple tables as JSON and output parameters, but I am new to ASP.NET Core MVC with EF. Could someone guide me in the right direction? How can I read that output parameter and convert them to objects? it's worth mentioning that I want to use tables for dropLists.</p>
  <p>The main table has some columns which are mentioning to some tables. I want to have those table values and show them in some dropdowns or checkboxes.</p>