dapper.net cache to keep data in memory

c# dapper

Question

I have a web application (Logi Analytic's Logi info) that is hosted in IIS. This application has to invoke a method in a tailor made dll called plugin (written in C# as a class library).

The method will perform some data access to invoke some sproc in a legacy SQL server database. I will probably use Dapper.Net. I am just wondering what I can do to improve performance - to ensure that the data is kept in memory - to avoid round trips to the database?

Accepted Answer

Dapper has no function for caching objects in memory this way. The problem with caching sql result is how to handle removed and edited items.

Take a look at this @ Codeproject




Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why