public static void InstallDbContext(this IServiceCollection services, IConfiguration configuration)
{
var optionsBuilder = new DbContextOptionsBuilder <ClinicalTrialsDbContext>();
var connectionString = configuration.GetConnectionString(nameof(ClinicalTrialsDbContext));
if (string.IsNullOrWhiteSpace(connectionString))
{
var projectRoot = AppDomain.CurrentDomain.BaseDirectory;
var dbFullPath = Path.Join(projectRoot, "clinical-trials.db");
connectionString = $"Data Source={dbFullPath}";
}
optionsBuilder.UseSqlite(connectionString);
services.AddScoped(_ => {
var context = new ClinicalTrialsDbContext(optionsBuilder.Options);
context.Database.Migrate();
return(context);
});
}
public UnitOfWork(ClinicalTrialsDbContext context, IFullStudiesClient fullStudiesClient)
{
_context = context;
EmailRepository = new EmailRepository(context);
FullStudyRepository = new FullStudyRepository(fullStudiesClient);
}
public EmailRepository(ClinicalTrialsDbContext context)
{
_context = context;
}
