C# (CSharp) NHibernate.Test.NHSpecificTest.NH3004 TestSqlClientDriver Examples

Example #1

File: Fixture.cs Project: jrauber/GH1429

        private static void RunTest(TestSqlClientDriver driver)
        {
            var command = driver.CreateCommand();

            var usedParam = command.CreateParameter();

            usedParam.ParameterName = driver.FormatNameForParameter("p0");
            command.Parameters.Add(usedParam);

            var unusedParam = command.CreateParameter();

            unusedParam.ParameterName = driver.FormatNameForParameter("unused");
            command.Parameters.Add(unusedParam);

            Assert.AreEqual(command.Parameters.Count, 2);

            SqlString sqlString = new SqlStringBuilder()
                                  .AddParameter()
                                  .ToSqlString();

            driver.RemoveUnusedCommandParameters(command, sqlString);

            Assert.AreEqual(command.Parameters.Count, 1);

            Assert.AreEqual(command.Parameters[0], usedParam);
        }

Example #2

File: Fixture.cs Project: jrauber/GH1429

        public void RemoveUnusedCommandParametersBug_2()
        {
            /* UseNamedPrefixInSql       is true
             * UseNamedPrefixInParameter is true
             * */
            var driver = new TestSqlClientDriver(true, true);

            RunTest(driver);
        }

Example #3

File: Fixture.cs Project: marchlud/nhibernate-core

		public void RemoveUnusedCommandParametersBug_2()
		{
			/* UseNamedPrefixInSql       is true 
			 * UseNamedPrefixInParameter is true
			 * */
			var driver = new TestSqlClientDriver(true, true);

			RunTest(driver);
		}

Example #4

File: Fixture.cs Project: marchlud/nhibernate-core

		private static void RunTest(TestSqlClientDriver driver)
		{
			var command = driver.CreateCommand();

			var usedParam = command.CreateParameter();
			usedParam.ParameterName = driver.FormatNameForParameter("p0");
			command.Parameters.Add(usedParam);

			var unusedParam = command.CreateParameter();
			unusedParam.ParameterName = driver.FormatNameForParameter("unused");
			command.Parameters.Add(unusedParam);

			Assert.AreEqual(command.Parameters.Count, 2);

			SqlString sqlString = new SqlStringBuilder()
				.AddParameter()
				.ToSqlString();

			driver.RemoveUnusedCommandParameters(command, sqlString);

			Assert.AreEqual(command.Parameters.Count, 1);
			
			Assert.AreEqual(command.Parameters[0], usedParam);
		}