How to use dynamic linq to query through nested arrays?

Question

If I have class structure as follows:

    private class A
    {
        int afoo { get; set; }
        B[] bList { get; set; }
    }

    private class B
    {
        String bfoo { get; set; }
        C[] cList { get; set; }
    }

    private class C
    {
        String cfoo { get; set; }
        int cfoo2 { get; set; }
    }

    public class Master
    {
        A[] aList;

        //qry for all where A.B.C.cfoo = "test"
    }

How would I construct a dynamic LINQ statement to query for items in class C? Something like this

1) var qry = aList.blist.clist.AsQueryable().Where("cfoo = \"Test\"").Select();

My ultimate solution would be to pass the entire path in the dynamic part like this:

2) var qry = aList.AsQueryable().Where("bList.cList.cFoo = ""Test"").Select();

But from what I have tried you can not have the nested objects in the Where. So I am going to live with using templates to build the methods as in 1) above.

[Also, I am using the dynamic library from Scott Gu for the dynamic part.]

But, I can't get that to work. Any suggestions?

Thanks!

Alex Rouillard · Accepted Answer · 2012-07-13 18:54:16Z

2

aList.SelectMany(a => a.bList)
     .SelectMany(b => b.cList)
     .Where(c => c.cfoo == "\"Test\"");

answered Jul 13, 2012 at 18:54

Alex Rouillard

7778 silver badges10 bronze badges

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

1 Comment

Dave_in_Raleigh Over a year ago

To get this to work with dynamic linq I needed to modify this as follows: aList.SelectMany(a => a.bList) .SelectMany(b => b.cList).AsQueryable().Where("foo = \"Test\""); `

Chandu · Accepted Answer · 2012-07-13 18:53:25Z

0

Try this:

aList.SelectMany(a => a.bList.SelectMany(b => b.cList))
    .Where(c => c.cf002 == "Test")
    .Select();

answered Jul 13, 2012 at 18:53

Chandu

83.2k19 gold badges136 silver badges136 bronze badges

Collectives™ on Stack Overflow

How to use dynamic linq to query through nested arrays?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related