public void NullQueryOrStoredProc_Throws_ArgumentNullException() { var sqlDataAccessor = new SqlDataAccessor(ConfigurationManager.AppSettings["DBConnection"]); Action act = () => sqlDataAccessor.RetrieveSingleDomainObjectFromDatabase <object>(null); act.ShouldThrow <ArgumentNullException>(); }
public void SqlDataAccessor_Returns_ExpectedSingleObject_From_Database() { var connectionString = ConfigurationManager.AppSettings["DBConnection"]; var sqlDataAccessor = new SqlDataAccessor(connectionString); Employee employee = sqlDataAccessor.RetrieveSingleDomainObjectFromDatabase <Employee>( "dbo.GetAllEmployeeWithId", new Dictionary <string, object>() { { "@Id", "EMP1" } }); employee.Should().NotBeNull("because we know the employee exists"); }
[Ignore] // Does not work yet public void SqlDataAccessor_Returns_ExpectedSingleObject_From_Database_WithTextCommand() { var connectionString = ConfigurationManager.AppSettings["DBConnection"]; var sqlDataAccessor = new SqlDataAccessor(connectionString); Employee employee = sqlDataAccessor.RetrieveSingleDomainObjectFromDatabase <Employee>( "SELECT EmployeeId, FirstName ,LastName ,DateOfJoining FROM dbo.Employees WHERE EmployeeId = @Id AND FirstName = @FName", new Dictionary <string, object>() { { "@Id", "EMP1" }, { "@FName", "John" } }); employee.Should().NotBeNull("because we know the employee exists"); }