Multi mapping in dapper | Dapper advanced #5

Dapper advanced
Multi mapping in dapper
Many to many relationship in dapper
📎Source code: github.com/rd003/DapperAdvanc...
📎Sql scripts of Db: github.com/rd003/DapperAdvanc...
📺Dapper beginnera tutorial: • Dapper tutorial with d...
.......................................................................................
connect with me:
👉 RUclips: / @ravindradevrani
👉 Twitter: / ravi_devrani
👉 GitHub: github.com/rd003
👉 Medium.com: / ravindradevrani
..........................................
Support my work:
You can buy me a coffee 🍵 : www.buymeacoffee.com/ravindra...
#dotnetcore #aspnetcore #dapper

[@user-vo6tj3dk6c]

Superb

[@bishaladhikari9499]

Love it!

[@bobamos8508]

i am mapping with dynamic, so basicaly i have a function that recieve a query string and some infos about how to bind certain parameters to other queries to bind new values so the code look like this
Call function
Results = dapper.query(queryFormainTable)
ResultsList = results as IEnumerable
Foreach (item in resultsList)
Foreach (bindQuery in bindQueries)
Item[bindQuery.relatedVarName] = dapper.query(bindQuery, parameters)
Parameters are generated depending on the value of item to set something like orderId == item.id
Everything work as expected, but i wonder if there are ways to make it more efficient?

[@nangdalet5994]

Can you demo how to create pagination pls?

[@ravindradevrani]

I already have create 3 or 4 different videos on pagination.
Check this one, it is with apis and dapper
ruclips.net/video/2ky4A9dYgyo/видео.html

[@nangdalet5994]

@@ravindradevrani one more about module Order on method OrderDetail Can you demo using store procedure when insert and get ?

[@ravindradevrani]

ruclips.net/video/-JDuV5d05Qc/видео.html