public void DataService_UpdateContentType_Updates_Record_On_Valid_ContentType() { //Arrange int rowCount = DataUtil.GetRecordCount(DataTestHelper.ConnectionString, ContentDataTestHelper.ContentTypesTableName); DataUtil.AddDatabaseObject(virtualScriptFilePath, upateContentType); ContentType contentType = ContentTestHelper.CreateValidContentType(); contentType.ContentTypeId = Constants.CONTENTTYPE_UpdateContentTypeId; contentType.ContentType = Constants.CONTENTTYPE_UpdateContentType; DataService ds = new DataService(); //Act ds.UpdateContentType(contentType); //Assert using (SqlConnection connection = new SqlConnection(DataTestHelper.ConnectionString)) { connection.Open(); DatabaseAssert.RecordCountIsEqual(connection, ContentDataTestHelper.ContentTypesTableName, rowCount); //Check Values are updated IDataReader dataReader = DataUtil.GetRecordsByField(connection, ContentDataTestHelper.ContentTypesTableName, keyField, Constants.CONTENTTYPE_UpdateContentTypeId.ToString()); while (dataReader.Read()) { DatabaseAssert.ReaderColumnIsEqual(dataReader, "ContentType", Constants.CONTENTTYPE_UpdateContentType); } dataReader.Close(); } }