I have the following data schema

Genere->Tracks_Generes<-Tracks

I need to be able to query all tracks in specific generes or combinations of generes. How would i go about setting that up in LLBLGen?

This example uses the Adapter scenario and is from Generated code - Advanced filter usage, Adapter - Multi-entity filters in the manual.

EntityCollection tracks = new EntityCollection(new TrackEntityFactory());
RelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.Add(TrackEntity.Relations.Tracks_GeneresEntityUsingTrackID);
bucket.Relations.Add(Tracks_GeneresEntity.Relations.GenereEntityUsingGenereID);
bucket.PredicateExpression.Add(GenereFields.Name == "Rock");
bucket.PredicateExpression.AddWithOr(GenereFields.Name == "Comedy");
DataAccessAdapter adapter = new DataAccessAdapter();
adapter.FetchEntityCollection(tracks, bucket);