v2.0.50727
Hello,
I am having the following tables :
Abonne can have (0 or many) Reglement.
In LLBL designer, relations exist.
when I am doing the following code :
IPrefetchPath2 prefetchPath = new PrefetchPath2((int)EntityType.AbonneEntity);
prefetchPath.Add(AbonneEntity.PrefetchPathReglement);
AbonneEntity abonne = new AbonneEntity("AA003063");
DataAccessAdapter adapter = new DataAccessAdapter();
adapter.FetchEntity(abonne, prefetchPath); ;
2 Queries are generated (in Output windows as well as using the SQL profiler) :
1) select ... from Abonne where pk="AA003063"
2) select ... from Reglement where pk="AA003063"
(Hopefully, Abonne.Reglements is well filled)
May be I am wrong, but shouldn't I have only ONE query generated ? Something like
select * from abonne, reglement where abonne.abonneID = reglement.abonneID and pk="AA003063"
Cheers,
LLblPowa