This question is locked. New answers and comments are not allowed.
As per the business requirements, we are suppose to provide the facility to create dynamic columns for ANY table at the runtime (when setting up the system for first time or reflecting the business rule upgrade).
As an initial possible solution, we are going for a three table solution
1. Table Index
2. another table having the table index and the details of the custom field
3. another table referencing the custom field, the row id of the corresponding table and a column saving the value for custom field
In the prototype, before the appearing of this business rule, we adopted the database first approach but for the product we had reached the conclusion of code first (fluent API) approach.
Now, after this new business rule,
- Will we be able to implement this requirement using DataAcess?
-- Is it still possible to proceed with the code first approach?
--- Or we should go for some other approach to this business requirements
We have done only a single prototype using DataAccess and not sure of its capabilities and limits
PS: Note to moderators, if this post is miss-categorized, pls rectify it.
As an initial possible solution, we are going for a three table solution
1. Table Index
2. another table having the table index and the details of the custom field
3. another table referencing the custom field, the row id of the corresponding table and a column saving the value for custom field
In the prototype, before the appearing of this business rule, we adopted the database first approach but for the product we had reached the conclusion of code first (fluent API) approach.
Now, after this new business rule,
- Will we be able to implement this requirement using DataAcess?
-- Is it still possible to proceed with the code first approach?
--- Or we should go for some other approach to this business requirements
We have done only a single prototype using DataAccess and not sure of its capabilities and limits
PS: Note to moderators, if this post is miss-categorized, pls rectify it.