Dapper.NET 用动态参数查询
本文向大家介绍Dapper.NET 用动态参数查询,包括了Dapper.NET 用动态参数查询的使用技巧和注意事项,需要的朋友参考一下
示例
var color = "Black"; var age = 4; var query = "Select * from Cats where Color = :Color and Age > :Age"; var dynamicParameters = new DynamicParameters(); dynamicParameters.Add("Color", color); dynamicParameters.Add("Age", age); using (var connection = new SqlConnection(/* Your Connection String Here */)) { IEnumerable<dynamic> results = connection.Query(query, dynamicParameters); }