/// <summary> /// List of fields /// </summary> public static string Fields(string pTable, Fields pFields) { return pFields.Count == 0 ? string.Format("`{0}`.*", pTable) : string.Join(_COMMA, from field in pFields.Values select Field(pTable, field.Name)); }
/// <summary> /// Constructor /// </summary> public JoinTable(iQueryBuilder pQuery, string pTable, IEnumerable<string> pFields) { Table = pTable; Fields = new Fields(pQuery); if (pFields == null) { return; } pFields.ToList().ForEach(pStr=>Fields.Add(new FieldValue(pStr))); }
/// <summary> /// Constructor /// </summary> public QueryBuilder(eTYPE pType, Model pModel) { _where = new Conditions(this); _type = pType; _model = pModel; Joins = new Joinable(this); _parameters = new Parameters(this, pModel); _variables = new Parameters(this, pModel); _fields = new Fields(this); _duplicate = new Fields(this); _groups = new Fields(this); Order = new List<KeyValuePair<eDIR, string>>(); Limit = 0; Offset = 0; Locked = false; }