public void Can_Select_In_for_string_value()
{
const int n = 5;
using (var db = OpenDbConnection())
{
db.CreateTable<ModelWithIdAndName>(true);
n.Times(x => db.Insert(ModelWithIdAndName.Create(x)));
var selectInNames = new[] { "Name1", "Name2" };
var rows = db.Select<ModelWithIdAndName>("Name IN ({0})".Fmt(selectInNames.SqlInParams()),
new { values = selectInNames.SqlInValues() });
Assert.That(rows.Count, Is.EqualTo(selectInNames.Length));
rows = db.Select<ModelWithIdAndName>("Name IN (@p1, @p2)", new { p1 = "Name1", p2 = "Name2" });
Assert.That(rows.Count, Is.EqualTo(selectInNames.Length));
}
}
public void Can_Select_In_for_string_value()
{
const int n = 5;
using (var db = ConnectionString.OpenDbConnection())
using (var dbCmd = db.CreateCommand())
{
dbCmd.CreateTable<ModelWithIdAndName>(true);
n.Times(x => dbCmd.Insert(ModelWithIdAndName.Create(x)));
var selectInNames = new[] {"Name1", "Name2"};
var rows = dbCmd.Select<ModelWithIdAndName>("Name IN ({0})", selectInNames.SqlInValues());
Assert.That(rows.Count, Is.EqualTo(selectInNames.Length));
}
}
