trjhtr

I have a DbContext like that.:

Domain.MyDbContext

public class CoiDbContext : IdentityDbContext<Usuario, Funcao, Guid>

 public DbSet<OcorrenciaTalao> OcorrenciasTalao get; set; 

Some reusable queries like that:

Extenions.OcorrenciasTalao

public static class OcorrenciasTalao

 private static Func<CoiDbContext, int, Task<int>> _getProximoSequencial = EF.CompileAsyncQuery((CoiDbContext context, int ano) => 
 context.OcorrenciasTalao.Where(x => x.BoAno == ano).Select(x => x.BoSequencial + 1).DefaultIfEmpty(1).Max());

 public static async Task<int> GetProximoSequencial(this DbSet<OcorrenciaTalao> dbSet, int ano)
 
 var context = dbSet.GetContext();
 return await _getNextSequencial(context, ano);
 

Since I want to extend the DbSet<TEntity> indeed of the DbContext, I need to get the InternalDbContext in order to compile my reusable query.

Extenions.Common

public static class Common

 private static Dictionary<Type, FieldInfo> _fields = new Dictionary<Type, FieldInfo>();
 public static MyDbContext GetContext<TEntity>(this DbSet<TEntity> dbSet) where TEntity : class
 
 var type = typeof(TEntity);
 if (!Common._fields.ContainsKey(type))
 BindingFlags.Instance));
 
 return Common._fields[type].GetValue(dbSet) as MyDbContext;
 

So, is a better way to get the InternalDbContext without rely on Reflection, since I'm accessing a private field of a third party package, I fear that can silently break my code at any time?

As you may have noticed, I'm using Extensions like a Repository Pattern, is there a good idea? how i can improve that?