I've made a .Net library that handles caching/invalidation (using redis) and db querying for you via 'queries'. There is a catch though - you cannot join tables. You join via code server side instead of the db. In my opinion this makes code cleaner and more reusable as well as bringing load from the db to server side. Let me know what you think.
Show HN: C# Library to cache and query the database | Heykuki News