Originally posted by Kyle Brown: If you mean a Complex DAO, then I would look at Martin Fowler's book "Patterns of Enterprise Application Architecture".
Hmm. I've skimmed through the book (haven't bought it yet) and don't remember such a pattern. Could you post a short description of it (what makes it "complex")?
Joined: Jan 09, 2003
What I meant to say of Complex DAO is a DAO comprising of more than one table. In a case when in a scenario I want to fetch records from more than 2 tables using DAO. In that case my Complex DAO will be of multiple tables. Something like in SQL it will be. SELECT * from ORDER, ORDERDETAIL where order.orderno = orderdetail.orderdetailno;
Joined: Aug 10, 2001
Joins and relationships are one of the things Martin's book touches on. There are about a dozen databse related patterns there that you might find useful. Kyle