public void SetUp()
{
var createTableSql = Properties.Resources.CreateEmployeesTable;
db = Database.OpenConnection(connectionString);
connection = ProviderHelper.GetProviderByConnectionString(connectionString).CreateConnection();
connection.Open();
var command = connection.CreateCommand();
command.CommandText = createTableSql;
command.ExecuteNonQuery();
}
public void ShouldFindForeignKeysUsingCreateTableSql()
{
var providerHelper = new ProviderHelper();
var connectionProvider = providerHelper.GetProviderByConnectionString(ConnectionString);
var schemaProvider = connectionProvider.GetSchemaProvider();
var databaseSchema = DatabaseSchema.Get(connectionProvider, providerHelper);
var table = databaseSchema.FindTable("orderitems_fk_test");
var foreignKeys = schemaProvider.GetForeignKeys(table);
var items_fk_test = foreignKeys.FirstOrDefault(fk => fk.MasterTable.Name == "items_fk_test");
Assert.IsNotNull(items_fk_test);
CollectionAssert.AreEqual(new[] { "ItemsId" }, items_fk_test.Columns.AsEnumerable());
CollectionAssert.AreEqual(new[] { "ItemId" }, items_fk_test.UniqueColumns.AsEnumerable());
var orders_fk_test = foreignKeys.FirstOrDefault(fk => fk.MasterTable.Name == "orders_fk_test");
Assert.IsNotNull(orders_fk_test);
CollectionAssert.AreEqual(new[] { "OrdersId" }, orders_fk_test.Columns.AsEnumerable());
CollectionAssert.AreEqual(new[] { "OrderId" }, orders_fk_test.UniqueColumns.AsEnumerable());
}
public void TestProviderIsSqlProvider()
{
var provider = ProviderHelper.GetProviderByConnectionString(Properties.Settings.Default.ConnectionString);
Assert.IsInstanceOf(typeof(SqlConnectionProvider), provider);
}
public void TestProviderWithConnectionString()
{
var provider = ProviderHelper.GetProviderByConnectionString(string.Format("data source={0}", DatabasePath));
Assert.IsInstanceOf(typeof(SqliteConnectionProvider), provider);
}
