public static bool ReloadDb() { var sqls = ReadSQL(); var db = new Membership.DataAccess.CommandRunner("dvds"); var commands = new List<NpgsqlCommand>(); foreach (var sql in sqls) { //build a command commands.Add(db.BuildCommand(sql)); } //run it var results = db.Transact(commands.ToArray()); return results.Sum() > 0; }
public static bool ReloadDb() { var sqls = ReadSQL(); var db = new Membership.DataAccess.CommandRunner("dvds"); var commands = new List <NpgsqlCommand>(); foreach (var sql in sqls) { //build a command commands.Add(db.BuildCommand(sql)); } //run it var results = db.Transact(commands.ToArray()); return(results.Sum() > 0); }