C# (CSharp) DataFace.Test.PostgreSqlIntegrationTests PostgreSqlIntegrationRepository Examples

Example #1

File: PostgreSqlTests.cs Project: alexgalli/DataFace

        public void PostgreSql_ToSingleOrDefault_Works()
        {
            IDatabaseConnection connection = GetConnection();

            var repo = new PostgreSqlIntegrationRepository(GetConnection());

            repo.ToSingleOrDefault();
        }

Example #2

File: PostgreSqlTests.cs Project: barsae/DataFace

        public void PostgreSql_SprocWithParameter_Works()
        {
            IDatabaseConnection connection = GetConnection();
            InitializeDatabase(connection);

            var repo = new PostgreSqlIntegrationRepository(GetConnection());
            Assert.AreEqual(143, repo.SprocWithParameter(143));
        }

Example #3

File: PostgreSqlTests.cs Project: barsae/DataFace

        public void PostgreSql_ManyQueries_DoesntFail()
        {
            IDatabaseConnection connection = GetConnection();

            var repo = new PostgreSqlIntegrationRepository(GetConnection());

            for (int ii = 0; ii < 100; ii++) {
                repo.ExecuteAdHocQuery("SELECT 1");
            }
        }

Example #4

File: PostgreSqlTests.cs Project: alexgalli/DataFace

        public void PostgreSql_SprocWithSchema_Works()
        {
            IDatabaseConnection connection = GetConnection();

            InitializeDatabase(connection);

            var repo = new PostgreSqlIntegrationRepository(GetConnection());

            Assert.AreEqual(123, repo.SprocWithSchema());
        }

Example #5

File: PostgreSqlTests.cs Project: alexgalli/DataFace

        public void PostgreSql_ToScalar_Works()
        {
            IDatabaseConnection connection = GetConnection();

            InitializeDatabase(connection);

            var repo = new PostgreSqlIntegrationRepository(GetConnection());

            Assert.AreEqual(142, repo.ToScalar());
        }

Example #6

File: PostgreSqlTests.cs Project: alexgalli/DataFace

        public void PostgreSql_ManyQueries_DoesntFail()
        {
            IDatabaseConnection connection = GetConnection();

            var repo = new PostgreSqlIntegrationRepository(GetConnection());

            for (int ii = 0; ii < 100; ii++)
            {
                repo.ExecuteAdHocQuery("SELECT 1");
            }
        }

Example #7

File: PostgreSqlTests.cs Project: barsae/DataFace

        public void PostgreSql_RollbackTransaction_DoesntHaveSideEffect()
        {
            IDatabaseConnection connection = GetConnection();
            InitializeDatabase(connection);

            var repo = new PostgreSqlIntegrationRepository(GetConnection());
            using (var transaction = repo.WithTransaction()) {
                repo.SprocWithSideEffect();
                transaction.Rollback();
            }

            Assert.AreEqual(0, repo.GetCountOfSideEffects());
        }

Example #8

File: PostgreSqlTests.cs Project: barsae/DataFace

        public void PostgreSql_CommitTransaction_HasSideEffect()
        {
            IDatabaseConnection connection = GetConnection();
            InitializeDatabase(connection);

            var repo = new PostgreSqlIntegrationRepository(GetConnection());
            using (var transaction = repo.WithTransaction()) {
                repo.SprocWithSideEffect();
                transaction.Commit();
            }

            Assert.AreEqual(1, repo.GetCountOfSideEffects());
        }

Example #9

File: PostgreSqlTests.cs Project: alexgalli/DataFace

        public void PostgreSql_RollbackTransaction_DoesntHaveSideEffect()
        {
            IDatabaseConnection connection = GetConnection();

            InitializeDatabase(connection);

            var repo = new PostgreSqlIntegrationRepository(GetConnection());

            using (var transaction = repo.WithTransaction()) {
                repo.SprocWithSideEffect();
                transaction.Rollback();
            }

            Assert.AreEqual(0, repo.GetCountOfSideEffects());
        }

Example #10

File: PostgreSqlTests.cs Project: alexgalli/DataFace

        public void PostgreSql_CommitTransaction_HasSideEffect()
        {
            IDatabaseConnection connection = GetConnection();

            InitializeDatabase(connection);

            var repo = new PostgreSqlIntegrationRepository(GetConnection());

            using (var transaction = repo.WithTransaction()) {
                repo.SprocWithSideEffect();
                transaction.Commit();
            }

            Assert.AreEqual(1, repo.GetCountOfSideEffects());
        }

Example #11

File: PostgreSqlTests.cs Project: barsae/DataFace

        public void PostgreSql_ToScalar_Works()
        {
            IDatabaseConnection connection = GetConnection();
            InitializeDatabase(connection);

            var repo = new PostgreSqlIntegrationRepository(GetConnection());
            Assert.AreEqual(142, repo.ToScalar());
        }

Example #12

File: PostgreSqlTests.cs Project: barsae/DataFace

        public void PostgreSql_ToSingleOrDefault_Works()
        {
            IDatabaseConnection connection = GetConnection();

            var repo = new PostgreSqlIntegrationRepository(GetConnection());
            repo.ToSingleOrDefault();
        }