LINQ: How to select one column after Any() method

Question

I need to select DeviceTypeID from the below query but I can't because I started my query with .Any() method. Please help me to select DeviceTypeID

var Ids = query.Any(a => a.HospitalDepartments.Any(b => 
                        b.Units.Any(c => c.Devices.Select(f => f.DeviceTypeID)))).ToList();

Are you sure you want to use `Any()`? What are you actually trying to do? — itsme86, Apr 15 '17 at 16:26

score 4 · Accepted Answer · edited Sep 29 '17 at 14:46

4

Any checks if there is at least one item in the collection that meets a predicate. From how it looks what you want is a way to collect all the DeviceTypeIDs in all your hierarchy. If so, then you need SelectMany:

var ids = query.SelectMany(a => 
              a.HospitalDepartments.SelectMany(b => 
                  b.Units.SelectMany(c => 
                      c.Devices.Select(f => f.DeviceTypeID)))).ToList();

edited Sep 29 '17 at 14:46

Graham

7,035
17
57
82

answered Apr 15 '17 at 16:28

Gilad Green

35,761
7
54
89

It's working very well! Thank you so much. Can please kindly please help me to solve this problem .... i am you are smart enough to solve it! Here is my question link: [link](http://stackoverflow.com/questions/43430023/linq-how-to-use-the-exact-array-value-instead-of-contains) – Alex Apr 15 '17 at 18:57

LINQ: How to select one column after Any() method

1 Answers1