public DBTableSet On(DBClause parent, Compare comp, DBClause child) { DBComparison compare = DBComparison.Compare(parent, comp, child); this.Last = this.Root.On(compare); return(this); }
// // static statement factory methods #region public static DBFilterSet Where(DBComparison compare) + 2 overloads public static DBFilterSet Where(DBClause left, Compare op, DBClause right) { if (null == left) { throw new ArgumentNullException("left"); } else if (null == right) { throw new ArgumentNullException("right"); } DBComparison comp = DBComparison.Compare(left, op, right); return(Where(comp)); }
public DBTableSet InnerJoin(DBTable table, DBClause parent, Compare op, DBClause child) { DBComparison comp = DBComparison.Compare(parent, op, child); if (this.Root is DBTable) { ((DBTable)this.Root).InnerJoin(table, comp); } else if (this.Root is DBSubQuery) { ((DBSubQuery)this.Root).InnerJoin(table, comp); } else { throw new InvalidOperationException("Current root does not support joins"); } this.Last = table; return(this); }
protected virtual DBClause DoRead(string element, XmlReader reader, XmlReaderContext context) { DBClause c = null; switch (element) { case (XmlHelper.Select): c = DBSelectQuery.Select(); break; case (XmlHelper.Delete): c = DBDeleteQuery.Delete(); break; case (XmlHelper.Update): c = DBUpdateQuery.Update(); break; case (XmlHelper.Insert): c = DBInsertQuery.InsertInto(); break; case (XmlHelper.Script): c = DBQuery.Script(); break; case (XmlHelper.Use): c = DBUseQuery.Use(); break; case (XmlHelper.Table): c = DBTable.Table(); break; case (XmlHelper.Fields): c = DBSelectSet.Select(); break; case (XmlHelper.AField): c = DBField.Field(); break; case (XmlHelper.AllFields): c = DBField.AllFields(); break; case (XmlHelper.From): c = DBTableSet.From(); break; case (XmlHelper.Where): c = DBFilterSet.Where(); break; case (XmlHelper.Group): c = DBGroupBySet.GroupBy(); break; case (XmlHelper.Order): c = DBOrderSet.OrderBy(); break; case (XmlHelper.Assignments): c = DBAssignSet.Assign(); break; case (XmlHelper.Values): c = DBValueSet.Values(); break; case (XmlHelper.Join): c = DBJoin.Join(); break; case (XmlHelper.Function): c = DBFunction.Function(); break; case (XmlHelper.Constant): c = DBConst.Null(); break; case (XmlHelper.Top): c = DBTop.Top(); break; case (XmlHelper.UnaryOp): c = DBComparison.Not(); break; case (XmlHelper.Compare): c = DBComparison.Compare(); break; case (XmlHelper.Between): c = DBComparison.Between(); break; case (XmlHelper.Parameter): //parameter is a special case. //we add them to akeyed colection if they are not already registered //then at the end we set the values at the end string name = reader.GetAttribute(XmlHelper.Name); DBParam aparam; if (context.Parameters.TryGetParameter(name, out aparam)) { c = aparam; } else { aparam = DBParam.Param(); aparam.Name = name; context.Parameters.Add(aparam); c = aparam; } break; case (XmlHelper.OrderBy): c = DBOrder.OrderBy(); break; case (XmlHelper.Calculation): c = DBCalc.Calculate(); break; case (XmlHelper.Aggregate): c = DBAggregate.Aggregate(); break; case (XmlHelper.ValueGroup): c = DBValueGroup.Empty(); break; case (XmlHelper.BooleanOperator): c = DBBooleanOp.Compare(); break; case (XmlHelper.Assign): c = DBAssign.Assign(); break; case (XmlHelper.InnerSelect): c = DBSubQuery.SubSelect(); break; case (XmlHelper.Multiple): c = DBMultiComparisonRef.Many(); break; case (XmlHelper.QueryOptionSet): c = new DBQueryHintOptionSet(); break; case (XmlHelper.QueryOption): c = DBQueryHintOption.QueryOption(); break; case (XmlHelper.CreateSproc): c = DBCreateProcedureQuery.CreateProcedure(); break; case (XmlHelper.Declare): c = DBDeclaration.Declare(); break; case (XmlHelper.CreateTable): c = DBCreateTableQuery.Table(); break; case (XmlHelper.ColumnDefinition): c = DBColumn.Column(); break; case (XmlHelper.PrimaryKey): c = DBPrimaryKey.PrimaryKey(); break; case (XmlHelper.ForeignKey): c = DBForeignKey.ForeignKey(); break; case (XmlHelper.CreateIndex): c = DBCreateIndexQuery.Index(); break; case (XmlHelper.CreateView): c = DBCreateViewQuery.CreateView(); break; case (XmlHelper.CreateSequence): c = DBCreateSequenceQuery.Sequence(); break; case (XmlHelper.DropTable): c = DBDropTableQuery.DropTable(); break; case (XmlHelper.DropIndex): c = DBDropIndexQuery.DropIndex(); break; case (XmlHelper.DropView): c = DBDropViewQuery.DropView(); break; case (XmlHelper.DropSproc): c = DBDropProcedureQuery.DropProcedure(); break; case (XmlHelper.DropSequence): c = DBDropSequenceQuery.DropSequence(); break; default: throw XmlHelper.CreateException("The XML data could not be deserialized because the element {1} was not recognised. {0}", reader, null, element); } if (c != null) { c.ReadXml(reader, context); } return(c); }
/// <summary> /// Appends a new LEFT OUTER JOIN between this table and the specified table matching between this tables parentfield and the other tables child field /// </summary> /// <param name="tbl"></param> /// <param name="parent"></param> /// <param name="comp"></param> /// <param name="child"></param> /// <returns></returns> public DBJoin LeftJoin(DBTable tbl, DBClause parent, Compare comp, DBClause child) { DBComparison c = DBComparison.Compare(parent, comp, child); return(LeftJoin(tbl, c)); }
public DBFilterSet Or(DBClause left, Compare op, DBClause clause) { return(Or(DBComparison.Compare(left, op, clause))); }
// // static methods // #region public static DBJoin InnerJoin(DBReference jointo, DBFieldRef from, DBFieldRef to, ComparisonOperator comparison) /// <summary> /// Creates a new INNER JOIN with the ON set to the comparison of from and to /// </summary> /// <param name="jointo"></param> /// <param name="from"></param> /// <param name="to"></param> /// <param name="comparison"></param> /// <returns></returns> public static DBJoin InnerJoin(DBClause jointo, DBClause from, DBClause to, Compare comparison) { DBComparison compref = DBComparison.Compare(from, comparison, to); return(InnerJoin(jointo, compref)); }