C# Linq Subquery in foreach

Question

I have this Linq query (Foo has a DateTime variable):

var tableFoo = context.GetTable<Foo>();
var tableBar = context.GetTable<Bar>();

var preselect = tableFoo.Where(o => o.Name == "");

List<Foo> foos = new List<Foo>();

foreach (Foo f in preselect) //System.InvalidCastException comes here at the second iteration (Unable to cast to DateTime)
{
    Foo foo = f;

    var subselect = tableBar.Where(o => o.Id == foo.Id);
    foreach (Bar bar in subselect)
    {
        foo.bars.Add(bar);
    }
    foos.Add(foo);
}

It works fine when preselect contains 1 object.
But if preselect contains more than 1 object, it won't work as expected. In the first iteration it works but in the second I get a System.InvalidCastException.
It has to do with the inner subselect because if I remove the inner foreach, it works perfectly.
I think it has to do with this. But I can't figure out what to change.

A subselect in the preselect wouldn't fit into my application architecture

Bennik2000 · Accepted Answer · 2015-10-18 18:16:31Z

0

I solved it like this (I know it is not very elegant):

var tableFoo = context.GetTable<Foo>();
var tableBar = context.GetTable<Bar>();

var preselect = tableFoo.Where(o => o.Name == "");

List<Foo> foos = new List<Foo>();

foreach (Foo f in preselect) //System.InvalidCastException comes here at the second iteration (Unable to cast to DateTime)
{
    Foo foo = f;

    foos.Add(foo);
}

foreach (Foo foo in foos)
{
    var subselect = tableBar.Where(o => o.Id == foo.Id);
    foreach (Bar bar in subselect)
    {
        foo.bars.Add(bar);
    }
}

answered Oct 18, 2015 at 18:16

Bennik2000

1,19211 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

C# Linq Subquery in foreach

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related