I’ve enabled Entity Cache in my project and it appears to be working as defined. I’ve noticed the changes by watching SQL Profiler and can see where certain calls are being cached and not being called again. The exception to that is anywhere that I am explicitly attempting to load an entity by id using either EntityManager or DataManager, these seem to always go to the database. Is this the expected behavior? I have a couple of tables with not a lot of records that get hit all the time in controllers and the business layer and I don’t want them being called from the database each time. These records are also rarely modified. They both have varchar(max) fields so I don’t want these to be part of any other views. How can I cache these? Do I have to implement something myself? If so is there any examples or guidance I should be following?
Thoughts? Thanks.