How to add interceptor to EF Core db context #1430

Denis created 3 years ago

I need t configure DB context to use this library https://github.com/VahidN/EFCoreSecondLevelCacheInterceptor

How I can do that in ABP?

The code below is used to enable this interceptor

public static class MsSqlServiceCollectionExtensions
    {
        public static IServiceCollection AddConfiguredMsSqlDbContext(this IServiceCollection services, string connectionString)
        {
            services.AddDbContextPool<ApplicationDbContext>((serviceProvider, optionsBuilder) =>
                    optionsBuilder
                        .UseSqlServer(
                            connectionString,
                            sqlServerOptionsBuilder =>
                            {
                                sqlServerOptionsBuilder
                                    .CommandTimeout((int)TimeSpan.FromMinutes(3).TotalSeconds)
                                    .EnableRetryOnFailure()
                                    .MigrationsAssembly(typeof(MsSqlServiceCollectionExtensions).Assembly.FullName);
                            })
                        .AddInterceptors(serviceProvider.GetRequiredService<SecondLevelCacheInterceptor>()));
            return services;
        }
    }

ABP Version: 4.3

liangshiwei created 3 years ago

Support Team Fullstack Developer

Hi,

Open EntityFrameworkCoreModule class and remove Configure<AbpDbContextOptions>... code block.

Open EntityFrameworkCoreDbMigrationsModule clsss and add following code:


context.Services.AddEFSecondLevelCache(options =>
    options.UseMemoryCacheProvider().DisableLogging(true).UseCacheKeyPrefix("EF_"));
    
Configure<AbpDbContextOptions>(options =>
{
    options.Configure(c =>
    {
        c.UseSqlServer(builder =>
        {
            builder.CommandTimeout((int) TimeSpan.FromMinutes(3).TotalSeconds)
                .MigrationsAssembly(typeof(QaEntityFrameworkCoreDbMigrationsModule).Assembly.FullName);
        }).AddInterceptors(c.ServiceProvider.GetRequiredService<SecondLevelCacheInterceptor>());
    });
});