public void Should_Not_Produce_A_Trailing_Comma_After_The_Last_Parameter_In_The_Values_List()
{
// Arrange
var customer = new ClassWithTheLastFieldNullable {
Ant = 1, Baboon = "broom"
};
DbCommand dbCommand = new SqlCommand();
// Act
dbCommand = new InsertCommandSqlBuilder(DatabaseEngine.SqlServer).AppendInsert(dbCommand, customer, "INSERT INTO {0} ({1}) VALUES({2});");
// Assert
Assert.IsNotNull(dbCommand.CommandText);
Assert.IsFalse(dbCommand.CommandText.Contains(",);"));
}
public void Should_Not_Produce_A_Trailing_Comma_After_The_Last_Parameter_In_The_Values_List()
{
// Arrange
var customer = new ClassWithTheLastFieldNullable { Ant = 1, Baboon = "broom" };
DbCommand dbCommand = TestHelpers.GetDbCommand();
// Act
dbCommand = dbCommand.GenerateInsertCommand( customer, "INSERT INTO {0} ({1}) VALUES({2});" );
// Visual Assertion
Trace.WriteLine( dbCommand.CommandText );
// Assert
Assert.NotNull( dbCommand.CommandText );
Assert.False( dbCommand.CommandText.Contains( ",);" ) );
}
public void Should_Not_Produce_A_Trailing_Comma_After_The_Last_Parameter_In_The_Values_List()
{
// Arrange
var customer = new ClassWithTheLastFieldNullable {
Ant = 1, Baboon = "broom"
};
DbCommand dbCommand = TestHelpers.GetDbCommand();
// Act
dbCommand = dbCommand.GenerateInsertCommand(customer, "INSERT INTO {0} ({1}) VALUES({2});");
// Visual Assertion
Trace.WriteLine(dbCommand.CommandText);
// Assert
Assert.NotNull(dbCommand.CommandText);
Assert.False(dbCommand.CommandText.Contains(",);"));
}