Best Way To Load and Cache Scoped Data?

I am using MediatR, so scoped services essentially live the lifetime of the MediatR request.
Given that, I want to load configuration from a database if not loaded (using Entity Framework), then cache the returned data, as it is used multiple times for the request.

What is the best way to go about this? This is my current code, but this is blocking and I would think could cause performance issues.

This particular example would remove 4 round trip database calls.

public class ScopedCachingService(DbContext context)
{
    private Configurations[]? GlobalConfiguration { get; set; }

    public Configurations[] GetGlobalConfigurationAsync()
    {
        return GlobalConfiguration ??= context.Configuration.OrderBy(c => c.ConfigKey).ToArray();
    }
}

public class ScopedCachingService(DbContext context)
{
    private Configurations[]? GlobalConfiguration { get; set; }

    public Configurations[] GetGlobalConfigurationAsync()
    {
        return GlobalConfiguration ??= context.Configuration.OrderBy(c => c.ConfigKey).ToArray();
    }
}

C#•2y ago•

10 replies

RacerDelux

Best Way To Load and Cache Scoped Data?

public class ScopedCachingService(DbContext context)
{
    private Configurations[]? GlobalConfiguration { get; set; }

    public Configurations[] GetGlobalConfigurationAsync()
    {
        return GlobalConfiguration ??= context.Configuration.OrderBy(c => c.ConfigKey).ToArray();
    }
}

public class ScopedCachingService(DbContext context)
{
    private Configurations[]? GlobalConfiguration { get; set; }

    public Configurations[] GetGlobalConfigurationAsync()
    {
        return GlobalConfiguration ??= context.Configuration.OrderBy(c => c.ConfigKey).ToArray();
    }
}

Best Way To Load and Cache Scoped Data?

Similar Threads

Best Way To Load and Cache Scoped Data?

Similar Threads

Similar Threads

Similar Threads