public void Create(VersionLog versionLog)
{
if (versionLog.Id != 0)
{
return;
}
Db.VersionLog.Add(versionLog);
Db.SaveChanges();
}
public void Remove(VersionLog versionLog)
{
var entity = Db.VersionLog.FirstOrDefault(p => p.Id.Equals(versionLog.Id));
if (entity == null)
{
return;
}
Db.VersionLog.Remove(entity);
Db.SaveChanges();
}
public void UpdateDatabase()
{
LoadScripts(Folder);
foreach (var script in Scripts.OrderBy(s => s.Script))
{
if (context.VersionLogs.Count(vl => vl.Script == script.Script) == 0)
{
var sql = script.LoadFullText();
ExecuteSql(sql);
VersionLog log = new VersionLog();
log.Script = script.Script;
log.FileName = script.FileName;
log.DeployDate = DateTimeOffset.Now;
context.VersionLogs.Add(log);
}
}
context.SaveChanges();
}
public void UpdateDatabase()
{
ScriptRepo.Refresh();
var versionLogs = DbContext.VersionLogs.ToList();
foreach (var script in ScriptRepo.Scripts.OrderBy(s => s.Script))
{
if (versionLogs.Count(vl => vl.Script == script.Script) == 0)
{
var changeScript = script.LoadFullText();
DbContext.ExecuteNonQuery(changeScript);
VersionLog log = new VersionLog();
log.Script = script.Script;
log.FileName = script.FileName;
log.DeployDate = DateTimeOffset.Now;
DbContext.VersionLogs.Add(log);
}
}
DbContext.SaveChanges();
}
public void Update(VersionLog versionLog)
{
Db.SaveChanges();
}
