DevForce Community Forum : Querying through Multiple Levels

Querying through Multiple Levels : Hi SilvioThat worked! Thanks for...

Thu, 09 Sep 2010 17:32:21 -700

Author: benmcneill
Subject: 2136
Posted: 09-Sep-2010 at 5:32pm

Hi Silvio

That worked! Thanks for your help, much appreciated.

Regards,

Ben

Querying through Multiple Levels : Hi Ben, try: var query =...

Thu, 09 Sep 2010 17:19:15 -700

Author: sbelini
Subject: 2136
Posted: 09-Sep-2010 at 5:19pm

Hi Ben,

try:

var query = mgr.Fruits.Where(f => f.Color == "Red").Select(f => f.Baskets);

Regards,

Silvio.

Querying through Multiple Levels : Hi GuysHave been searching through...

Thu, 09 Sep 2010 02:56:40 -700

Author: benmcneill
Subject: 2136
Posted: 09-Sep-2010 at 2:56am

Hi Guys

Have been searching through the documentation but having trouble figuring this one out.

I have a Master table, say 'Baskets'. There is a many-to-many relationship to a Detail table 'Fruits'. Ie, Many Fruits exist in many Baskets. There is a field/property on the Fruits table called 'Color'.

What I want to do is get ALL Baskets that contain any fruit of color 'Red'.

What I want is something like:

EntityQuery query = mgr.Baskets.Where(p => p.Fruits.Color == 'Red')

However, the 'Color' property doesn't appear in the intellisense list after 'p => p.Fruits.' Instead, I only get a bunch of methods (eg p.Fruits.Single() or p.Fruits.Contains() instead of what I want which is p.Color). What am I missing here?

Thanks in advance,

Ben