Example #1
0
        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
0
		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);
		}