Send SqlParameter to Dapper

標籤：

Question:

I‘ using Dapper in my project. I have a list of SqlParameters and I want to send it to Dapper. But Dapper needs an object (name, value). How can I convert a SqlParameter to an object. I know this doesn‘t work:

conn.Query<TModel>(sql, parameters.Select(p => new {p.ParameterName=p.Value}))

any suggestions?

Answer:

Stumbled across this looking for something else - but can offer some insight that may help others in the future.

You can use the Dapper.DynamicParameters object to add items that can be legally passed to Dapper Queries, i.e. (hand-coded)

var args = new DynamicParameters(new {});parameters.ForEach(p => args.Add(p.ParameterName, p.Value));conn.Query<TModel>(sql, args );

from url：http://stackoverflow.com/questions/22978754/send-sqlparameter-to-dapper

 

Send SqlParameter to Dapper