Implement Infinispan as 2nd-layer Cache Provider For EFCore 6.x

[InfoSec812]

One of the primary use cases for Infinispan in Java is as a 2nd-layer cache for database operations (Via things like JPA), but I could not find a similar solution for .NET. I was reading that EFCore does not provide a cache interface anymore and third-party libraries have taken up that work. That library provides an ICache interface which appears to be the way to add Infinispan support and it would be interesting to have that capability.

[rigazilla]

Current 2LC/EF integration layer seem to be:
https://github.com/VahidN/EFCoreSecondLevelCacheInterceptor

which requires Infinispan to implement a specific interface:
https://github.com/VahidN/EFCoreSecondLevelCacheInterceptor#using-a-custom-cache-provider

Implementation of IEFCacheServiceProvider seems feasible, but IEFCacheServiceProvider.InvalidateCacheDependencies may need some investigation.

Plus I suppose some initialization code is needed.

Over all, sounds like a good first issue task to me

[rigazilla]

I've create a framework for this at https://github.com/rigazilla/Infinispan.Hotrod.EFCaching

[InfoSec812]

AWESOME! Thanks @rigazilla for the update!

[rigazilla]

The idea is to provide an Infinispan implementation for EFCoreSecondLevelCacheInterceptor.IEFCacheServiceProvider and use it as described in:
https://github.com/VahidN/EFCoreSecondLevelCacheInterceptor#using-a-custom-cache-provider