public async Task CopyDatas(BonusDbContext from, BonusDbContext to)
{
var dbSets = GetAllDbSets();
var allDbSets = dbSets.Select(dbSet => dbSet.GetValue(from)).OfType <IQueryable <object> >();
foreach (var dbSet in allDbSets)
{
to.AddRange(await dbSet.ToListAsync());
}
await to.SaveChangesAsync();
}
private async Task <BonusDbContext> GetDbContext()
{
var connection = new SqliteConnection("Filename=:memory:");
connection.Open();
var options = new DbContextOptionsBuilder <BonusDbContext>()
.UseSqlite(connection)
.Options;
var dbContext = new BonusDbContext(options);
await dbContext.Database.MigrateAsync();
return(dbContext);
}
private async Task AddData(BonusDbContext dbContext)
{
dbContext.GuildsSettings.Add(new GuildsSettings {
GuildId = 0, Key = "Key", Module = "Module", Value = "Value"
});
dbContext.Logs.AddRange(new Logs {
Id = 1
}, new Logs {
Id = 2
}, new Logs {
Id = 3
});
dbContext.TimedActions.Add(new TimedActions {
Id = 5
});
await dbContext.SaveChangesAsync();
}
