How to access the Stored Procedure(return Dataset) in AspNetZero #10263

3 Answer(s)

• 

  1

  mnetolicky created 4 years ago

  Hi,
  I'm not from AspNetZero support. But as far as I know from our project you can use Dapper. It's in Boirplate and you can add it to AspNetZero by yourself.

  Here is some info.
  https://aspnetboilerplate.com/Pages/Documents/Dapper-Integration

  Regards,
  Michal

  Save Cancel
• 

  0

  Simonlum created 4 years ago

  Thank you @mnetolicky , i found the Dapper is also mapping the Table to Entity one by one ,my question is my stored procedure will return two or more tables (and the table might be include extra column calculated by other columns) ,so i want to recevie a dataset in ASPNETZERO and then convert to the models what i expected, i have no idea how can i handle this case;

  Save Cancel
• 

  0

  jdavis01 created 4 years ago

  Here is a great example that helped me out with the same issue

  https://stackoverflow.com/questions/56880399/map-stored-procedure-with-multiple-resultset-returned-in-ef-core

  Save Cancel