/// <summary> /// This is the Override method of the AddTable. /// </summary> /// <param name="table"></param> public override void AddTable(SqlTableBase table) { this.QueryBuilder.AddTable(table.TableName, table.Alias); }
/// <summary> /// An Abstract method. /// </summary> /// <param name="table">SqlTableBase</param> public abstract void AddTable(SqlTableBase table);
/// <summary> /// Add Table to the query /// </summary> /// <param name="table">SqlTableBase</param> public override void AddTable(SqlTableBase table) { this.QueryBuilder.AddStoredProcedure(table.TableName); }
/// <summary> /// Method for the LeftOuterjoining of Tables.Takes a field from each tables, with there alians to join. /// </summary> /// <param name="table">SqlTableBase</param> /// <param name="mainTableField">SqlField </param> /// <param name="joinTableField">SqlField </param> public void LeftOuterJoin(SqlTableBase table, SqlField mainTableField, SqlField joinTableField) { queryBuilder.AddTable(table.TableName, table.Alias); queryBuilder.AddOuterJoin( mainTableField.Alias, mainTableField.FieldName, joinTableField.Alias, joinTableField.FieldName); }