we don't create any objects in database in runtime. What we want to achieve is following.
We have about 50 simple tables. For this tables we have a type of dictionary in database. This is a set of tables in which is stored information about these 50 tables. Small sample:
Lets say that we have a table Products. By start of application is an dynamic select statement loaded:
select prod_id,name,description,category,unit_type,qty_per_unit from products
Than the application loads the description of all these fields from dictionary in database. For sample the field unit_type
is string 3 character long, who's title is "Units" and has an lookup editor who's values came from table units
. The field's qty_per_unit
is between 1 and 100 and so on. With this information are an editable DataGrid and corresponding editors created. And all this is by start of the application. Than the application behave like is created only to edit the table products
We have created such applications with Delphi. But now we should move to .Net and I am looking for best possible way to achieve the same.