Hi. I have two table Customer and Order which are viewed in the following order: in the index view which is paginated with PagedList.Mvc, appears Customer and in the details page view the order. For the index page I have a stored procedure to fill table and the details I have another stored procedure which fill the order table.
I followed the example from this link: https://www.aspsnippets.com/Articles/Implement-Nested-Grid-GridView-in-ASPNet-MVC.aspx, if I use Sql raw we achieved this expansion.
But I want to get this result through using two stored procedure executed by Dapper.
Please help me if possible to get the same result using storage procedures.
Thank you.