public void Should_Add_Parameters_To_The_DbCommand_And_To_The_Insert_Statement()
{
// Arrange
var customer = new DbCommandExtensionsTests.GenerateInsertForSqlServerTests.CustomerWithFields {
FirstName = "Clark", LastName = "Kent", DateOfBirth = DateTime.Parse("06/18/1938")
};
var databaseCommand = TestHelpers.GetDatabaseCommand();
// Act
databaseCommand = databaseCommand.GenerateInsertForSQLite(customer, "[Person]");
// Visual Assertion
Trace.WriteLine(databaseCommand.DbCommand.CommandText);
// Assert
var parameters = databaseCommand.DbCommand.Parameters.Cast <DbParameter>().ToList();
Assert.That(parameters.FirstOrDefault(x => x.ParameterName.Contains("@FirstName")).Value.ToString() == customer.FirstName);
Assert.That(parameters.FirstOrDefault(x => x.ParameterName.Contains("@LastName")).Value.ToString() == customer.LastName);
Assert.That(parameters.FirstOrDefault(x => x.ParameterName.Contains("@DateOfBirth")).Value.ToString() == customer.DateOfBirth.ToString());
Assert.That(databaseCommand.DbCommand.CommandText.Contains("@FirstName"));
Assert.That(databaseCommand.DbCommand.CommandText.Contains("@LastName"));
Assert.That(databaseCommand.DbCommand.CommandText.Contains("@DateOfBirth"));
}
public void Should_Add_The_Type_Name_When_No_Table_Name_Is_Supplied()
{
// Arrange
var customer = new DbCommandExtensionsTests.GenerateInsertForSqlServerTests.CustomerWithFields { FirstName = "Clark", LastName = "Kent", DateOfBirth = DateTime.Parse( "06/18/1938" ) };
var databaseCommand = TestHelpers.GetDatabaseCommand();
// Act
databaseCommand = databaseCommand.GenerateInsertForSQLite( customer );
// Visual Assertion
Trace.WriteLine( databaseCommand.DbCommand.CommandText );
// Assert
Assert.That( databaseCommand.DbCommand.CommandText.Contains( "[CustomerWithFields]" ) );
}
public void Should_Generate_An_Insert_Statement_When_Passed_An_Instance_Of_An_Class_With_Fields()
{
// Arrange
var customer = new DbCommandExtensionsTests.GenerateInsertForSqlServerTests.CustomerWithFields { FirstName = "Clark", LastName = "Kent", DateOfBirth = DateTime.Parse( "06/18/1938" ) };
var databaseCommand = TestHelpers.GetDatabaseCommand();
// Act
databaseCommand = databaseCommand.GenerateInsertForSQLite( customer );
// Visual Assertion
Trace.WriteLine( databaseCommand.DbCommand.CommandText );
// Assert
Assert.NotNull( databaseCommand.DbCommand.CommandText );
Assert.That( databaseCommand.DbCommand.CommandText.Contains( "INSERT" ) );
}
public void Should_Use_The_Supplied_Table_Name_In_The_Insert_Statement()
{
// Arrange
var customer = new DbCommandExtensionsTests.GenerateInsertForSqlServerTests.CustomerWithFields {
FirstName = "Clark", LastName = "Kent", DateOfBirth = DateTime.Parse("06/18/1938")
};
var databaseCommand = TestHelpers.GetDatabaseCommand();
// Act
databaseCommand = databaseCommand.GenerateInsertForSQLite(customer, "[Person]");
// Visual Assertion
Trace.WriteLine(databaseCommand.DbCommand.CommandText);
// Assert
Assert.That(databaseCommand.DbCommand.CommandText.Contains("[Person]"));
}
public void Should_Generate_An_Insert_Statement_When_Passed_An_Instance_Of_An_Class_With_Fields()
{
// Arrange
var customer = new DbCommandExtensionsTests.GenerateInsertForSqlServerTests.CustomerWithFields {
FirstName = "Clark", LastName = "Kent", DateOfBirth = DateTime.Parse("06/18/1938")
};
var databaseCommand = TestHelpers.GetDatabaseCommand();
// Act
databaseCommand = databaseCommand.GenerateInsertForSQLite(customer);
// Visual Assertion
Trace.WriteLine(databaseCommand.DbCommand.CommandText);
// Assert
Assert.NotNull(databaseCommand.DbCommand.CommandText);
Assert.That(databaseCommand.DbCommand.CommandText.Contains("INSERT"));
}
public void Should_Add_Parameters_To_The_DbCommand_And_To_The_Insert_Statement()
{
// Arrange
var customer = new DbCommandExtensionsTests.GenerateInsertForSqlServerTests.CustomerWithFields { FirstName = "Clark", LastName = "Kent", DateOfBirth = DateTime.Parse( "06/18/1938" ) };
var databaseCommand = TestHelpers.GetDatabaseCommand();
// Act
databaseCommand = databaseCommand.GenerateInsertForSQLite( customer, "[Person]" );
// Visual Assertion
Trace.WriteLine( databaseCommand.DbCommand.CommandText );
// Assert
var parameters = databaseCommand.DbCommand.Parameters.Cast<DbParameter>().ToList();
Assert.That( parameters.FirstOrDefault( x => x.ParameterName.Contains( "@FirstName" ) ).Value.ToString() == customer.FirstName );
Assert.That( parameters.FirstOrDefault( x => x.ParameterName.Contains( "@LastName" ) ).Value.ToString() == customer.LastName );
Assert.That( parameters.FirstOrDefault( x => x.ParameterName.Contains( "@DateOfBirth" ) ).Value.ToString() == customer.DateOfBirth.ToString() );
Assert.That( databaseCommand.DbCommand.CommandText.Contains( "@FirstName" ) );
Assert.That( databaseCommand.DbCommand.CommandText.Contains( "@LastName" ) );
Assert.That( databaseCommand.DbCommand.CommandText.Contains( "@DateOfBirth" ) );
}
