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

Syntax

public interface ISqlFromBuilder : ISqlJoinBuilder;

Properties

Name	Return Type	Description
HasTable	bool	Gets whether any table source has been added to the current object using the From or FromRaw method.

Methods

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.