public DataContext Create(DbContextFactoryOptions options)
{
var builder = new DbContextOptionsBuilder <DataContext>();
builder.UseSqlServer("Server=(localdb)\\mssqllocaldb;Database=e_CommerceDatabase;Trusted_Connection=True;MultipleActiveResultSets=true");
return(new DataContext(builder.Options));
}
public MoodleContext Create(DbContextFactoryOptions options)
{
var optionsBuilder = new DbContextOptionsBuilder <MoodleContext>();
optionsBuilder.UseSqlServer("Server=localhost;Database=Moodle;Trusted_Connection=True;MultipleActiveResultSets=true");
return(new MoodleContext(optionsBuilder.Options));
}
/// <summary>
/// :\ Used for migrations
/// </summary>
/// <param name="options"></param>
/// <returns></returns>
public NadekoContext Create(DbContextFactoryOptions options)
{
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseSqlite("Filename=./data/NadekoBot.db");
return(new NadekoContext(optionsBuilder.Options));
}
public SchoolContext Create(DbContextFactoryOptions options, ConnectionStringSelector connectionStringSelector)
{
var config = Config.GetInstance();
var dbContextOptionsBuilder = new DbContextOptionsBuilder <SchoolContext>();
switch (config.DatabaseType)
{
case Config.Database.MySql:
dbContextOptionsBuilder
.UseMySQL(config.MySqlDatabaseConfig.GetConnectionString(connectionStringSelector));
break;
case Config.Database.SqlServer:
dbContextOptionsBuilder
.UseSqlServer(config.SqlServerDatabaseConfig.GetConnectionString(connectionStringSelector));
break;
case Config.Database.PostgreSql:
dbContextOptionsBuilder
.UseNpgsql(config.PostgreSqlDatabaseConfig.GetConnectionString(connectionStringSelector));
break;
default:
throw new Exception($"Unknown database type (was '{config.DatabaseType}')");
}
dbContextOptionsBuilder.UseLazyLoading();
var ctx = new SchoolContext(dbContextOptionsBuilder.Options);
return(ctx);
}
public AppDbContext Create(DbContextFactoryOptions options)
{
var builder = new DbContextOptionsBuilder <AppDbContext>();
builder.UseSqlite("Data Source=TeamScreen.sqlite");
return(new AppDbContext(builder.Options));
}
public ParticipantLibraryContext Create(DbContextFactoryOptions options)
{
var optionsBuilder = new DbContextOptionsBuilder <ParticipantLibraryContext>();
optionsBuilder.UseSqlServer(@"Data Source=HV-MUFASA\DEV01;Initial Catalog=ParticipantLibrary;Integrated Security=true;Connect Timeout=15;");
return(new ParticipantLibraryContext(optionsBuilder.Options));
}
public IdentityServerDbContext Create(DbContextFactoryOptions options)
{
var builder = new ConfigurationBuilder()
.SetBasePath(options.ContentRootPath)
.AddJsonFile("appsettings.json")
.AddJsonFile($"appsettings.{options.EnvironmentName}.json", true)
.AddEnvironmentVariables();
var config = builder.Build();
var connstr = config.GetConnectionString("DefaultConnection");
if (string.IsNullOrWhiteSpace(connstr))
{
throw new InvalidOperationException("Could not find a connection string named '(DefaultConnection)'.");
}
if (string.IsNullOrEmpty(connstr))
{
throw new InvalidOperationException($"{nameof(connstr)} is null or empty.");
}
var migrationsAssembly = typeof(IdentityServerDbContextFactory).GetTypeInfo().Assembly.GetName().Name;
var optionsBuilder = new DbContextOptionsBuilder <IdentityServerDbContext>();
optionsBuilder.UseSqlServer(connstr, b => b.MigrationsAssembly(migrationsAssembly));
return(new IdentityServerDbContext(optionsBuilder.Options));
}
public Db Create(DbContextFactoryOptions options)
{
var builder = new DbContextOptionsBuilder <Db>();
builder.UseSqlite("Filename=./piranha-dev.db");
return(new Db(builder.Options));
}
public ApplicationDbContext Create(DbContextFactoryOptions options)
{
var builder = new DbContextOptionsBuilder <ApplicationDbContext>();
builder.UseNpgsql("User ID=postgres;Password=wickedman;Host=localhost;Port=5432;Database=eduportal;Pooling=true;");
return(new ApplicationDbContext(builder.Options));
}
public VoteMonitorContext CreateDBContext(DbContextFactoryOptions options)
{
var builder = new DbContextOptionsBuilder <VoteMonitorContext>();
builder.UseSqlServer(Startup.RegisterConfiguration().GetConnectionString("DefaultConnection"));
return(new VoteMonitorContext(builder.Options));
}
public NccDbContext Create(DbContextFactoryOptions options)
{
var opts = SetupHelper.GetDbContextOptions();
var nccDbConetxt = new NccDbContext(opts);
return(nccDbConetxt);
}
/// <inheritdoc />
public ConfigurationContext Create(DbContextFactoryOptions options)
{
var builder = new DbContextOptionsBuilder <ConfigurationContext>();
builder.UseNpgsql("configurationContext", b => b.MigrationsAssembly("KlusterKite.NodeManager.ConfigurationSource"));
return(new ConfigurationContext(builder.Options));
}
public AccountContext Create(DbContextFactoryOptions options)
{
var builder = new DbContextOptionsBuilder <AccountContext>();
builder.UseSqlServer("Server=.;Database=MT_Accounts01;Trusted_Connection=True;");
return(new AccountContext(builder.Options));
}
public AppDbContext Create(DbContextFactoryOptions options)
{
var optionsBuilder = new DbContextOptionsBuilder <AppDbContext>();
optionsBuilder.UseSqlServer("Server=(localdb)\\v11.0;Database=BethanysPieShop4;Trusted_Connection=True;MultipleActiveResultSets=true");
return(new AppDbContext(optionsBuilder.Options));
}
/// <summary>
/// Метод, необходимый для использования миграций. Не нужен при дальнейших подключениях
/// </summary>
/// <param name="options"></param>
/// <returns></returns>
public TripleBDbContext Create(DbContextFactoryOptions options)
{
//var builder = new DbContextOptionsBuilder<TripleBDbContext>();
//builder.UseSqlServer("Server=(localdb)\\mssqllocaldb;Database=boatdb;Trusted_Connection=True;MultipleActiveResultSets=true");
//return new TripleBDbContext(builder.Options);
throw new ArgumentNullException();
}
public SchoolContext Create(DbContextFactoryOptions options)
{
var builder = new DbContextOptionsBuilder <SchoolContext>();
builder.UseSqlServer("Server=(localdb)\\mssqllocaldb;Database=MyContosoUniversityCoreDb;Trusted_Connection=True;MultipleActiveResultSets=true");
return(new SchoolContext(builder.Options));
}
public MjrContext Create(DbContextFactoryOptions options)
{
var ctxOptions = new DbContextOptionsBuilder();
ctxOptions.UseSqlite(_connectionString);
return(new MjrContext(ctxOptions.Options));
}
public RootContext Create(DbContextFactoryOptions options)
{
var builder = new DbContextOptionsBuilder <RootContext>();
builder.UseSqlServer("Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=ef7-test-db; Integrated Security=True;");
return(new RootContext(builder.Options));
}
public CMEExamDbContext Create(DbContextFactoryOptions options)
{
var optionsBuilder = new DbContextOptionsBuilder <CMEExamDbContext>();
optionsBuilder.UseSqlServer("server=192.168.4.107;uid=sa;pwd=Abc@123;database=CMEDB_Exam");
return(new CMEExamDbContext(optionsBuilder.Options));
}
public PokeContext Create(DbContextFactoryOptions options)
{
var builder = new DbContextOptionsBuilder <PokeContext>();
builder.UseSqlServer(@"Server = (localdb)\mssqllocaldb; Database = PokeApi; Trusted_Connection = True;");
return(new PokeContext(builder.Options));
}
public WorkflowContext Create(DbContextFactoryOptions options)
{
var builder = new DbContextOptionsBuilder <WorkflowContext>();
builder.UseSqlServer("Server=(local)\\SQLEXPRESS;Database=formsDB;Trusted_Connection=True;MultipleActiveResultSets=true");
return(new WorkflowContext(builder.Options));
}
public SimApiContext Create(DbContextFactoryOptions options)
{
var builder = new DbContextOptionsBuilder <SimApiContext>();
builder.UseSqlServer(ConfigurationHelper.GetSetting("ConnectionStrings:DefaultConnection"));
return(new SimApiContext(builder.Options));
}
public CdpContext Create(DbContextFactoryOptions options)
{
var builder = new DbContextOptionsBuilder <CdpContext>();
builder.UseMySQL("User ID=root;Password=andresiri;Server=127.0.0.1;Database=cdp;");
return(new CdpContext(builder.Options, new HttpContextAccessor()));
}
public CommonContext Create(DbContextFactoryOptions options)
{
var builder = new DbContextOptionsBuilder <CommonContext>();
builder.UseSqlServer("Server=.;Database=MT_Common;Trusted_Connection=True;");
return(new CommonContext(builder.Options));
}
public ApplicationDbContext Create(DbContextFactoryOptions options)
{
var builder = new DbContextOptionsBuilder <ApplicationDbContext>();
builder.UseSqlServer("Server=.\\SQLEXPRESS;Database=OnePiece;Integrated Security=true;User Id=OnePieceApi;Password=Abcd@@1234;");
return(new ApplicationDbContext(builder.Options));
}
public SaleTrackerContext Create(DbContextFactoryOptions options)
{
var builder = new DbContextOptionsBuilder <SaleTrackerContext>();
builder.UseSqlServer("Data Source=(localdb)\\MSSQLLocalDB;Database=SaleTrackerDb;Trusted_Connection=true;MultipleActiveResultSets=true;");
return(new SaleTrackerContext(builder.Options));
}
public ApplicationDbContext Create(DbContextFactoryOptions options)
{
var builder = new DbContextOptionsBuilder <ApplicationDbContext>();
builder.UseSqlServer("https://github.com/aspnet/EntityFramework/issues/8427");
return(new ApplicationDbContext(default(long), null, builder.Options));
}
public Context.RepositoryContext Create(DbContextFactoryOptions options)
{
var builder = new DbContextOptionsBuilder <Context.RepositoryContext>();
builder.UseSqlServer("Server=(localdb)\\mssqllocaldb;Database=Legacy;Trusted_Connection=True;MultipleActiveResultSets=true");
return(new Context.RepositoryContext(builder.Options));
}
public CompanyContext Create(DbContextFactoryOptions options)
{
var builder = new DbContextOptionsBuilder <CompanyContext>();
builder.UseSqlServer(@"Server=.\SQLExpress;Database=EFODataAPI;Trusted_Connection=True;MultipleActiveResultSets=true");
return(new CompanyContext(builder.Options));
}
public DBContext Create(DbContextFactoryOptions options)
{
var optionsBuilder = new DbContextOptionsBuilder();
optionsBuilder.UseSqlite("Filename=data/nat.db");
return(new DBContext(optionsBuilder.Options));
}
