DAO for cross-table queries
Posted by anonymous 10.10.2006 16:07Hi,
This general problem with design patterns, but I suppose you're experienced with similar problems. Imagine the following situation. I've got two tables in my DB: shops and products. For each of them I've created seperate DAO (Date Access Object), so I could ask such question: what is the name of shop X or add new product. By the given table are connected via relation: shop-sells-product. So there is a need to build yet another DAO for cross-table queries, isn't?
What is a good, common-used practice for such situations?