Example #1
0
 public Query(DatabaseConnection database, string query, params SQLiteParameter[] parameters)
 {
     db = database;
     cmd = db.Connection.CreateCommand();
     cmd.CommandText = query;
     foreach (SQLiteParameter param in parameters)
         cmd.Parameters.Add(param);
     Reader = cmd.ExecuteReader();
 }
Example #2
0
        public Query(DatabaseConnection database, string query, params SQLiteParameter[] parameters)
        {
            db = database;
            cmd = db.Connection.CreateCommand();
            cmd.CommandText = query;
            foreach (SQLiteParameter param in parameters)
                cmd.Parameters.Add(param);

            try
            {
                Reader = cmd.ExecuteReader();
            }
            catch (SQLiteException ex)
            {
                throw new QueryException("Failed to execute query", query, db.Path, ex);
            }
        }
Example #3
0
 public Query(DatabaseConnection database, string query)
     : this(database, query, new SQLiteParameter[] { })
 {
 }