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?