public void ConfigureServices(IServiceCollection services)
{
services.AddSwaggerGen(c => { c.SwaggerDoc("v1", new Info {
Title = "API"
}); });
services.CreateAutoMapper();
services.AddMvc()
.AddApplicationPart(typeof(ApiController).Assembly)
.SetCompatibilityVersion(CompatibilityVersion.Version_2_2);
var dbHelper = new DbConnectionHelper(Configuration);
services
.AddEntityFrameworkNpgsql()
.AddDbContext <CompositeKeyContext>(options =>
{
options.UseNpgsql(dbHelper.GetConnectionString(),
b =>
{
b.MigrationsAssembly(typeof(CompositeKeyContext).Assembly.GetName().Name);
b.ProvideClientCertificatesCallback(dbHelper.ProvideClientCertificatesCallback);
b.RemoteCertificateValidationCallback(
dbHelper.RemoteCertificateValidationCallback);
});
options.UseOpenIddict();
})
.BuildServiceProvider();
}
public void GetConnectionStringTest()
{
DbSource dbSource = new DbSource();
DbConnectionHelper helper = new DbConnectionHelper(dbSource);
string connection = helper.GetConnectionString("Odbc Data Provider");
Assert.IsNotNull(connection);
}
protected CompositeKeyContext GetContext(IConfiguration configuration)
{
var dbHelper = new DbConnectionHelper(Configuration);
var ContextBuilder = new DbContextOptionsBuilder <CompositeKeyContext>();
ContextBuilder.UseNpgsql(dbHelper.GetConnectionString(),
b =>
{
b.MigrationsAssembly(typeof(CompositeKeyContext).Assembly.GetName().Name);
b.ProvideClientCertificatesCallback(dbHelper.ProvideClientCertificatesCallback);
b.RemoteCertificateValidationCallback(
dbHelper.RemoteCertificateValidationCallback);
});
return(new CompositeKeyContext(ContextBuilder.Options));
}
private bool IsConnectionSuccessfull(ServerOption serverOption) => serverOption != null && (_dbConnectionService?.IsConnectionAvailable(DbConnectionHelper.GetConnectionString(serverOption.ServerName, serverOption.Username, serverOption.Password)) ?? false);
public HanelContext()
{
_connectionString = DbConnectionHelper.GetConnectionString("HANELConnection");
}
private SqlConnection SqlConnection(string _connectionString = "")
{
_connectionString = DbConnectionHelper.GetConnectionString("HANELConnection");
return(new SqlConnection(_connectionString));
}
public KaryaContext()
{
_connectionString = DbConnectionHelper.GetConnectionString("KARYAConnection");
}
