public DBTableSet InnerJoin(string table, string parentfield, Compare op, string childfield)
{
DBTable tref = DBTable.Table(table);
return(this.InnerJoin(tref, DBField.Field(parentfield), op, DBField.Field(childfield)));
}
public static DBTableSet From(string roottable)
{
DBTable tref = DBTable.Table(roottable);
return(From(tref));
}
public static DBTableSet From(string catalog, string owner, string roottable)
{
DBTable tref = DBTable.Table(catalog, owner, roottable);
return(From(tref));
}
/// <summary>
/// Creates a new DROP TABLE method that will remove the specified table reference from the database
/// </summary>
/// <param name="tbl">The table to drop</param>
/// <returns></returns>
public static DBDropTableQuery DropTable(DBTable tbl)
{
return(DropTable(tbl.Name, tbl.Owner));
}
//
// ctor
//
#region public DBTableHintSet(DBTable owner)
public DBTableHintSet(DBTable owner)
{
this._owner = owner;
this._hints = new DBTableHintOptionList();
}
/// <summary>
/// begins a new DELETE FROM [catalog].[owner].[table] statement
/// </summary>
/// <param name="table">The name of the table to delete from</param>
/// <param name="owner">The schema owner of the table</param>
/// <returns>A new DBDeleteQuery to support statement chaining</returns>
public static DBDeleteQuery DeleteFrom(string catalog, string owner, string table)
{
DBTable ts = DBTable.Table(catalog, owner, table);
return(DeleteFrom(ts));
}
//
// DBDeleteQuery factory methods
//
#region public static DBDeleteQuery DeleteFrom(string intoTable) + 2 overloads
/// <summary>
/// begins a new DELETE FROM [table] statement
/// </summary>
/// <param name="table">The name of the table to delete from</param>
/// <returns>A new DBDeleteQuery to support statement chaining</returns>
public static DBDeleteQuery DeleteFrom(string table)
{
DBTable ts = DBTable.Table(table);
return(DeleteFrom(ts));
}
public static DBInsertQuery InsertInto(string catalog, string owner, string table)
{
DBTable tbl = DBTable.Table(catalog, owner, table);
return(InsertInto(tbl));
}
/// <summary>
/// Begins a new INSERT INTO [owner].[table] statement
/// </summary>
/// <param name="table">The table to insert the rows on</param>
/// <param name="owner">The schema owner of the table</param>
/// <returns>A new DBInsertQuery to support statement chaining</returns>
public static DBInsertQuery InsertInto(string owner, string table)
{
DBTable ts = DBTable.Table(owner, table);
return(InsertInto(ts));
}
//
// DBInsertQuery factory methods
//
#region public static DBInsertQuery InsertInto(string intoTable) + 3 overloads
/// <summary>
/// Begins a new INSERT INTO [table] statement
/// </summary>
/// <param name="intoTable">The table to insert the rows on</param>
/// <returns>A new DBInsertQuery to support statement chaining</returns>
public static DBInsertQuery InsertInto(string intoTable)
{
DBTable ts = DBTable.Table(intoTable);
return(InsertInto(ts));
}