oledb - 使用 OleDb 在 Dapper 中传递查询参数

Question

此查询产生错误 No value given for one or more required parameters :

using (var conn = new OleDbConnection("Provider=..."))
{
  conn.Open();
  var result = conn.Query(
    "select code, name from mytable where id = ? order by name",
    new { id = 1 });
}

如果我将查询字符串更改为: ... where id = @id ... ，我会得到一个错误: Must declare the scalar variable "@id".
如何构造查询字符串以及如何传递参数？

Answer 1

以下应该工作:

var result = conn.Query(
"select code, name from mytable where id = ?id? order by name",
new { id = 1 });