Linq Question

Mert AKYILDIZ

i want to receive Sections within MasterDataAttId_All bu this code returns all sections if any section id contains MasterDataAttId_All. How to receive Sections that it's id equals any MasterDataAttId_All's id

var result = MasterData.Where(md => md.sections.Any(x => MasterDataAttId_All.Contains(x.SectionId))).ToList()

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tuhin Paul1y ago
```
var result = MasterData.Where(md => md.sections.Any(x => MasterDataAttId_All.Equals(x.SectionId))).ToList();
```
if MasterDataAttId_All is a collection of IDs and you want to check if any of the SectionId matches with the IDs in the collection, you should use the Contains method in a different way.

Jignesh Kumar1y ago

Hello Mertz,

Please use this query,

var result = MasterData
    .Where(md => md.sections
        .Any(x => MasterDataAttId_All.Contains(x.SectionId))).ToList();