public void CreateDatabase(string context) { AccessTools.CreateDatabase("TestDatabase", deleteIfExists: true); Assert.IsTrue(File.Exists("TestDatabase.mdb")); using (var db = new DataConnection(AccessTools.GetDataProvider(), "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=TestDatabase.mdb;Locale Identifier=1033;Jet OLEDB:Engine Type=5;Persist Security Info=True")) { db.CreateTable <SqlCeTests.CreateTableTest>(); db.DropTable <SqlCeTests.CreateTableTest>(); } AccessTools.DropDatabase("TestDatabase"); Assert.IsFalse(File.Exists("TestDatabase.mdb")); }
/// <summary> /// Configure connection to use Access OleDb provider and connection string. /// </summary> /// <param name="builder">Instance of <see cref="LinqToDbConnectionOptionsBuilder"/>.</param> /// <param name="connectionString">Access connection string.</param> /// <returns>The builder instance so calls can be chained.</returns> public static LinqToDbConnectionOptionsBuilder UseAccessOleDb(this LinqToDbConnectionOptionsBuilder builder, string connectionString) { return(builder.UseConnectionString(AccessTools.GetDataProvider(null), connectionString)); }