Dapper Tutorial - Knowledge Base (KB)

What is the best way to quickly serialize a DataReader without using DataTable (or using a DataTable that could have duplicate column names)

We cache our queries extensively using a decorator that wraps IDbConnection/IDbCommand. When something calls 'ExecuteReader()' it uses the command.text as the cache key (e.g. ...SELECT * FROM Foo...) and we're also able to apply tags to our decorators (e...

Dapper Dynamic Parameters with Table Valued Parameters

I was trying to create a generic method, which can read the parameters name and value from a class at Runtime and create parameter collection for Dapper query execution. Realized that till the point all parameters are Input type it works well, but if I ha...

Get Total Rows binded with Model JQuery Data Table

how can I get the total rows of the result and also with the datatable search working? Right now, I only got the first page of the result which I already filter out with:...OFFSET AND FETCH ...which it will be binded to the model, and I can get the result...