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")); }