Ejemplos de Data.SqlCe.Tests.VSTS TestConnectionString en C# (CSharp)

Ejemplo n.º 1

Archivo: SqlCeParameterDiscoveryFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

 public void CannotGetCommandForStoredProcedure()
 {
     TestConnectionString testConnection = new TestConnectionString();
     testConnection.CopyFile();
     SqlCeDatabase db = new SqlCeDatabase(testConnection.ConnectionString);
     db.GetStoredProcCommand("CustOrdersOrders");
 }

Ejemplo n.º 2

        public void SetUp()
        {
            TestConnectionString testConnection = new TestConnectionString();

            testConnection.CopyFile();
            db = new SqlCeDatabase(testConnection.ConnectionString);
        }

Ejemplo n.º 3

Archivo: SqlCeDataAccessTestsFixture.cs Proyecto: amirsamdani-p/github-move

        public void TearDown()
        {
            SqlCeConnectionPool.CloseSharedConnections();
            TestConnectionString test = new TestConnectionString();

            test.DeleteFile();
        }

Ejemplo n.º 4

        public void CloseConnections()
        {
            SqlCeConnectionPool.CloseSharedConnections();
            TestConnectionString testConnection = new TestConnectionString();

            testConnection.DeleteFile();
        }

Ejemplo n.º 5

Archivo: SqlCeDataAccessTestsFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

 public void SetUp()
 {
     TestConnectionString testConnection = new TestConnectionString();
     testConnection.CopyFile();
     db = new SqlCeDatabase(testConnection.ConnectionString);
     baseFixture = new DataAccessTestsFixture(db);
 }

Ejemplo n.º 6

Archivo: SqlCeDataAccessTestsFixture.cs Proyecto: amirsamdani-p/github-move

        public void SetUp()
        {
            TestConnectionString testConnection = new TestConnectionString();

            testConnection.CopyFile();
            db          = new SqlCeDatabase(testConnection.ConnectionString);
            baseFixture = new DataAccessTestsFixture(db);
        }

Ejemplo n.º 7

Archivo: SqlCeUpdateDataSetWithTransactionsFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

        public void TestInitialize()
        {
            testConnection = new TestConnectionString();
            testConnection.CopyFile();
            db = new SqlCeDatabase(testConnection.ConnectionString);

            base.SetUp();
        }

Ejemplo n.º 8

        public void CreateNewDatabaseThrowsWhenFileAlreadyExists()
        {
            TestConnectionString file = new TestConnectionString();

            Assert.IsTrue(File.Exists(file.Filename));
            SqlCeDatabase database = new SqlCeDatabase(file.ConnectionString);

            database.CreateFile();
        }

Ejemplo n.º 9

Archivo: SqlCeConnectionPoolFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

        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);
        }

Ejemplo n.º 10

Archivo: SqlCeExecuteScalarFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

        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);
        }

Ejemplo n.º 11

        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);
        }

Ejemplo n.º 12

Archivo: SqlCeParameterDiscoveryFixture.cs Proyecto: amirsamdani-p/github-move

        public void CannotGetCommandForStoredProcedure()
        {
            TestConnectionString testConnection = new TestConnectionString();

            testConnection.CopyFile();
            SqlCeDatabase db = new SqlCeDatabase(testConnection.ConnectionString);

            db.GetStoredProcCommand("CustOrdersOrders");
        }

Ejemplo n.º 13

        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);
        }

Ejemplo n.º 14

        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);
        }

Ejemplo n.º 15

        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);
        }

Ejemplo n.º 16

Archivo: SqlCeExecuteReaderFixture.cs Proyecto: zpzgone/Sheng.Winform.IDE

        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);
        }

Ejemplo n.º 17

Archivo: SqlCeConnectionPoolFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

 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);
     }
 }

Ejemplo n.º 18

Archivo: SqlCeConnectionPoolFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

 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);
     }
 }

Ejemplo n.º 19

        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);
        }

Ejemplo n.º 20

Archivo: SqlCeConnectionPoolFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

        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);
        }

Ejemplo n.º 21

        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);
            }
        }

Ejemplo n.º 22

        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);
            }
        }

Ejemplo n.º 23

        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);
            }
        }

Ejemplo n.º 24

        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);
            }
        }

Ejemplo n.º 25

Archivo: SqlCeExecuteReaderFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

        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);
        }

Ejemplo n.º 26

Archivo: SqlCeExecuteNonQueryFixture.cs Proyecto: jmeckley/Enterprise-Library-5.0

        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);
        }

Ejemplo n.º 27

        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);
        }

Ejemplo n.º 28

        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);
                }
            }
        }

Ejemplo n.º 29

        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);
                }
            }
        }

Ejemplo n.º 30

        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();
        }

Ejemplo n.º 31

Archivo: SqlCeConnectionPoolFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

 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);
     }
 }

Ejemplo n.º 32

        public void Initialize()
        {
            TestConnectionString test = new TestConnectionString();

            test.CopyFile();
        }

Ejemplo n.º 33

        public void CopyDatabase()
        {
            TestConnectionString testConnection = new TestConnectionString();

            testConnection.CopyFile();
        }

Ejemplo n.º 34

Archivo: SqlCeParameterizedSqlStringFixture.cs Proyecto: jmeckley/Enterprise-Library-5.0

 public void SetUp()
 {
     TestConnectionString testConnection = new TestConnectionString();
     testConnection.CopyFile();
     db = new SqlCeDatabase(testConnection.ConnectionString);
 }

Ejemplo n.º 35

Archivo: SqlCeExecuteResultSetFixture.cs Proyecto: jmeckley/Enterprise-Library-5.0

        private static SqlCeDatabase GetDatabase(IDataInstrumentationProvider instrumentationProvider)
        {
            var testConnection = new TestConnectionString();
            testConnection.CopyFile();

            return new SqlCeDatabase(testConnection.ConnectionString, instrumentationProvider);
        }

Ejemplo n.º 36

 public void TestInitialize()
 {
     testConnection = new TestConnectionString();
     testConnection.CopyFile();
     db = new SqlCeDatabase(testConnection.ConnectionString);
 }

Ejemplo n.º 37

Archivo: SqlCeConnectionPoolFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

        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);
        }

Ejemplo n.º 38

Archivo: SqlCeConnectionPoolFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

        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);
        }

Ejemplo n.º 39

Archivo: SqlCeDatabaseFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

 public void TearDown()
 {
     SqlCeConnectionPool.CloseSharedConnections();
     TestConnectionString test = new TestConnectionString();
     test.DeleteFile();
 }

Ejemplo n.º 40

Archivo: SqlCeConnectionPoolFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

 public void CopyDatabase()
 {
     TestConnectionString testConnection = new TestConnectionString();
     testConnection.CopyFile();
 }

Ejemplo n.º 41

Archivo: SqlCeDatabaseFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

 public void Initialize()
 {
     TestConnectionString test = new TestConnectionString();
     test.CopyFile();
 }

Ejemplo n.º 42

Archivo: SqlCeConnectionPoolFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

 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);
         }
     }
 }

Ejemplo n.º 43

Archivo: SqlCeConnectionPoolFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

 public void CloseConnections()
 {
     SqlCeConnectionPool.CloseSharedConnections();
     TestConnectionString testConnection = new TestConnectionString();
     testConnection.DeleteFile();
 }

Ejemplo n.º 44

Archivo: SqlCeDatabaseFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

        public void CreateNewDatabaseThrowsWhenFileAlreadyExists()
        {
            TestConnectionString file = new TestConnectionString();

            Assert.IsTrue(File.Exists(file.Filename));
            SqlCeDatabase database = new SqlCeDatabase(file.ConnectionString);
            database.CreateFile();
        }

Ejemplo n.º 45

Archivo: SqlCeConnectionPoolFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

 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);
         }
     }
     
 }

Ejemplo n.º 46

Archivo: SqlCeConnectionPoolFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

        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();
        }

Ejemplo n.º 47

Archivo: SqlCeDatabaseFixture.cs Proyecto: HondaBey/EnterpriseLibrary6

        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);
            }
        }