static void UseSqlServer(string connectionString, DbContextOptionsBuilder options, IConfiguration configuration, IHostEnvironment env) { if (env.IsDevelopment()) { options.UseSqlServer( connectionString, options => options.EnableRetryOnFailure() ).EnableSensitiveDataLogging(); } options.UseSqlServer( connectionString, options => options.EnableRetryOnFailure() ); }
/// <summary> /// Configure the <see cref="PostgresSqlDatabaseContext"/>. /// </summary> /// <param name="options">The <see cref="DbContextOptionsBuilder"/> to configure.</param> /// <param name="databaseConfiguration">The <see cref="DatabaseConfiguration"/>.</param> public static void ConfigureWith(DbContextOptionsBuilder options, DatabaseConfiguration databaseConfiguration) { if (options == null) { throw new ArgumentNullException(nameof(options)); } if (databaseConfiguration == null) { throw new ArgumentNullException(nameof(databaseConfiguration)); } if (databaseConfiguration.DatabaseType != DatabaseType.PostgresSql) { throw new InvalidOperationException($"Invalid DatabaseType for {nameof(PostgresSqlDatabaseContext)}!"); } options.UseNpgsql(databaseConfiguration.ConnectionString, options => { options.EnableRetryOnFailure(); if (!String.IsNullOrEmpty(databaseConfiguration.ServerVersion)) { options.SetPostgresVersion( Version.Parse(databaseConfiguration.ServerVersion)); } }); }
/// <summary> /// 获取DbContextOptions /// </summary> /// <param name="connectionFactory"></param> /// <returns></returns> public static DbContextOptions <TestDbcontext> GetOptions(IDataBaseConnectionFactory connectionFactory) { //随机选择读数据库节点 var optionsBuilder = new DbContextOptionsBuilder <TestDbcontext>(); optionsBuilder.UseMySql(connectionFactory.GetConnectionString(), optionsBuilder => { optionsBuilder.EnableRetryOnFailure(2); }); return(optionsBuilder.Options); }
protected override void OnConfiguring(DbContextOptionsBuilder b) { base.OnConfiguring(b); if (string.IsNullOrEmpty(ConnectionString)) { throw new NullReferenceException(nameof(ConnectionString)); } b.EnableDetailedErrors(); b.EnableSensitiveDataLogging(); b.EnableServiceProviderCaching(); b.UseSqlServer(ConnectionString, b => { b.EnableRetryOnFailure(); b.MigrationsAssembly("CalendarUI.Presentation"); }); }
protected override void OnConfiguring(DbContextOptionsBuilder options) { options.UseMySql(ConnectionString, ServerVersion.FromString("8.0.20-mysql"), options => options.EnableRetryOnFailure().CharSet(CharSet.Utf8Mb4)); }
protected override void OnConfiguring(DbContextOptionsBuilder options) { options.UseMySql(ConnectionString, ServerVersion.Parse("8.0.20-mysql"), options => { options.EnableRetryOnFailure(); }); }
protected override void OnConfiguring(DbContextOptionsBuilder options) => options //.UseLoggerFactory(GlobalInstance.MyLoggerFactory) .UseSqlServer(@"Data Source=DEL1-LHP-N67629;Database=Blogging;Trusted_Connection=True;", options => options.EnableRetryOnFailure());
protected override void OnConfiguring(DbContextOptionsBuilder options) { options.UseMySql(ConnectionString, options => options.EnableRetryOnFailure().CharSet(CharSet.Utf8Mb4).ServerVersion(new Version(8, 0, 20), ServerType.MySql)); }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlServer("server=.\\sqlexpress;database=JafEcom;trusted_connection=true;", optionsBuilder => optionsBuilder.EnableRetryOnFailure()); }