We've a project that has some tables are defined and some will be generated runtime, means dynamic and no pre-defined structure.
We generally use Entity Framework to communicate to the database(in our case MS SQL).
But for this kind of requirement, what should we do for database communication as the database will be dynamic and column names are also dynamic.
Tables and columns of database are generated dynamically so in case of Entity Framework, I'm not sure it might work or not?
If we're choosing Entity Framework with Code First, in that case we need to create classes runtime and update database as well, which I guess not possible.
If we're choosing Entity Framework with Model First,in that scenario we also need to update model file (.edmx) runtime, which I guess not possible.
So the last option come is to use ADO.Net from which we can dynamic query the database and get result without defining model as well.
So I need help here to design the architecture and a good way to archive it. We're ready to go with NoSql but the thing "dynamic database".
Is there a way so we can use Entity Framework?