public static void ExecuteAllScripts(Session session) { session.Command.CommandType = CommandType.Text; ExecuteScript(0, session.Command); session.Command.CommandText = "SELECT Version FROM Correspondence_Version"; int versionId = (int)session.Command.ExecuteScalar() + 1; while (ExecuteScript(versionId, session.Command)) { session.Command.CommandText = String.Format("UPDATE Correspondence_Version SET Version = {0}", versionId); session.Command.ExecuteNonQuery(); versionId = versionId + 1; } }
public Procedures(Session session) { _session = session; }
public Repository UpgradeDatabase() { using (var session = new Session(_connectionString)) { ScriptRunner.ExecuteAllScripts(session); } return this; }