public void Setup()
{
_connection = Helpers.CreateAndOpenDatabase(StoreName);
CreateTable();
AssertTableExists("tableName");
AssertColumnExists("tableName", "columnName");
AssertIndexExists("indexName");
_schemaOperationsProvider = SchemaProvider.CreateInstance(_connection.SchemaProviderType, _connection, false);
}
private static DataTable GetCheckConstraints(JetConnection connection)
{
using var schemaProvider = SchemaProvider.CreateInstance(connection.SchemaProviderType, connection);
return(schemaProvider.GetCheckConstraints());
}
private static void RenameColumn(JetConnection connection, string tableName, string oldColumnName, string newColumnName)
{
using var schemaProvider = SchemaProvider.CreateInstance(connection.SchemaProviderType, connection, false);
schemaProvider.RenameColumn(tableName, oldColumnName, newColumnName);
}
private static void RenameTable(JetConnection connection, string oldTableName, string newTableName)
{
using var schemaProvider = SchemaProvider.CreateInstance(connection.SchemaProviderType, connection, false);
schemaProvider.RenameTable(oldTableName, newTableName);
}
