public void Should_Generate_An_Insert_Statement_When_Passed_An_Instance_Of_An_Class_With_Properties()
{
// Arrange
var customer = new CustomerWithProperties { FirstName = "Clark", LastName = "Kent", DateOfBirth = DateTime.Parse( "06/18/1938" ) };
var 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.That( dbCommand.CommandText.Contains( "INSERT" ) );
}
public void Should_Generate_An_Insert_Statement_When_Passed_An_Instance_Of_An_Class_With_Properties()
{
// Arrange
var customer = new CustomerWithProperties {
FirstName = "Clark", LastName = "Kent", DateOfBirth = DateTime.Parse("06/18/1938")
};
var dbCommand = TestHelpers.GetDbCommand();
// Act
dbCommand = dbCommand.GenerateInsertForSQLite(customer);
// Visual Assertion
Trace.WriteLine(dbCommand.CommandText);
// Assert
Assert.NotNull(dbCommand.CommandText);
Assert.That(dbCommand.CommandText.Contains("INSERT"));
}
