Hi

When i create a data layer/business layer myself, I normally have a shared method on my business classes called DoSearch where you can pass in a whole load of inputs and search the underlying database table by building a dynamic sql query.

How would i do something like that in llblgenpro?

Is there something built in to do this? If not I considered that i might need to extend, for example, the customercollection to add a search method.

Thanks very much andrea

You probably need more info.

vb.net 1.1 self servicing

When i create a data layer/business layer myself, I normally have a shared method on my business classes called DoSearch where you can pass in a whole load of inputs and search the underlying database table by building a dynamic sql query.

How would i do something like that in llblgenpro?

The same, you would pass all the inputs you used to pass, then you would dynamically form a RelationPredicateBucket object (consisted of Relations & Predicate Filters)

Please refer to LLBLGen Pro manual "Using the generated code -> Adapter/SelfServicing -> Filtering and sorting"

Hi

Thanks for your reply. I have read that section of the manual already so I think I amy be missing something.

Are you saying that I would, in essence, just create a predicate for each field i wanted to search and pass the set of predicates into a method like getMulti.

Is there a nice way I could encapsulate that functionality. For example, is there a way to create a collection of predicates that can be shared between pages?

Thanks a lot anndrea

Are you saying that I would, in essence, just create a predicate for each field i wanted to search and pass the set of predicates into a method like getMulti.

Yes

Is there a nice way I could encapsulate that functionality. For example, is there a way to create a collection of predicates that can be shared between pages?

Please elaborate more.

Thanks