• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Complex DAO

 
aakash bhatt
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can i get some examples how to insert/ update / select in ComplexDAO
Regards,
aakash
 
Lasse Koskela
author
Sheriff
Posts: 11962
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is ComplexDAO?
 
Kyle Brown
author
Ranch Hand
Posts: 3892
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you mean a Complex DAO, then I would look at Martin Fowler's book "Patterns of Enterprise Application Architecture".
Kyle
 
Lasse Koskela
author
Sheriff
Posts: 11962
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 182
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
author
Ranch Hand
Posts: 3892
5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic