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); }
public void RemoveUnusedCommandParametersBug_2() { /* UseNamedPrefixInSql is true * UseNamedPrefixInParameter is true * */ var driver = new TestSqlClientDriver(true, true); RunTest(driver); }
public void RemoveUnusedCommandParametersBug_2() { /* UseNamedPrefixInSql is true * UseNamedPrefixInParameter is true * */ var driver = new TestSqlClientDriver(true, true); RunTest(driver); }
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); }