C# (CSharp) DbCommandExtensionsTests.GenerateInsertForSqlServerTests.CustomerWithProperties Exemples

Exemple #1

Fichier : GenerateInsertForSqlServerTests.cs Projet : randyburden/Sequelocity.NET

        public void Should_Generate_An_Insert_Statement_When_Passed_An_Instance_Of_An_Class_With_Properties()
        {
            // Arrange
            var customer = new DbCommandExtensionsTests.GenerateInsertForSqlServerTests.CustomerWithProperties { 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" ) );
        }

Exemple #2

        public void Should_Generate_An_Insert_Statement_When_Passed_An_Instance_Of_An_Class_With_Properties()
        {
            // Arrange
            var customer = new DbCommandExtensionsTests.GenerateInsertForSqlServerTests.CustomerWithProperties {
                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"));
        }