public IndividualEntity Retrieve(int id) { var sqlHelper = new DalHelper(_connectionString); var parameters = new List<SqlParameter> { new SqlParameter("Id", id) }; var procedureName = string.Format( DalHelper.RetrieveStoredProcFormat, TableName); var dataSet = sqlHelper.ExecuteStoredProcedure( procedureName, parameters); IndividualEntity entity = null; if (dataSet != null && dataSet.Tables.Count > 0) { var table = dataSet.Tables[0]; foreach (DataRow row in table.Rows) { entity = new IndividualEntity { Id = row.Field<int>("Id"), LastName = row.Field<string>("LastName"), FirstName = row.Field<string>("FirstName"), MiddleName = row.Field<string>("MiddleName"), Suffix = row.Field<string>("Suffix"), DateOfBirth = row.Field<DateTime>("DateOfBirth"), }; } } return entity; }
public void Create_WithScenarioDataInDatabase_ExpectProperNextIdIsGenerated( int expectedId) { // Arrange var classUnderTest = new IndividualDal(ConnectionString); var entity = new IndividualEntity { LastName = "Jones", FirstName = "Wilma", MiddleName = "Vanessa", DateOfBirth = new DateTime(1993, 11, 17), }; // Act var actual = classUnderTest.Create(entity); // Assert Assert.NotNull(actual); Assert.AreEqual(expectedId, actual); }
public void Delete_WithScenarioDataInDatabase_ExpectInvalidOperationException( int id) { // Arrange var classUnderTest = new IndividualDal(ConnectionString); var entity = new IndividualEntity { Id = id, }; // Act classUnderTest.Delete(entity); // Assert Assert.Fail("Expected an exception"); }