public override void BuildQuery(SQLSyntax syntax, params string[] statement) { switch (syntax) { case SQLSyntax.Select: _select = "SELECT " + statement[0]; break; case SQLSyntax.Top: _top = "SELECT TOP " + statement[0] + " " + statement[1]; break; case SQLSyntax.From: _from = "FROM \"" + statement[0] + "\""; break; case SQLSyntax.Where: _where = "WHERE " + statement[0]; break; case SQLSyntax.OrderBy: _hasOrderBy = true; _orderby = "ORDER BY " + statement[0]; break; case SQLSyntax.OrderByDescending: _hasOrderBy = true; _orderby = "ORDER BY " + statement[0] + " DESC"; break; case SQLSyntax.ThenBy: if (_hasOrderBy) { _orderby += ", " + statement[0]; } else { _orderby = "ORDER BY " + statement[0]; } break; case SQLSyntax.ThenByDescending: if (_hasOrderBy) { _orderby += ", " + statement[0] + " DESC"; } else { _orderby = "ORDER BY " + statement[0] + " DESC"; } break; } }
public override void BuildDelete(SQLSyntax syntax, string statement) { switch (syntax) { case SQLSyntax.Delete: _delete = "DELETE \"" + statement + "\""; break; case SQLSyntax.Where: _where = "WHERE " + statement; break; } }
public override void BuildInsert(SQLSyntax syntax, string statement) { switch (syntax) { case SQLSyntax.Insert: _insert = "INSERT INTO \"" + statement + "\""; break; case SQLSyntax.Fields: _fields = "(" + statement + ")"; break; case SQLSyntax.Values: _values = "VALUES (" + statement + ")"; break; } }
public override void BuildUpdate(SQLSyntax syntax, string statement) { switch (syntax) { case SQLSyntax.Update: _update = "UPDATE \"" + statement + "\""; break; case SQLSyntax.Set: _set = "SET " + statement; break; case SQLSyntax.Where: _where = "WHERE " + statement; break; } }
private ICriteria <T> AddExpression(SQLSyntax key, Expression predicate) { List <Expression> expressionList = null; if (!(expressionDictionary.TryGetValue(key.ToString(), out expressionList))) { expressionList = new List <Expression>() { predicate }; this.expressionDictionary.Add(key.ToString(), expressionList); } else { expressionList = this.expressionDictionary[key.ToString()]; expressionList.Add(predicate); this.expressionDictionary[key.ToString()] = expressionList; } return(this); }
public abstract void BuildDelete(SQLSyntax syntax, string statement);
public abstract void BuildInsert(SQLSyntax syntax, string statement);
public abstract void BuildQuery(SQLSyntax syntax, params string[] statement);