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