public void SqlServer_DDLStatement_DoesntCrash() { var repo = new SqlServerIntegrationRepository(GetConnection()); repo.ExecuteAdHocQuery("CREATE DATABASE datafacetestddl"); repo.ExecuteAdHocQuery("DROP DATABASE datafacetestddl"); }
public void SqlServer_ToScalar_Works() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new SqlServerIntegrationRepository(GetConnection()); Assert.AreEqual(142, repo.ToScalar()); }
public void SqlServer_ManyManyTransactions_DoesntLeak() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); for (int ii = 0; ii < 1000; ii++) { var repo = new SqlServerIntegrationRepository(GetConnection()); repo.SprocWithSchema(); } }
public void SqlServer_ToScalarNull_Works() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new SqlServerIntegrationRepository(GetConnection()); Assert.IsNull(repo.ToScalarNull()); }
public void SqlServer_EmptyMultipleResultSets_Work() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new SqlServerIntegrationRepository(GetConnection()); var model = repo.EmptyMultipleResultSetModel(); Assert.IsNotNull(model); }
public void SqlServer_ToFirstOrDefault_WithoutValue_Works() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new SqlServerIntegrationRepository(GetConnection()); Assert.IsNull(repo.ToFirstOrDefaultScalar2()); }
public void SqlServer_SprocWithParameter_Works() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new SqlServerIntegrationRepository(GetConnection()); Assert.AreEqual(143, repo.SprocWithParameter(143)); }
public void SqlServer_EmptyMultipleResultSets_Work() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new SqlServerIntegrationRepository(GetConnection()); var model = repo.EmptyMultipleResultSetModel(); Assert.IsNotNull(model); }
public void SqlServer_ManyManyTransactions_DoesntLeak() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); for (int ii = 0; ii < 1000; ii++) { var repo = new SqlServerIntegrationRepository(GetConnection()); repo.SprocWithSchema(); } }
public void SqlServer_CommitTransaction_HasSideEffect() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new SqlServerIntegrationRepository(GetConnection()); using (var transaction = repo.WithTransaction()) { repo.SprocWithSideEffect(); transaction.Commit(); } Assert.AreEqual(1, repo.GetCountOfSideEffects()); }
public void SqlServer_RollbackTransaction_DoesntHaveSideEffect() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new SqlServerIntegrationRepository(GetConnection()); using (var transaction = repo.WithTransaction()) { repo.SprocWithSideEffect(); transaction.Rollback(); } Assert.AreEqual(0, repo.GetCountOfSideEffects()); }
public void SqlServer_CommitTransaction_HasSideEffect() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new SqlServerIntegrationRepository(GetConnection()); using (var transaction = repo.WithTransaction()) { repo.SprocWithSideEffect(); transaction.Commit(); } Assert.AreEqual(1, repo.GetCountOfSideEffects()); }
public void SqlServer_MultipleResultSets_Work() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new SqlServerIntegrationRepository(GetConnection()); var model = repo.ToMultipleResultSetModel(); Assert.AreEqual(model.ResultSet0.Count, 2); Assert.AreEqual(model.ResultSet0[0].IntValue, 147); Assert.AreEqual(model.ResultSet0[1].IntValue, 192); Assert.AreEqual(model.ResultSet0[0].BoolValue, true); Assert.AreEqual(model.ResultSet0[1].BoolValue, false); Assert.AreEqual(model.ResultSet1.Count, 2); Assert.AreEqual(model.ResultSet1[0].StringValue, "abc"); Assert.AreEqual(model.ResultSet1[1].StringValue, "def"); Assert.AreEqual(model.ResultSet1[0].DateTimeValue, new DateTime(2001, 2, 3)); Assert.AreEqual(model.ResultSet1[1].DateTimeValue, new DateTime(2004, 5, 6)); }
public void SqlServer_MultipleResultSets_Work() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new SqlServerIntegrationRepository(GetConnection()); var model = repo.ToMultipleResultSetModel(); Assert.AreEqual(model.ResultSet0.Count, 2); Assert.AreEqual(model.ResultSet0[0].IntValue, 147); Assert.AreEqual(model.ResultSet0[1].IntValue, 192); Assert.AreEqual(model.ResultSet0[0].BoolValue, true); Assert.AreEqual(model.ResultSet0[1].BoolValue, false); Assert.AreEqual(model.ResultSet1.Count, 2); Assert.AreEqual(model.ResultSet1[0].StringValue, "abc"); Assert.AreEqual(model.ResultSet1[1].StringValue, "def"); Assert.AreEqual(model.ResultSet1[0].DateTimeValue, new DateTime(2001, 2, 3)); Assert.AreEqual(model.ResultSet1[1].DateTimeValue, new DateTime(2004, 5, 6)); }
public void SqlServer_SprocWithSchema_Works() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new SqlServerIntegrationRepository(GetConnection()); Assert.AreEqual(123, repo.SprocWithSchema()); }
public void SqlServer_ToScalarNull_Works() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new SqlServerIntegrationRepository(GetConnection()); Assert.IsNull(repo.ToScalarNull()); }
public void SqlServer_ToScalar_Works() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new SqlServerIntegrationRepository(GetConnection()); Assert.AreEqual(142, repo.ToScalar()); }
public void SqlServer_DDLStatement_DoesntCrash() { var repo = new SqlServerIntegrationRepository(GetConnection()); repo.ExecuteAdHocQuery("CREATE DATABASE datafacetestddl"); repo.ExecuteAdHocQuery("DROP DATABASE datafacetestddl"); }
public void SqlServer_RollbackTransaction_DoesntHaveSideEffect() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new SqlServerIntegrationRepository(GetConnection()); using (var transaction = repo.WithTransaction()) { repo.SprocWithSideEffect(); transaction.Rollback(); } Assert.AreEqual(0, repo.GetCountOfSideEffects()); }
public void SqlServer_ToFirstOrDefault_WithValue_Works() { IDatabaseConnection connection = GetConnection(); InitializeDatabase(connection); var repo = new SqlServerIntegrationRepository(GetConnection()); Assert.AreEqual(1, repo.ToFirstOrDefaultScalar1()); }