Hi,

I have a problem with relations and filters.

I have attached a picture to the message.

There are 3 tables. First one includes 2 FK fields. CityID and CountryID. tehre is a connection table. I wanna retrieve name values for these fields from 3.Table with a filter (languageID in 3. table)

I wish someone can help me.

Hi kuranyi,

Could you please provide more information? http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=7720

As far as I understand you, you could do something like:

EntityCollection<Table1Entity> table1Coll = new EntityCollection<Table1Entity>(new Table1EntityFactory());

IRelationPredicateBucket filter = new RelationPredicateBucket();
filter.Relations.Add(Table1Entity.Relations.Table2EntityUsingLocationID);
filter.Relations.Add(Table2Entity.Relations.Table3EntityUsingLingualID);

filter.PredicateExpression.Add(Table3Fields.SomeField == someValue);

You can also should include PrefetchPaths if you want to access later the objecst (table2 and table3) related to table1.

For more information read: LLBLGenPro Help - Using generated code (Adapter | Selfserficing) - Filtering and Sorting - Advance filter usage - Multi-entity filters.

hi again,

thanks for your reply, i think i could not explain my situation clearly.

Here it is:

this is your answer

IRelationPredicateBucket filter = new RelationPredicateBucket(); filter.Relations.Add(Table1Entity.Relations.Table2EntityUsingCityID); filter.Relations.Add(Table2Entity.Relations.Table3EntityUsingLingualID);

filter.PredicateExpression.Add(Table3Fields.SomeField == someValue);

and it gets only city name field from 3. table for me.

But i also want country name field from 3 table exactly using same relations.

IRelationPredicateBucket filter = new RelationPredicateBucket(); filter.Relations.Add(Table1Entity.Relations.Table2EntityUsingCountryID); filter.Relations.Add(Table2Entity.Relations.Table3EntityUsingLingualID);

filter.PredicateExpression.Add(Table3Fields.SomeField == someValue);

If you view attachmets you will understand my problem. You can think 3. record in first table.

Thanks again

Hi everyone,

I have solved my problem.

I just learned how to use alias for relations and filters.

Thaks a lot.