public void CannotGetCommandForStoredProcedure() { TestConnectionString testConnection = new TestConnectionString(); testConnection.CopyFile(); SqlCeDatabase db = new SqlCeDatabase(testConnection.ConnectionString); db.GetStoredProcCommand("CustOrdersOrders"); }
public void SetUp() { TestConnectionString testConnection = new TestConnectionString(); testConnection.CopyFile(); db = new SqlCeDatabase(testConnection.ConnectionString); }
public void TearDown() { SqlCeConnectionPool.CloseSharedConnections(); TestConnectionString test = new TestConnectionString(); test.DeleteFile(); }
public void CloseConnections() { SqlCeConnectionPool.CloseSharedConnections(); TestConnectionString testConnection = new TestConnectionString(); testConnection.DeleteFile(); }
public void SetUp() { TestConnectionString testConnection = new TestConnectionString(); testConnection.CopyFile(); db = new SqlCeDatabase(testConnection.ConnectionString); baseFixture = new DataAccessTestsFixture(db); }
public void TestInitialize() { testConnection = new TestConnectionString(); testConnection.CopyFile(); db = new SqlCeDatabase(testConnection.ConnectionString); base.SetUp(); }
public void CreateNewDatabaseThrowsWhenFileAlreadyExists() { TestConnectionString file = new TestConnectionString(); Assert.IsTrue(File.Exists(file.Filename)); SqlCeDatabase database = new SqlCeDatabase(file.ConnectionString); database.CreateFile(); }
public void ConnectionShouldRemainInPoolAfterReturnedConnectionDisposed() { 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); }
public void SetUp() { testConnection = new TestConnectionString(); testConnection.CopyFile(); db = new SqlCeDatabase(testConnection.ConnectionString); DbCommand command = db.GetSqlStringCommand("Select count(*) from region"); baseFixture = new ExecuteScalarFixture(db, command); }
public void SetUp() { testConnection = new TestConnectionString(); testConnection.CopyFile(); db = new SqlCeDatabase(testConnection.ConnectionString); DbCommand insertionCommand = db.GetSqlStringCommand(insertString); DbCommand countCommand = db.GetSqlStringCommand(countQuery); baseFixture = new ExecuteNonQueryFixture(db, insertString, countQuery, insertionCommand, countCommand); }
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 DatabaseShouldCloseSharedConnection() { TestConnectionString file = new TestConnectionString(); SqlCeDatabase database = new SqlCeDatabase(file.ConnectionString); using (DbConnection connection = SqlCeConnectionPool.CreateConnection(database)) {} Assert.AreEqual(1, TestableSqlCeConnectionPool.PoolSize); database.CloseSharedConnection(); Assert.AreEqual(0, TestableSqlCeConnectionPool.PoolSize); }
public void TestInitialize() { testConnection = new TestConnectionString(); testConnection.CopyFile(); db = new SqlCeDatabase(testConnection.ConnectionString); DbCommand insertCommand = db.GetSqlStringCommand(insertString); DbCommand queryCommand = db.GetSqlStringCommand(queryString); baseFixture = new ExecuteReaderFixture(db, insertString, insertCommand, queryString, queryCommand); }
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); } }
public void GetConnectionAddsConnectionToPool() { TestConnectionString testConnection = new TestConnectionString(); SqlCeDatabase db = new SqlCeDatabase(testConnection.ConnectionString); using (DatabaseConnectionWrapper connection = SqlCeConnectionPool.CreateConnection(db)) { Assert.IsNotNull(connection); Assert.AreEqual(1, TestableSqlCeConnectionPool.PoolSize); } }
public void PoolShouldCloseSharedConnection() { TestConnectionString testConnection = new TestConnectionString(); SqlCeDatabase db = new SqlCeDatabase(testConnection.ConnectionString); using (DatabaseConnectionWrapper connection = SqlCeConnectionPool.CreateConnection(db)) {} Assert.AreEqual(1, TestableSqlCeConnectionPool.PoolSize); SqlCeConnectionPool.CloseSharedConnection(db); Assert.AreEqual(0, TestableSqlCeConnectionPool.PoolSize); }
public void CloseSharedConnectionsShouldClearPool() { TestConnectionString testConnection = new TestConnectionString(); SqlCeDatabase db = new SqlCeDatabase(testConnection.ConnectionString); using (DatabaseConnectionWrapper connection = SqlCeConnectionPool.CreateConnection(db)) {} Assert.AreEqual(1, TestableSqlCeConnectionPool.PoolSize); SqlCeConnectionPool.CloseSharedConnections(); Assert.AreEqual(0, TestableSqlCeConnectionPool.PoolSize); }
public void CanOpenSqlCeDatabase() { TestConnectionString testConnection = new TestConnectionString(); SqlCeDatabase database = new SqlCeDatabase(testConnection.ConnectionString); using (DbConnection connection = database.CreateConnection()) { connection.Open(); Assert.AreEqual(ConnectionState.Open, connection.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 TestInitialize() { testConnection = new TestConnectionString(); testConnection.CopyFile(); db = new SqlCeDatabase(testConnection.ConnectionString); DbCommand insertCommand = db.GetSqlStringCommand(insertString); queryCommand = db.GetSqlStringCommand(queryString); baseFixture = new ExecuteReaderFixture(db, insertString, insertCommand, queryString, queryCommand); }
public void ExecuteSqlCreatesConnectionInPool() { TestConnectionString testConnection = new TestConnectionString(); SqlCeDatabase db = new SqlCeDatabase(testConnection.ConnectionString); DbCommand command = db.GetSqlStringCommand("select count(*) from region"); Assert.AreEqual(0, TestableSqlCeConnectionPool.PoolSize); int result = (int)db.ExecuteScalar(command); Assert.AreEqual(4, result); Assert.AreEqual(1, TestableSqlCeConnectionPool.PoolSize); }
public void GetConnectionReturnsNewConnectionButHasOnlyOneInPool() { TestConnectionString testConnection = new TestConnectionString(); SqlCeDatabase db = new SqlCeDatabase(testConnection.ConnectionString); using (DatabaseConnectionWrapper connection1 = SqlCeConnectionPool.CreateConnection(db)) { using (DatabaseConnectionWrapper connection2 = SqlCeConnectionPool.CreateConnection(db)) { Assert.AreNotSame(connection1, connection2); Assert.AreEqual(1, TestableSqlCeConnectionPool.PoolSize); } } }
public void GetConnectionWithPoolingReturnsSameConnection() { TestConnectionString testConnection = new TestConnectionString(); SqlCeDatabase db = new SqlCeDatabase(testConnection.ConnectionString); using (DatabaseConnectionWrapper connection1 = SqlCeConnectionPool.CreateConnection(db, true)) { using (DatabaseConnectionWrapper connection2 = SqlCeConnectionPool.CreateConnection(db, true)) { Assert.AreSame(connection1, connection2); Assert.AreEqual(1, TestableSqlCeConnectionPool.PoolSize); } } }
public void GetConnectionForTwoFilesAddsTwoConnectionsToPool() { TestConnectionString file1 = new TestConnectionString(); TestConnectionString file2 = new TestConnectionString("test2.sdf"); file2.CopyFile(); SqlCeDatabase db1 = new SqlCeDatabase(file1.ConnectionString); SqlCeDatabase db2 = new SqlCeDatabase(file2.ConnectionString); using (DbConnection connection1 = SqlCeConnectionPool.CreateConnection(db1)) { using (DbConnection connection2 = SqlCeConnectionPool.CreateConnection(db2)) {} } Assert.AreEqual(2, TestableSqlCeConnectionPool.PoolSize); SqlCeConnectionPool.CloseSharedConnections(); file2.DeleteFile(); }
public void Initialize() { TestConnectionString test = new TestConnectionString(); test.CopyFile(); }
public void CopyDatabase() { TestConnectionString testConnection = new TestConnectionString(); testConnection.CopyFile(); }
private static SqlCeDatabase GetDatabase(IDataInstrumentationProvider instrumentationProvider) { var testConnection = new TestConnectionString(); testConnection.CopyFile(); return new SqlCeDatabase(testConnection.ConnectionString, instrumentationProvider); }
public void TestInitialize() { testConnection = new TestConnectionString(); testConnection.CopyFile(); db = new SqlCeDatabase(testConnection.ConnectionString); }
public void DatabaseShouldCloseSharedConnection() { TestConnectionString file = new TestConnectionString(); SqlCeDatabase database = new SqlCeDatabase(file.ConnectionString); using (DatabaseConnectionWrapper connection = SqlCeConnectionPool.CreateConnection(database)) {} Assert.AreEqual(1, TestableSqlCeConnectionPool.PoolSize); database.CloseSharedConnection(); Assert.AreEqual(0, TestableSqlCeConnectionPool.PoolSize); }
public void GetConnectionForTwoFilesAddsTwoConnectionsToPool() { TestConnectionString file1 = new TestConnectionString(); TestConnectionString file2 = new TestConnectionString("test2.sdf"); file2.CopyFile(); SqlCeDatabase db1 = new SqlCeDatabase(file1.ConnectionString); SqlCeDatabase db2 = new SqlCeDatabase(file2.ConnectionString); using (DatabaseConnectionWrapper connection1 = SqlCeConnectionPool.CreateConnection(db1)) { using (DatabaseConnectionWrapper connection2 = SqlCeConnectionPool.CreateConnection(db2)) {} } Assert.AreEqual(2, TestableSqlCeConnectionPool.PoolSize); SqlCeConnectionPool.CloseSharedConnections(); file2.DeleteFile(); }