N
noel.phillips
Hi,
I want to achieve a system that has a number of objects with what I
would call 'core' properties - that is properties defined at design
time which correspond (directly or otherwise) to a database schema. A
fairly traditional approach.
However, in addition I want the user to be able to define their own
properties, and to effectively 'extend' the object. As far as the
database goes this can be achieved with vertical tables or, say, SMO
etc.
My question is: is there a correct or accepted way to design the object
model to deal with this? Should the object have a hashtable which can
be indexed by the property name? How best can I deal with typing?
Should I infer from the database schema what the types of the
properties are?
Any thoughts or insight would be greatly appreciated - if any more
information or clarification is required please let me know.
Thanks in advance
N
I want to achieve a system that has a number of objects with what I
would call 'core' properties - that is properties defined at design
time which correspond (directly or otherwise) to a database schema. A
fairly traditional approach.
However, in addition I want the user to be able to define their own
properties, and to effectively 'extend' the object. As far as the
database goes this can be achieved with vertical tables or, say, SMO
etc.
My question is: is there a correct or accepted way to design the object
model to deal with this? Should the object have a hashtable which can
be indexed by the property name? How best can I deal with typing?
Should I infer from the database schema what the types of the
properties are?
Any thoughts or insight would be greatly appreciated - if any more
information or clarification is required please let me know.
Thanks in advance
N