/// <summary> /// Begins a new SELECT statement with a set of fields as the result /// </summary> /// <param name="fields">The name of the fields to select</param> /// <returns>A new DBSelectQuery to support statement chaining</returns> public static DBSelectQuery SelectFields(params string[] fields) { DBSelectSet sel = DBSelectSet.SelectFields(fields); DBSelectQuery query = new DBSelectQuery(); query.SelectSet = sel; query.Last = sel; return(query); }
/// <summary> /// Specify a range of columns (as an array or comma separated list) to be set when performing this insert /// </summary> /// <param name="fields">The fields to set</param> /// <returns>Itself so that statements can be chained</returns> public DBInsertQuery Fields(params string[] fields) { if (_fields == null) { _last = _fields = DBSelectSet.SelectFields(fields); } else { foreach (string fld in fields) { _last = _fields.And(fld); } } return(this); }