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));
			}
		}