private void LoadCorrectTableSchemaCore(OleDbConnection cn)
{
MsAccessSchemaLoader loader = new MsAccessSchemaLoader();
DatabaseSchema schema = loader.LoadSchema(cn);
CheckTableSchema(schema.Tables[TestSchemaTableName]);
}
private void LoadCorrectIndexesCore(OleDbConnection cn)
{
MsAccessSchemaLoader loader = new MsAccessSchemaLoader();
DatabaseSchema schema = loader.LoadSchema(cn);
TableSchema table = schema.Tables["IndexesTest"];
table.PrimaryKey.Should().NotBeNull();
CheckIndex(table.PrimaryKey, IndexType.PrimaryKey,
new Tuple <string, SortOrder>[] { Tuple.Create("Id", SortOrder.Ascending) });
CheckIndex(table.Indexes["I_Index"], IndexType.Index, new Tuple <string, SortOrder>[] {
Tuple.Create("ColIndex1", SortOrder.Ascending),
Tuple.Create("ColIndex2Desc", SortOrder.Descending),
Tuple.Create("ColIndex3", SortOrder.Ascending)
});
CheckIndex(table.Indexes["I_UniqueIndex"], IndexType.UniqueKey,
new Tuple <string, SortOrder>[] { Tuple.Create("ColUniqueIndex", SortOrder.Ascending) });
}