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());
}
