public void Can_Select_In_for_string_value() { const int n = 5; using (var db = OpenDbConnection()) { db.DropAndCreateTable<ModelWithIdAndName>(); 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)); } }
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); dbCmd.DeleteAll<ModelWithIdAndName>(); for(int i=1; i<=n; i++){ ModelWithIdAndName m = new ModelWithIdAndName(){ Name= "Name"+i.ToString() }; dbCmd.Insert(m); } var selectInNames = new[] {"Name1", "Name2"}; var rows = dbCmd.Select<ModelWithIdAndName>("Name IN ({0})", selectInNames.SqlInValues()); Assert.That(rows.Count, Is.EqualTo(selectInNames.Length)); } }
public void Can_Select_In_for_string_value() { const int n = 5; using (var db = new OrmLiteConnectionFactory(ConnectionString, FirebirdDialect.Provider).Open()) { db.CreateTable<ModelWithIdAndName>(true); db.DeleteAll<ModelWithIdAndName>(); for (int i = 1; i <= n; i++) { ModelWithIdAndName m = new ModelWithIdAndName() { Name = "Name" + i.ToString() }; db.Insert(m); } var selectInNames = new[] {"Name1", "Name2"}; var rows = db.Select<ModelWithIdAndName>("Name IN ({0})", selectInNames.SqlInValues()); Assert.That(rows.Count, Is.EqualTo(selectInNames.Length)); } }