精致的"IN"子句不适用于多个值 [英] dapper "IN" clause not working with multiple values

问题描述

场景:

我的模型中有一个字符串属性，其中包含来自 MultiSelectList @ Html.ListBox 的ID.如果我选择两个列表项，则我的属性值将如下所示: 0100,0500 .

I have a string property in my model that holds the IDs from a MultiSelectList @Html.ListBox. If I select two list items, my property value will look like this 0100,0500.

问题:

Dapper where子句仅适用于单个值:

Dapper where clause will only work with a single value:

CODE IN (@SomeCode) // for example, 0100 or 0500 returns results
CODE IN (@SomeCode) // 0100,0500 does not return results.

推荐答案

这是因为您不需要告诉Dapper使用括号().它会自己做的很好.试试这个:

That's because you don't need to tell Dapper to use parenthesis (). It will do fine by its own. Try this:

var codes = new List<string> { "0100","0500"};
var sql = "select * from SomeTable where CODE IN @codes";
var items = connection.Query(sql, new { codes });

这篇关于精致的"IN"子句不适用于多个值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！