Beispiel #1
0
        private void CheckIndexIsClustered()
        {
            List <IIndexDefinition> indexes = _dbSchema.GetIndexDefinitions(_testTable);

            indexes.Should().HaveCount(1, "because clustered index were created");
            indexes[0].IndexName.Should().BeEquivalentTo("i1_" + _testTable);
            indexes[0].IsClustered.Should().BeTrue("because table has clustered index");
        }
Beispiel #2
0
        public ITableDefinition Write(string directory, string tableName, string schemaFileSuffix)
        {
            ITableDefinition tableDefinition = _dbSchema.GetTableDefinition(_dbContext.ColumnTypeConverterForWrite, tableName);

            tableDefinition.Indexes = _dbSchema.GetIndexDefinitions(tableName);
            if (U4Indexes != null)
            {
                var indexesNotAlreadyOnTable = U4Indexes.GetIndexes(tableName)
                                               .Where(i => tableDefinition.Indexes.All(i2 => i2.IndexName != i.IndexName));
                tableDefinition.Indexes.AddRange(indexesNotAlreadyOnTable);
            }

            XmlWriter.WriteSchema(tableDefinition, directory + tableDefinition.Name + "." + schemaFileSuffix);
            return(tableDefinition);
        }