Using C# Linq to query nested objects

Question

I have a PowerShell object and I want to filter the results.

public Collection<PSObject> Groups;

I have successfully achieved this using linq if I need to filter based on a direct member. But what if I want to filter based on an object 1 or 2 levels deep?

Here is the linq query to filter on a direct member:

var groupMembershipFilter = (dynamic)CsQ.Groups.Where(x => x.Members["AgentsByUri"].Value != null).ToList();

However I need to drill down another level. In PowerShell this would be easy:

$x.AgentsByUri.AbsoluteUri

I have tried all sorts but cant figure out how to make this work. So that you can better understand the object structure here are a couple of screen shots:

From the above screen shots you can see the "AgentsByUri" is a collection. Inside that collection I want to test if the property "AbsoluteUri" contains a certain string value.

The other thing I dont understand is why I have to use "Members" and cant just use "BaseObject" - this structure look far more similar to PowerShell and would be my preference if possible as it translates better to my PowerShell brain.

Excuse my terminology, I'm reasonably new to C#! Hopefully this makes sense :)

Any help or guidance would be much appreciated.

Tim Pohlmann · Accepted Answer · 2015-09-10 11:51:08Z

0

Try this:

var groupMembershipFilter = (dynamic)CsQ.Groups.Where(x => x.Members["AgentsByUri"].Any(x => x.AbsoluteUri == "url")).ToList();

answered Sep 10, 2015 at 11:51

Tim Pohlmann

4,5014 gold badges36 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Andrew Morpeth Over a year ago

Cheers for this, didnt seem to like the Any bit. I have made a bit of progress and posted a new question here as I think this one may be overly confusing - stackoverflow.com/questions/32511346/…

Collectives™ on Stack Overflow

Using C# Linq to query nested objects

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related