asp.net mvc expand table using stored procedure

Question

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.

Answer 1

Hi @Strosala Ioan ,
I found you post the same problem and your codes on the stackoverflow. As far as I think,you could execute two stored procedures and then use QueryMultiple method to map the sql . Just like this:

public ActionResult Index()      
        {     
            using (IDbConnection conn = new SqlConnection(@"xxx"))      
            {      
               string sql = @"exec getCustomer;      
                             exec getOrder;";      
                using (var multi = conn.QueryMultiple(sql))      
                {    
                    var t1 = multi.Read<Customer>().ToList();      
                    var t2 = multi.Read<Order>().ToList();     
                }      
                return View();      
            }      
        }  

Best regards,
Yijing Sun

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our  documentation  to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I do not know how to help you on this issue.