Is it possible to return a filtered results set of a nested collection? We currently soft delete rows but they are returned in the result set when using something like the following
var type = _uow.Repository<OrganisationType>()
.Query(m => m.Code == typeCode && m.Deleted == false
&& m.OrganisationDataItems.Any(d => d.Deleted == false))
.Include(m => m.OrganisationDataItems.Select(di=>di.DataField))
I have to subsequently then remove the OrganisationDataItem's that have Deleted = true.
Any help would be appreciated.