protected override DbConnection GetConnection()
{
return(new JetConnection(JetConnection.GetConnectionString("SystemTables.accdb")));
}
protected override DbConnection GetConnection()
{
return(new JetConnection(JetConnection.GetConnectionString("GearOfWar.accdb")));
}
public void Read_ServerVersion_From_Closed_Connection()
{
JetConnection connection = new JetConnection(ConnectionString);
Assert.IsTrue(connection.ServerVersion == string.Empty);
}
public void Change_Database_From_Open_Connection()
{
using var connection = new JetConnection(JetConnection.GetConnectionString(StoreName, Helpers.DataAccessProviderFactory));
connection.Open();
connection.ChangeDatabase("abcd");
}
public void Change_Database_From_Closed_Connection()
{
JetConnection connection = new JetConnection(ConnectionString);
connection.ChangeDatabase("abcd");
}
public void Read_ConnectionString_From_Disposed0_Connection()
{
JetConnection connection = new JetConnection(ConnectionString);
Assert.AreEqual(ConnectionString, connection.ConnectionString);
}
public void OpenSeveralTimes()
{
using var connection = new JetConnection(JetConnection.GetConnectionString(StoreName, Helpers.DataAccessProviderFactory));
connection.Open();
connection.Open();
}
public void GetTransaction_From_Closed_Connection()
{
JetConnection connection = new JetConnection(ConnectionString);
var transaction = connection.BeginTransaction();
}
public void Read_Database_From_Disposed_Connection()
{
using var connection = new JetConnection(JetConnection.GetConnectionString(StoreName, Helpers.DataAccessProviderFactory));
connection.Dispose();
Assert.IsTrue(connection.Database == string.Empty);
}
public void Open_Connection_Without_Connection_String()
{
using var connection = new JetConnection();
connection.Open();
}
public void Read_ServerVersion_From_Open_Connection()
{
using var connection = new JetConnection(JetConnection.GetConnectionString(StoreName, Helpers.DataAccessProviderFactory));
connection.Open();
Console.WriteLine(connection.ServerVersion);
}
public void Read_ServerVersion_From_Closed_Connection()
{
using var connection = new JetConnection(JetConnection.GetConnectionString(StoreName, Helpers.DataAccessProviderFactory));
Assert.IsTrue(connection.ServerVersion == string.Empty);
}
public void Change_ConnectionString_From_Open_Connection()
{
using var connection = new JetConnection(JetConnection.GetConnectionString(StoreName, Helpers.DataAccessProviderFactory));
connection.Open();
connection.ConnectionString = DummyStoreName;
}
protected override void UseProviderOptions(DbContextOptionsBuilder optionsBuilder)
=> optionsBuilder.UseJet(new JetConnection(JetConnection.GetConnectionString("DummyDatabase.accdb")));
public void GetSchema_From_Closed_Connection()
{
using var connection = new JetConnection(JetConnection.GetConnectionString(StoreName, Helpers.DataAccessProviderFactory));
connection.GetSchema();
}
public static void DeleteDatabase(string storeName)
{
JetConnection.ClearAllPools();
JetConnection.DropDatabase(storeName);
}
protected override DbConnection GetConnection()
{
return(new JetConnection(JetConnection.GetConnectionString("SystemTables.accdb", Helpers.DataAccessProviderFactory), Helpers.DataAccessProviderFactory));
}
public ConnectionPoolingTest()
{
ConnectionString = JetConnection.GetConnectionString(FileName);
ConnectionStringDummy = JetConnection.GetConnectionString(FileNameDummy);
}
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
optionsBuilder.UseJet(JetConnection.GetConnectionString(GetStorePath(), Helpers.DataAccessProviderFactory), Helpers.DataAccessProviderFactory);
}
public void Change_ConnectionString_From_Closed_Connection()
{
JetConnection connection = new JetConnection(ConnectionString);
connection.ConnectionString = ConnectionStringDummy;
}
protected override DbConnection GetConnection()
{
string connectionString = JetConnection.GetConnectionString("Chips.accdb", Helpers.DataAccessProviderFactory);
return(new JetConnection(connectionString));
}
public void Read_Database_From_Closed_Connection()
{
JetConnection connection = new JetConnection(ConnectionString);
Assert.IsTrue(connection.Database == string.Empty);
}
protected override void OnConfiguring(DbContextOptionsBuilder dbContextOptionsBuilder)
{
dbContextOptionsBuilder.UseJet(JetConnection.GetConnectionString("Issue398Database.accdb"));
}
public void Read_DataSource_From_Closed_Connection()
{
JetConnection connection = new JetConnection(ConnectionString);
Assert.AreEqual(FileName, connection.DataSource);
}
public void GetTransaction_From_Closed_Connection()
{
using var connection = new JetConnection(JetConnection.GetConnectionString(StoreName, Helpers.DataAccessProviderFactory));
using var transaction = connection.BeginTransaction();
}
