LLBLGenPRO help

  • Thread starter Thread starter Anders K. Jacobsen [DK]
  • Start date Start date
A

Anders K. Jacobsen [DK]

(I hope its ok to ask here else please guide me en the right direction :) )

I want to use the getMulti with a RelationCollection so i can filter on
related tables, a PredicateExpression wich specifies the filter expression
on the related entity AND a prefetchPath wich i need so i dont get extensive
quries on antoher related table in the Collection that im retreinving to
when using it. The problem is that no GetMulti construct accepts these 3
classes. Is this possible another way?



If it maybe helps I have some partial code:

----------------

RelationCollection relationsToUse = new RelationCollection();



IPrefetchPath prefetchPath = new
PrefetchPath((int)EntityType.EjaculateEntity);

prefetchPath.Add(EjaculateEntity.PrefetchPathQuality);



relationsToUse.Add(EjaculateEntity.Relations.PersonEntityUsingPersonid);

relationsToUse.Add(PersonEntity.Relations.DonorEntityUsingPersonid);



IPredicateExpression selectFilter = new PredicateExpression();

selectFilter.Add(PredicateFactory.CompareValue(DonorFieldIndex.Number,
ComparisonOperator.Equal, donorid));



EjaculateCollection ec = new EjaculateCollection();



//ec.GetMulti(??)



Anders, Denmark
 
Anders said:
(I hope its ok to ask here else please guide me en the right direction :) )
Click to expand...

You could ask on our forums as well, or mail to our support email address.
I want to use the getMulti with a RelationCollection so i can filter on
related tables, a PredicateExpression wich specifies the filter expression
on the related entity AND a prefetchPath wich i need so i dont get extensive
quries on antoher related table in the Collection that im retreinving to
when using it. The problem is that no GetMulti construct accepts these 3
classes. Is this possible another way?
Click to expand...

a prefetch path is a graph definition of the entities related to the
root entity type to fetch which are also fetched. If you want to filter
on the entities per graph node, you have to specify the filter with the
graph node when you call prefetchpath.Add().

If you want to filter on the root entities (in your case
EjaculateCollection) you have to use teh GetMulti() overload:

entityCollection.GetMulti(IPredicate selectFilter, long
maxNumberOfItemsToReturn, ISortExpression sortClauses,
IRelationCollection relations, IPrefetchPath prefetchPathToUse)

Frans

ps: interesting database ;)
 
You could ask on our forums as well, or mail to our support email address.

Im still evaluating. Can´t find the forum. Access only to paying members? or
please redirect me to the page :) Would be nice with a userforum in the
evaluating process.
If you want to filter on the root entities (in your case
EjaculateCollection) you have to use teh GetMulti() overload:
entityCollection.GetMulti(IPredicate selectFilter, long
maxNumberOfItemsToReturn, ISortExpression sortClauses, IRelationCollection
relations, IPrefetchPath prefetchPathToUse)
Click to expand...

Ahh damn. Don´t know how i could miss that overload. It works PERFECT now.
ps: interesting database ;)
Click to expand...

Grrrr don´t mention it. Its the most perverted database I´ve ever
seen/created. But I guess it can´t be much diffrent when developing to a
spermbank...hmmm.

Anders, Denmark
 
Anders said:
Im still evaluating. Can´t find the forum. Access only to paying members? or
please redirect me to the page :) Would be nice with a userforum in the
evaluating process.
Click to expand...

In the Help menu -> Visit support forums :)
Ahh damn. Don´t know how i could miss that overload. It works PERFECT now.
Click to expand...

cool! :)
Grrrr don´t mention it. Its the most perverted database I´ve ever
seen/created. But I guess it can´t be much diffrent when developing to a
spermbank...hmmm.
Click to expand...

heh, I can imagine :) Good luck with the evaluation. And if you have
more questions, just use the online faq-form or mail support at llblgen
dot com.

Frans
--
 
Back
Top