DotNetMigrations

 private void ExecuteMigrationScripts(IEnumerable<KeyValuePair<IMigrationScriptFile, string>> scripts, Action<DbTransaction, long> updateVersionAction)
        {
            using (DbTransaction tran = Database.BeginTransaction())
            {
                IMigrationScriptFile currentScript = null;
                try
                {
                    foreach (var script in scripts)
                    {
                        currentScript = script.Key;
                        Database.ExecuteScript(tran, script.Value);
                        updateVersionAction(tran, script.Key.Version);
                    }

                    tran.Commit();
                }
                catch (Exception ex)
                {
                    tran.Rollback();

                    string filePath = (currentScript == null) ? "NULL" : currentScript.FilePath;
                    throw new MigrationException("Error executing migration script: " + filePath, filePath, ex);
                }
            }
        }