I can't use Second Level Cache with ABP

[mardemza]

I cannot implement the Second Level Cache library because it needs to use the service provider and it is not available in the method that configures the
DbContext Configuration.Modules.AbpEfCore().AddDBContext<MyDbContext>(options => ....... ..

And something like this is needed
Configuration.Modules.AbpEfCore().AddDBContext<MyDbContext>((serviceProvider, options) => .......

Can you please help me to find a solution so inside the configurer I can implement this
builder.UseSqlServer(connectionString).AddInterceptors(serviceProvider.GetRequiredService<SecondLevelCacheInterceptor>());

[ismcagdas]

Maybe you can access serviceProvider in your interceptor by following an approach similar to https://stackoverflow.com/a/67003567

[mardemza]

My friend, it didn't work :(

My code

The service provider is needed here

This is documentacion of Second Level Cache Interceptor

[mef760]

I have the same problem. any suggestion?

[ismcagdas]

Is it possible to call the code below in your mdoule's PostInitialize method ?

In that case, you can get ServiceCollectionProvider like this;

var serviceCollectionProvider = IocManager.IocContainer.Resolve<IServiceCollectionProvider>();

[mardemza]

@ismcagdas I still can't configure the use of Second Level Cache Interceptor,

Cannot find the IServiceCollectionProvider

Do you have any suggestions?

[ismcagdas]

I think you can register IServiceCollectionProvider as explained in the blog post below and then use it in EF core project;

https://aspnetzero.com/blog/persist-data-protection-keys-to-database

[mardemza]

I don't work because I need the IServiceProvider and not the IServiceCollectionProvider

[ismcagdas]

I will try to prepare a sample but it might take some time.

[mardemza]

I've tried this, but it doesn't work.

https://support.abp.io/QA/Questions/1430/How-to-add-interceptor-to-EF-Core-db-context#answer-b81252e7-307b-d8af-bba7-39fce208e8a4

Apparently it is not the same Framework so it does not find the AbpDbContextOptions

[ismcagdas]

Yes, it is not same.

[behiunforgiven]

@mardemza
Did you have any progress on this issue?

[mardemza]

@behiunforgiven
No, it only works in abp.io project, but in aspnetboilerplate project it still doesn't work

[ismcagdas]

Have you tried this appraoch ?

public static class Issue6672DbContextConfigurer
{
	public static void Configure(DbContextOptionsBuilder<Issue6672DbContext> builder, string connectionString)
	{
		var interceptor = IocManager.Instance.Resolve<SecondLevelCacheInterceptor>();
		builder.UseSqlServer(connectionString)
			.AddInterceptors(interceptor);
	}

	public static void Configure(DbContextOptionsBuilder<Issue6672DbContext> builder, DbConnection connection)
	{
		var interceptor = IocManager.Instance.Resolve<SecondLevelCacheInterceptor>();
		builder.UseSqlServer(connection)
			.AddInterceptors(interceptor);
	}
}

[behiunforgiven]

It runs without problem, but caching does not work.

[ismcagdas]

In my test, I can see that SecondLevelCacheInterceptor is executed. But, I'm not sure why cache doesn't work.

[mardemza]

@ismcagdas - @behiunforgiven I tried but I didn't have success, it resolves SecondLevelCacheInterceptor well, but then it doesn't cache.

[ismcagdas]

I will try to check it again.

[cyrusdowney]

So this may not be a SecondLevelCache issue. I created an issue with interceptors not firing

#6948

Don't know if it is related or not, but thought I would chime in.

[ismcagdas]

@mardemza I think I figured it out. Since AppService methods and Controller actions are starting a transaction by default (UnitOfWork), you should use AllowCachingWithExplicitTransactions(true) while configuring second level cache. I tried this and there was no query in SQL Server profiler.

services.AddEFSecondLevelCache(options =>
		options.UseMemoryCacheProvider()
			.ConfigureLogging()
			.AllowCachingWithExplicitTransactions(true)
			.CacheAllQueries(CacheExpirationMode.Sliding, TimeSpan.FromMinutes(60)) // Does not take effect
);

[mardemza]

@ismcagdas I tried what they told me but it didn't work, it doesn't cache

[ismcagdas]

I have prepared a sample https://github.com/ismcagdas/Issue6672. Run the project and go to Users page and press the search button several times. You will see that only first request will go to database.

[behiunforgiven]

when i want to update the database I get this error:

Unable to create a 'DbContext' of type ''. The exception 'No component for supporting the service EFCoreSecondLevelCacheInterceptor.SecondLevelCacheInterceptor was found' was thrown while attempting to create an instance. For the different patterns supported at design time, see https://go.microsoft.com/fwlink/?linkid=851728