I have the following requirement to fulfill:
When the database is unavailable, I have to write all queries into a buffer file (for ex. .PMQ
) for later execution.
Caching database results is common knowledge for me, but I’s first time when I approached storing “queries to execute” into separate file when database doesn’t respond.
So I want to ask if there is any common design pattern or ready to implement solution for this case, how to handle this case correctly, and how to integrate it with for example. Entity Framework 8?