Base solution for your next web application
Open Closed

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


User avatar
0
Simonlum created

Hi, I have a stored procedure and return a dataset, so how can i receive the dataset in AspNetZero Project,Could you please give me some examples; thanks;


3 Answer(s)
  • User Avatar
    1
    mnetolicky created

    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

  • User Avatar
    0
    Simonlum created

    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;

  • User Avatar
    0
    jdavis01 created