Entity Framework with a temporary database

Question

Given the transition from the current database (which stores only the facts that are believed to be true at the current time) to a temporary database (which can support time-based data processing).

I am currently communicating with a database with Entity Framework, but is it just as easy to continue using Entity Framework with a temporary database as a back-end? I have not found many examples from the Internet where queries are executed against such a database.

Answer 1

If I understood correctly, you have not yet decided how you are going to implement the temporary aspect of your database. You can use the built-in DBMS method (for example, triggers, logging, special mechanisms, such as Change data collection, etc.). But anyway you would include a relational model .

Thus, the general answer would be that the Entity Framework should not have problems with any relational model if there is a valid EF data provider for a particular DBMS.

, , , load testing .

, !