// Enable when we change to use linq
        public void GetLegalPartyRolesByRevenueObjectIdAndEffectiveDate_EffectiveDateExistsLess_LegalPartyRoleExistsFirstHalfOfConcat_EffectiveStatusA()
        {
            ILegalPartyRepository legalPartyRepository = new LegalPartyRepository(_legalPartyContext);
            var legalPartyRoles =
                legalPartyRepository.GetLegalPartyRolesByRevenueObjectIdAndEffectiveDate(TestDataBuilder.RevenueObjectId2,
                                                                                         TestDataBuilder.NewestEffectiveDate);

            legalPartyRoles.ShouldContain(lpr => (lpr.Id == TestDataBuilder.LegalPartyRoleId4) && (lpr.LegalParty != null));
        }
        public void GetLegalPartyRolesByRevenueObjectIdAndEffectiveDate_TwoLegalPartiesTheSameDate()
        {
            ILegalPartyRepository legalPartyRepository = new LegalPartyRepository(_legalPartyContext);
            var legalPartyRoles =
                legalPartyRepository.GetLegalPartyRolesByRevenueObjectIdAndEffectiveDate(TestDataBuilder.RevenueObjectId3,
                                                                                         TestDataBuilder.OldestEffectiveDate);

            legalPartyRoles.ShouldHaveSingleItem();
            legalPartyRoles.ShouldContain(lpr => (lpr.Id == TestDataBuilder.LegalPartyRoleId7) && (lpr.LegalParty != null));
        }