/// <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);
}