/// <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);
        }
Beispiel #2
0
        /// <summary>
        /// An Abstract method.
        /// </summary>
        /// <param name="table">SqlTableBase</param>

        public abstract void AddTable(SqlTableBase table);
Beispiel #3
0
 /// <summary>
 /// Add Table to the query
 /// </summary>
 /// <param name="table">SqlTableBase</param>
 public override void AddTable(SqlTableBase table)
 {
     this.QueryBuilder.AddStoredProcedure(table.TableName);
 }
Beispiel #4
0
        /// <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);
        }