ExecuteStoreQuery和"WHERE IN ({0})“

Question

我得到了以下代码：

string query = "select * from dbo.Personnel where PersonnelId in ({0})";
string param = "1, 2";
var test = model.ExecuteStoreQuery<Personnel>(query, param).ToList();

我收到以下错误：“当将nvarchar值'1，2‘转换为数据类型int.时转换失败。”...

有人知道怎么解决这个问题吗？我想要的是select * from dbo.Personnel where PersonnelId in (1, 2)，但是数字可以是任何数字...

Answer 1

不要将参数发送到ExecuteStoreQuery，只需用param替换{0}即可

string param = "1, 2";
string query = string.Format("select * from dbo.Personnel where PersonnelId in ({0})", param);

或

string query = "select * from dbo.Personnel where PersonnelId in ({0})";
query = query.Replace("{0}",param);

var test = model.ExecuteStoreQuery<Personnel>(query).ToList();