Complex DAO

[aakash bhatt]

Can i get some examples how to insert/ update / select in ComplexDAO
Regards,
aakash

[Lasse Koskela]

What is ComplexDAO?

[Kyle Brown]

If you mean a Complex DAO, then I would look at Martin Fowler's book "Patterns of Enterprise Application Architecture".
Kyle

[Lasse Koskela]

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")?

[aakash bhatt]

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;

[Kyle Brown]

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