public void ConnectionShouldRemainInPoolAfterReturnedConnectionDisposed()
{
TestConnectionString testConnection = new TestConnectionString();
SqlCeDatabase db = new SqlCeDatabase(testConnection.ConnectionString);
using (DbConnection connection = SqlCeConnectionPool.CreateConnection(db)) {}
DbConnection keepAlive = TestableSqlCeConnectionPool.GetConnection(0);
Assert.AreEqual(ConnectionState.Open, keepAlive.State);
}
public void GetConnectionReturnsDifferentConnectionThanOneInPool()
{
TestConnectionString testConnection = new TestConnectionString();
SqlCeDatabase db = new SqlCeDatabase(testConnection.ConnectionString);
using (DatabaseConnectionWrapper connection = SqlCeConnectionPool.CreateConnection(db))
{
DatabaseConnectionWrapper keepAlive = TestableSqlCeConnectionPool.GetConnection(0);
Assert.AreNotSame(connection, keepAlive);
}
}
public void GetConnectionOpensConnectionInPool()
{
TestConnectionString testConnection = new TestConnectionString();
SqlCeDatabase db = new SqlCeDatabase(testConnection.ConnectionString);
using (DatabaseConnectionWrapper connection = SqlCeConnectionPool.CreateConnection(db))
{
DatabaseConnectionWrapper keepAlive = TestableSqlCeConnectionPool.GetConnection(0);
Assert.AreEqual(ConnectionState.Open, keepAlive.Connection.State);
}
}
