ISqlFromBuilder Interface
.NET Standard 2.x
Represents an object used to build the FROM clause of a SQL statement.
The From clause specifies the tables, views, derived tables, and joined tables used in the DELETE, SELECT, and UPDATE statements.
Namespace: SnapObjects.Data
Assembly: SnapObjects.Data.dll
Implements
SnapObjects.Data.ISqlJoinBuilder
SnapObjects.Data.ISqlWhereBuilder
SnapObjects.Data.ISqlGroupBuilder
SnapObjects.Data.ISqlHavingBuilder
SnapObjects.Data.ISqlOrderBuilder
SnapObjects.Data.ISqlBuilderBase
System.ICloneable<ISqlBuilder>
Syntax
public interface ISqlFromBuilder : ISqlJoinBuilder, ISqlWhereBuilder, ISqlGroupBuilder, ISqlHavingBuilder, ISqlOrderBuilder, ISqlBuilder, ISqlBuilderBase, ICloneable<ISqlBuilder>;
Property
| Name | Return Type | Description |
|---|---|---|
| HasTable | bool | Gets whether any table source has been added to the current object using the From or FromRaw method. |
Method
| Name | Return Type | Description |
|---|---|---|
| AsJoin() | ISqlJoinOnAndOr | Returns an ISqlJoinOnAndOr object which Represents an object used to build the JOIN clause of a SQL statement. |
| From(ISqlBuilder sqlBuilder, string alias) | ISqlFromBuilder | Adds a derived table (specified by another ISqlBuilder object and an alias) to the FROM clause of the current object. |
| From(string table) | ISqlFromBuilder | Adds a table or view (with no alias specified) to the FROM clause of the current object. |
| From(string table, string alias) | ISqlFromBuilder | Adds a table or view (with the alias and the schema specified) to the FROM clause of the current object. |
| From(string table, string alias, string schema) | ISqlFromBuilder | Adds a table or view (with the alias and the schema specified) to the FROM clause of the current object. |
| FromRaw(string fromClause) | ISqlFromBuilder | Adds a table source (table, view or derived table), specified by an raw SQL, to the FROM clause of the current object. |
| FromRaw(string fromClause, string builderAlias) | ISqlFromBuilder | Adds a table source (table, view or derived table), specified by an raw SQL, to the FROM clause of the current object, and specifies an alias for this table source. |
| GetTableAlias(string tableName) | string | Gets the alias for a table source that has been added to the current object using the From or FromRaw method. |