Dapper 传参

数据库：sqlserver
开发：C#
dapper like 模糊查询

select * from A where a1 like CONCAT('%',@SelectWhere,'%'))

dapper in 多条件查询

public DataTable GetCoalextrationDispatchOrder(string[] params)
{
    string sql = $"select * from A where a1 in @params";
    return CoalDbHelper.ExecuteReader(sql, new { params= params});
}