public Task <LicenseEntity> GetAsync()
{
using (var db = _databaseContextFactory.CreateDbContext())
{
return(db.Licenses.FirstOrDefaultAsync());
}
}
public async Task AddAsync(ConnectionEntity connectionEntity)
{
using (var db = _databaseContextFactory.CreateDbContext())
{
using (var transaction = await db.Database.BeginTransactionAsync())
{
try
{
var order = await db.Connections
.DefaultIfEmpty()
.MaxAsync(c => c.Order);
connectionEntity.Order = order + 1;
db.Connections.Add(connectionEntity);
await db.SaveChangesAsync();
transaction.Commit();
}
catch
{
transaction.Rollback();
throw;
}
}
}
}
private Task MigrateDatabaseAsync()
{
using (var db = _databaseContextFactory.CreateDbContext())
{
return(db.Database.MigrateAsync());
}
}
public async Task SaveSkipUpdate(Version version)
{
var alreadySkipped = await CheckSkipUpdate(version);
if (alreadySkipped)
{
return;
}
using (var db = _databaseContextFactory.CreateDbContext())
{
db.SkipUpdates.Add(new SkipUpdateEntity
{
Id = Guid.NewGuid(),
DateTime = DateTimeOffset.UtcNow,
Version = version.ToString()
});
await db.SaveChangesAsync();
}
}
public KeyValueStorage(IDatabaseContextFactory databaseContextFactory)
{
_db = databaseContextFactory.CreateDbContext();
}
