RE: [CFCDev] Opinions on One-To-Many representation in OO

[Phillip Senn]

Paul Nielsen talks about a technique he's developing with Object Oriented Database design in the last SQL Down Under podcast. http://www.sqldownunder.com/   Paul includes source code on his website http://www.sqlserverbible.com/     From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Salvatore Fusto Sent: Thursday, May 25, 2006 3:11 AM To: CFCDev@cfczone.org Subject: Re: [CFCDev] Opinions on One-To-Many representation in OO   Hi Matt, suppose you have a shopping cart app, in which the cart is composed of many item; generally you retreive this cart an its own items to update items, insert new ones, deletes any: in this case it is surely better to model this composition with an array of object; on the other hand, suppose you have a blog with entries and comments: when you retreive an entry you only display it and its own comments, so now you can model this composition as a simple query of comments as an entry's property. However, I suggest you not to look from a data base perspective, bur from an oo perspective: my example are quite different from an oo perspective, but they map in the some way in a database rewgards salvatore   ----- Original Message ----- From: Matt Williams To: cfcdev@cfczone.org Sent: Wednesday, May 24, 2006 9:26 PM Subject: [CFCDev] Opinions on One-To-Many representation in OO   I have a one to many relationship between two tables, or objects. I assume I should somehow store the many in the bean of the one. What is your preferred way of handling this? An Array of objects of the many? A query of the table with the many? A structure...? Other? Would you handle this differently in a case where the many tends to be only one or two 98% of the time versus a case where the many is three or more most of the time? Or am I thinking about it all wrong to begin with? ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org with the words 'unsubscribe cfcdev' as the subject of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com). An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org