[HttpGet("QueryByAnonymousType")]
public async Task<ActionResult<IEnumerable<Product>>> QueryByAnonymousType()
{//参数作为匿名类型
var parameters = new { ProductName = "Ikura", UnitPrice = 31 };
//或者 var parameters = new Product{ ProductName = "Ikura", UnitPrice = 31 };
var sql = "select * from Products Where ProductName=@ProductName and UnitPrice=@UnitPrice";
using (var con = new SqlConnection(MyConfig.ConnectionString))
{
var result = await con.QueryAsync(sql, parameters);
return Ok(result);
}
}
//动态参数包
[Route("QueryByDynamicParameters")]
[HttpGet]
public async Task<ActionResult<IEnumerable<Product>>> QueryByDynamicParameters()
{//Dapper 还提供了一个DynamicParameters类，它表示参数值的“包”。
//您可以将对象传递给它的构造函数。合适的对象包括Dictionary<string, object>：
var dictionary = new Dictionary<string, object>
{
{"@ProductId",1 }
};
var parameters = new DynamicParameters(dictionary);
var sql = "select * from products where ProductId=@ProductId";
using (var con = new SqlConnection(MyConfig.ConnectionString))
{
var products = await con.QuerySingleAsync<Product>(sql, parameters);
return Ok(products);
}
}
[Route("QueryByAddParameters")]
[HttpGet]
public async Task<ActionResult<IEnumerable<Customer>>> QueryByAddParameters()
{//该DynamicParameters类型提供了一种Add方法，使您能够传递显式参数，指定数据类型、方向和大小：
var parameters = new DynamicParameters();
var customerId = "ALFKI";
parameters.Add("@CustomerId", customerId, DbType.String, ParameterDirection.Input, customerId.Length);
var sql = "select * from customers where CustomerId=@customerId";
using (var con = new SqlConnection(MyConfig.ConnectionString))
{
var customers = await con.QuerySingleAsync<Customer>(sql, parameters);
return Ok(customers);
}
}
