in-memory-caching

What problem does it solve?

This skill addresses the repetitive, expensive data access patterns by providing a production-ready in-memory caching layer for .NET applications, reducing database load and latency while enabling responsive user experiences.

Core Features & Use Cases

• Thread-safe storage: Uses ConcurrentDictionary to store and retrieve cached entities with minimal contention.
• Database-driven invalidation: Leverages a TableRecordChanges mechanism and background refresh to ensure cache coherence across changes.
• Background management: Includes a CacheManagementService that initializes caches on startup and processes invalidations periodically.
• Database support and hybrid options: Supports PostgreSQL and MSSQL with optional Redis-based two-level caching for even faster access or pure in-memory caching when Redis is unavailable or undesired.
• Usage scenarios: Ideal for read-heavy workloads, paging, and hot data like reference lookups, where stale data is acceptable within configured TTLs.

Quick Start

• Wire up CacheManagementService in your ASP.NET Core app, register your cache function classes, and configure your database adapters.
• Ensure you have the necessary NuGet packages (Microsoft.Extensions.Caching.StackExchangeRedis for Redis, Microsoft.EntityFrameworkCore for querying) and a DbContext for your entities.
• Run the application and observe initialization logs; your primary caches will be populated and refreshed automatically.