Filter (any) statement doesn't work as accpected

[Zero-G.]

Hey

I try to use an equivalent to the IN statement, but it doesn't work, as I want.
I have a master table and a related child table. I want to filter the child table with the following code:

Code: Select all

        Dim GetID as new List(of Long)
        GetID.Add(1)
        GetID.Add(2)

        Dim myKundenst = From Query In LinqProvider.GetProvider.Kundenstamms _
                         Where Query.auftrags.Any(Function(c) GetID.Contains(c.Id)) _
                         Select Query

But it doesn't seem to work correct. myKundenst hold all the child's - not filtered.

THX

[AndreyR]

You should use the DataLoadOptions.AssociateWith method, like this:

Code: Select all

Dim dlo As New DataLoadOptions
dlo.AssociateWith(Of Kundenstamm)(Function(k As Kundenstamm) (k.Auftrags.Where(Function (a As Auftrag)(GetID.Contains(a.Id)))))
LinqProvider.GetProvider.LoadOptions = dlo 

[Zero-G.]

Thanks for the tip
Is it a designed behavior, that DataLoadOptions could not be added, when the DataContext has loaded values before?

THX

[AndreyR]

Yes. This behaviour is identical to the one implemented by Microsoft.
This fact is mentioned here:
http://msdn.microsoft.com/en-us/library ... tions.aspx