Re: Searching OO Associations with RDBMS Persistence Models

On 2006-05-03 13:07:18 -0500, "H. S. Lahman" <h.lahman@xxxxxxxxxxx> said:

In fact, the OO paradigm for instantiating relationships often allows one to avoid searches altogether. That's because the solution is tailored to a particular problem. So if the only subset of [Location] that is ever of interest to the problem solution is those locations starting with "Micro", one would create a separate collection for those entries that begin with "Micro".

The OP was asking a simple question. It seemed clear to me that it was a matter of "Where do I put the SQL?". I don't think that creating a separate collection of entries that begin with "Micro" answers that question since in order to create that collection you still have to find all the entries that begin with "Micro".

--
Robert C. Martin (Uncle Bob)  | email: unclebob@xxxxxxxxxxxxxxxx
Object Mentor Inc.            | blog:  www.butunclebob.com
The Agile Transition Experts  | web:   www.objectmentor.com
800-338-6716                  |



.