Question about Linq

Question

How to get parent model as a result. I want to get MasterData type as a result. i want to use where condition in Attributes but i want to receive Master Data Type as a result

var result= MasterData.SelectMany(ca => ca.Attributes)
.Where(x => MasterDataAttId_All.Contains(x.AttributeId))
.ToList();

Jayraj Chhaya · Answer

Hi Mert AKYILDIZ To achieve the desired outcome of retrieving the MasterData type while applying a condition on its Attributes  you can utilize the Where clause in conjunction with Any to filter the parent model based on the attributes. var result = MasterData .Where(md => md.Attributes.Any(attr => MasterDataAttId_All.Contains(attr.AttributeId))) .ToList();

Jignesh Kumar · Answer

Hello Mert Please use below query which will help you out var result = MasterData .Where(ca => ca.Attributes .Any(x => MasterDataAttId_All.Contains(x.AttributeId))) .ToList();

Sangeetha S · Answer

To retrieving the parent model (Master Data type) while applying a filter condition on the child attributes you can use a combination of Where  Select  and possibly Distinct if needed. Instead of using SelectMany  you want to filter the MasterData based on the condition of its attributes and then return the MasterData objects themselves. Here’s how you can do that: var result = MasterData .Where(ca => ca.Attributes.Any(x => MasterDataAttId_All.Contains(x.AttributeId))) .ToList(); Explanation: Where : This filters the MasterData collection. Any : This checks if any of the Attributes in each MasterData object satisfy the condition (i.e. if their AttributeId is contained in MasterDataAttId_All ). ToList() : This converts the filtered result back into a list of MasterData objects.