This question is locked. New answers and comments are not allowed.
I have an interesting design problem. Our application supports dynamic forms generation, and the forms get its tabs and field names from a forms designer table. However the main storage table consists of a table that not only has field names consisting of the tab and field name (i.e. [General/Barcode Number] or [Depreciation/Purchase Price:] - note that the label for the form is also in the field name). In the forms design process, the user can add new tabs and new fields on the form, hence the table is changing, and always have field names added or removed.
We want to use this table within ORM, and we have several questions.
We had thought to contain the field data within a blob and serialize the dynamic data within XML, so a record would consist of the classifying fields (category, site, location, employee IDS) and table ID, and then the dynamic part would fit into the serialized data. But the oroblem with this approach is to use the dynamic fields in searching (which is possible) we would have to read in each record, and then unserialize the data, or specify the search fields in another dictionary with its data, which makes the database far more complicated.
How do we handle this dynamic table? What is the process if a end user adds a field to the table (or removes the field). I don't see my way around this issue using ORM (I can use traditional DB access). But we want the Open access part because we want to support MySQL and support a non-windows environment (as the UI is being written in silverlight and/or ajax).
I am looking for an approach with this table so that I can use ORM and open access. How do we do new mappings at runtime?
We want to use this table within ORM, and we have several questions.
We had thought to contain the field data within a blob and serialize the dynamic data within XML, so a record would consist of the classifying fields (category, site, location, employee IDS) and table ID, and then the dynamic part would fit into the serialized data. But the oroblem with this approach is to use the dynamic fields in searching (which is possible) we would have to read in each record, and then unserialize the data, or specify the search fields in another dictionary with its data, which makes the database far more complicated.
How do we handle this dynamic table? What is the process if a end user adds a field to the table (or removes the field). I don't see my way around this issue using ORM (I can use traditional DB access). But we want the Open access part because we want to support MySQL and support a non-windows environment (as the UI is being written in silverlight and/or ajax).
I am looking for an approach with this table so that I can use ORM and open access. How do we do new mappings at runtime?