示例#1
0
        public void TestAddTableMsDescriptionTest()
        {
            // Arrange
            var databaseFactory = new SqlServerDatabaseFactory
            {
                ConnectionString = "server=(local);database=Northwind;integrated security=yes;MultipleActiveResultSets=true;"
            };

            databaseFactory.ImportSettings.ImportMSDescription = true;

            // Act
            var database = databaseFactory.Import();

            var table = database.FindTable("dbo.Products");

            databaseFactory.DropMsDescription(table);

            databaseFactory.AddMsDescription(table, "Test description");

            var column = table.Columns.FirstOrDefault();

            databaseFactory.DropMsDescription(table, column);

            databaseFactory.AddMsDescription(table, column, "Primary key");

            // Assert
            Assert.True(table.Description == "Test description");
            Assert.True(column.Description == "Primary key");
        }