public void CloseConnection_ClosesEmptySqlServerConnection() { // Arrange var database = new SqlDb(new SqlConnection()); // Act database.CloseConnection(); // Assert Assert.IsTrue(_testConn.State == ConnectionState.Closed); }
public void CloseConnection_ClosesAnOpenSqlServerConnection() { // Arrange _testConn.Open(); var database = new SqlDb(_testConn); // Act database.CloseConnection(); // Assert Assert.IsTrue(_testConn.State == ConnectionState.Closed); }
public void CloseConnection_ClosesSqlServerConnectionThatIsAlreadyClosed() { // Arrange if (_testConn.State == ConnectionState.Closed) _testConn.Close(); var database = new SqlDb(_testConn); // Act database.CloseConnection(); // Assert Assert.IsTrue(_testConn.State == ConnectionState.Closed); }
public int Add(ErrorInfo errorInfo) { var db = new SqlDb(_connection); var com = StoredProcedureFactory.Create(_errorLoggingProcedure, new SqlParameter("@OffendingURL", errorInfo.OffendingUrl), new SqlParameter("@OccuredDate", errorInfo.ErrorDate), new SqlParameter("@ErrorTitle", errorInfo.ErrorTitle), new SqlParameter("@ErrorDescription", errorInfo.ErrorDescription), new SqlParameter("@CurrentLogin", errorInfo.UserId), new SqlParameter("@ApplicationName", errorInfo.ApplicationName)); return db.ExecuteAndReturnScalar(com, "There was a problem logging the error to the database.").ToInt(); }
public void ExecuteAndReturnDataSet_GivenAValidCommandReturnsExpectedDataSet() { var database = new SqlDb(_testConn); var testCommand = StoredProcedureFactory.Create("SqlDb_ExecuteAndReturnDataSetTestProcedure1"); var testData1 = new List<TestTableItem>(); var testData2 = new List<TestTableItem>(); var testDataTable1 = TestData.ListToTable(testData1); var testDataTable2 = TestData.ListToTable(testData2); var expectedDataSet = new DataSet(); expectedDataSet.Tables.Add(testDataTable1); expectedDataSet.Tables.Add(testDataTable2); var actualDataSet = database.ExecuteAndReturnDataSet(testCommand, "ExecuteAndReturnDataSet test failed"); DataSetAssert.AllDataMatches(expectedDataSet, actualDataSet); }
public void Execute_SucceedsWhenGivenAValidCommand() { var database = new SqlDb(_testConn); var testCommand = StoredProcedureFactory.Create("SqlDb_ExecuteTestProcedure1"); database.Execute(testCommand, "Execute Test Failed"); Assert.AreEqual(0,0); }
public void ExecuteAndReturnDataTable_GivenAValidCommandReturnsExpectedDataTable() { var database = new SqlDb(_testConn); var testCommand = StoredProcedureFactory.Create("SqlDb_ExecuteAndReturnDataTableTestProcedure1"); var testData = new List<TestTableItem> { new TestTableItem {ID = 1, Field1 = "Testing123"}, new TestTableItem {ID = 2, Field1 = "TestRecord"} }; var dtExpectedResult = TestData.ListToTable(testData); var dtActualResult = database.ExecuteAndReturnDataTable(testCommand, "ExecuteAndReturnDataTable test failed"); DataTableAssert.AllDataMatches(dtExpectedResult, dtActualResult); }
public void ExecuteAndReturnScalar_InsertsItemAndReturnsIdOfAddedField() { const int expectedValue = 1; var database = new SqlDb(_testConn); var testProcedure = StoredProcedureFactory.Create("SqlDb_ExecuteAndReturnScalarTestProcedure1", new SqlParameter("@Param1", "Testing123")); object actualObject = database.ExecuteAndReturnScalar(testProcedure, "ExecuteAndReturnScalar test failed."); var actualValue = Convert.ToInt32(actualObject); Assert.AreEqual(expectedValue, actualValue); }
public void OpenConnection_ThrowsDBExceptionWhenConnectionIsEmpty() { // Arrange var database = new SqlDb(new SqlConnection()); // Act database.OpenConnection(); // Assert Assert.IsTrue(_testConn.State == ConnectionState.Open); }
public void OpenConnection_OpensSqlServerConnectionWhenCurrentConnectionHasBeenDisposedPrior() { var database = new SqlDb(_testConn); _testConn.Dispose(); database.OpenConnection(); Assert.IsTrue(_testConn.State == ConnectionState.Open); }
public void OpenConnection_OpensSqlServerConnection() { // Arrange var database = new SqlDb(_testConn); // Act database.OpenConnection(); // Assert Assert.IsTrue(_testConn.State == ConnectionState.Open); }
public void Execute_ThrowsADBExceptionWhenGivenACommandThatIsNotFound() { var database = new SqlDb(_testConn); var testCommand = StoredProcedureFactory.Create("asdfsd"); database.Execute(testCommand, "Execute Test Failed"); Assert.AreEqual(0, 0); }
public void ExecuteAndReturnDataSet_ThrowsAnExceptionWhenCommandDoesntExist() { var database = new SqlDb(_testConn); var testCommand = StoredProcedureFactory.Create("BogusCommand"); database.ExecuteAndReturnDataSet(testCommand, "ExecuteAndReturnDataSet test failed"); }
public void ExecuteTransaction_ThrowsExceptionGivenADataTableWithInvalidRows() { var database = new SqlDb(_testConn); var testCommand = StoredProcedureFactory.Create("SqlDb_ExecuteTransactionAndReturnTransactionStatusTestProcedure3"); try { database.ExecuteTransaction(testCommand, "Execute Transaction Failed"); } catch (ExecuteTransactionFormatException testException) { TestUtility.TestExceptionMessage(testException, "The TransactionStatus object expects exactly one row to be returned by the procedure."); } catch (Exception ex) { throw new Exception("Test Failed", ex); } }
public void ExecuteTransaction_ThrowsExceptionGivenADataTableWithInvalidColumns() { var database = new SqlDb(_testConn); var testCommand = StoredProcedureFactory.Create("SqlDb_ExecuteTransactionAndReturnTransactionStatusTestProcedure2"); try { database.ExecuteTransaction(testCommand, "Execute Transaction Failed"); } catch (ExecuteTransactionFormatException testException) { TestUtility.TestExceptionMessage(testException, "The data table returned cannot be used by the TransactionStatus object since it does not contain one or all of the following columns: ErrorCode, ErrorMessage, TransactionInfo."); } catch (Exception ex) { throw new Exception("Test Failed", ex); } }
public void ExecuteTransaction_ThrowsDbCommandExceptionWhenCommandDoesntExist() { var database = new SqlDb(_testConn); var testCommand = StoredProcedureFactory.Create("BogusCommand"); database.ExecuteTransaction(testCommand, "Execute Transaction Failed"); }
public void ExecuteTransaction_ReturnsTransactionStatusGivenAValidDataTable() { var database = new SqlDb(_testConn); var testCommand = StoredProcedureFactory.Create("SqlDb_ExecuteTransactionAndReturnTransactionStatusTestProcedure1"); var status = database.ExecuteTransaction(testCommand, "Execute Transaction Failed"); Assert.AreEqual(string.Format("{0}, {1}, {2}", TransactionStatusCode.Cancelled, "There were no source records. Operation not executed", ""), status.ToString()); }
public void ExecuteAndReturnScalar_ThrowsADBCommandExceptionWhenProcedureFails() { var database = new SqlDb(_testConn); // don't pass params to cause a failure var testProcedure = StoredProcedureFactory.Create("SqlDb_ExecuteAndReturnScalarTestProcedure1"); database.ExecuteAndReturnScalar(testProcedure, "ExecuteAndReturnScalar test failed."); Assert.AreEqual(0, 0); }
public void ExecuteAndReturnDataSet_ThrowsAnExceptionGivenAnInvalidCommand() { var database = new SqlDb(_testConn); var testCommand = new SqlCommand(); database.ExecuteAndReturnDataTable(testCommand, "ExecuteAndReturnDataTable test failed"); Assert.AreEqual(0, 0); }
public void Execute_SucceedsWhenGivenAValidCommandAndNullStringParameter() { var database = new SqlDb(_testConn); var testCommand = StoredProcedureFactory.Create("SqlDb_ExecuteTestProcedure2", new SqlParameter("@p1", null)); database.Execute(testCommand, "Execute Test Failed"); Assert.AreEqual(0, 0); }