public static IServiceCollection AddCustomMSSQLDbContext <TDbContext>(this IServiceCollection services, IConfiguration configuration) where TDbContext : DbContext
{
services
.AddEntityFrameworkSqlServer()
.AddDbContextPool <TDbContext>(options =>
{
options.UseSqlServer(configuration.GetConnectionString("MSSQL"),
sqlServerOptionsAction: sqlOptions =>
{
sqlOptions
.EnableRetryOnFailure(
maxRetryCount: 15,
maxRetryDelay: TimeSpan.FromSeconds(30),
errorNumbersToAdd: null);
}
);
},
10 //Connection pool size
//,ServiceLifetime.Scoped
);
services.AddSingleton(settings => {
CommonGlobalAppSingleSettings commonGlobalAppSingleSettings = new CommonGlobalAppSingleSettings();
commonGlobalAppSingleSettings.MssqlConnectionString = configuration.GetConnectionString("MSSQL");
return(commonGlobalAppSingleSettings);
});
return(services);
}
public Handler(CommonGlobalAppSingleSettings commonGlobalAppSingleSettings)
{
_commonGlobalAppSingleSettings = commonGlobalAppSingleSettings;
}
