Question about Linq

Mert AKYILDIZ

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();

3 Replies

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

Jignesh Kumar1y ago

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 S1y ago
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.
-1
Jayraj Chhaya1y ago
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();
```
+2