Exemple #1
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;
        }
Exemple #2
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);
        }