ISqlJoinBuilder Interface
.NET Standard 2.x
Represents an object which can be used to create a joined table in the FROM clause. Joins the original table source with a new table source by the specified JOIN operation.
A joined table is a result set that combines two or more tables.
Namespace: SnapObjects.Data
Assembly: SnapObjects.Data.dll
Inherited Constructor
SnapObjects.Data.ISqlWhereBuilder
Syntax
public interface ISqlJoinBuilder : ISqlWhereBuilder;
Properties
| Name | Return Type | Description |
|---|---|---|
| HasJoin | bool | Gets whether a joined table has been created. |
| HasOn | bool | Gets whether a joined table has been created and the condition on which the join is based has been specified. |
Methods
| Name | Return Type | Description |
|---|---|---|
| AsWhere() | ISqlWhereAndOr | Returns an ISqlWhereAndOr object which represents an object used to build the WHERE clause in a SQL statement. |
| FullJoin(string table) | ISqlJoinOnBuilder | Uses the FULL OUTER JOIN operator to join the original table source and the new table source to create a joined table. |
| FullJoin(string table, string alias) | ISqlJoinOnBuilder | Uses the FULL OUTER JOIN operator to join the original table source and the new table source to create a joined table. You need to specify an alias for the new table source. |
| FullJoin(string table, string alias, string schema) | ISqlJoinOnBuilder | Uses the FULL OUTER JOIN operator to join the original table source and the new table source to create a joined table. You need to specify a schema and an alias for the new table source. |
| FullJoin(ISqlBuilder sqlBuilder, string alias) | ISqlJoinOnBuilder | Uses the FULL OUTER JOIN operator to join the original table source and the new table source (specified by a subquery generated by an ISqlBuilder object) to create a joined table. You need to specify an alias for the new table source. |
| FullJoinRaw(string joinClause) | ISqlJoinOnBuilder | Uses the FULL OUTER JOIN operator to join the original table source directly with a raw SQL to create a joined table. |
| FullJoinRaw(string joinClause, string builderAlias) | ISqlJoinOnBuilder | Uses the FULL OUTER JOIN operator to join the original table source directly with a raw SQL to create a joined table. You need to specify an alias for the raw SQL. |
| GetJoinType(string tableName) | SnapObjects.Data.SqlJoinType? | Gets the type of the JOIN operation for the specified table source. |
| InnerJoin(string table) | ISqlJoinOnBuilder | Uses the INNER JOIN operator to join the original table source and the new table source to create a joined table. |
| InnerJoin(string table, string alias) | ISqlJoinOnBuilder | Uses the INNER JOIN operator to join the original table source and the new table source to create a joined table. You need to specify an alias for the new table source. |
| InnerJoin(string table, string alias, string schema) | ISqlJoinOnBuilder | Uses the INNER JOIN operator to join the original table source and the new table source to create a joined table. You need to specify a schema and an alias for the new table source. |
| InnerJoin(ISqlBuilder sqlBuilder, string alias) | ISqlJoinOnBuilder | Uses the INNER JOIN operator to join the original table source and the new table source (specified by a subquery generated by an ISqlBuilder object) to create a joined table. You need to specify an alias for the new table source. |
| InnerJoinRaw(string joinClause) | ISqlJoinOnBuilder | Uses the INNER JOIN operator to join the original table source directly with a raw SQL to create a joined table. |
| InnerJoinRaw(string joinClause, string builderAlias) | ISqlJoinOnBuilder | Uses the INNER JOIN operator to join the original table source directly with a raw SQL to create a joined table. You need to specify an alias for the raw SQL. |
| Join(string table) | ISqlJoinOnBuilder | Creates a table by joining the original table source with a new table source, without specifying the type of the JOIN operator. |
| Join(string table, string alias) | ISqlJoinOnBuilder | Creates a table by joining the original table source with a new table source, without specifying the type of the JOIN operator. You need to specify an alias for the new table source. |
| Join(string table, string alias, string schema) | ISqlJoinOnBuilder | Creates a table by joining the original table source with a new table source, without specifying the type of the JOIN operator. You need to specify a schema and an alias for the new table source. |
| Join(ISqlBuilder sqlBuilder, string alias) | ISqlJoinOnBuilder | Creates a table by joining the original table source with a new table source which is specified by a subquery generated by an ISqlBuilder object. You need to specify an alias for the new table source. |
| JoinRaw(string joinClause) | ISqlJoinOnBuilder | Creates a table by joining the original table source directly with a raw SQL, without specifying the type of the JOIN operator. |
| JoinRaw(string joinClause, string builderAlias) | ISqlJoinOnBuilder | Creates a table by joining the original table source directly with a raw SQL, without specifying the type of the JOIN operator. You need to specify an alias for the raw SQL. |
| LeftJoin(string table) | ISqlJoinOnBuilder | Uses the LEFT OUTER JOIN operator to join the original table source and the new table source to create a joined table. |
| LeftJoin(string table, string alias) | ISqlJoinOnBuilder | Uses the LEFT OUTER JOIN operator to join the original table source and the new table source to create a joined table. You need to specify an alias for the new table source. |
| LeftJoin(string table, string alias, string schema) | ISqlJoinOnBuilder | Uses the LEFT OUTER JOIN operator to join the original table source and the new table source to create a joined table. You need to specify a schema and an alias for the new table source. |
| LeftJoin(ISqlBuilder sqlBuilder, string alias) | ISqlJoinOnBuilder | Uses the LEFT OUTER JOIN operator to join the original table source and the new table source (specified by a subquery generated by an ISqlBuilder object) to create a joined table. You need to specify an alias for the new table source. |
| LeftJoinRaw(string joinClause) | ISqlJoinOnBuilder | Uses the LEFT OUTER JOIN operator to join the original table source directly with a raw SQL to create a joined table. |
| LeftJoinRaw(string joinClause, string builderAlias) | ISqlJoinOnBuilder | Uses the LEFT OUTER JOIN operator to join the original table source directly with a raw SQL to create a joined table. You need to specify an alias for the raw SQL. |
| RightJoin(string table) | ISqlJoinOnBuilder | Creates a table by joining the original table source with a new table source using the RIGHT OUTER JOIN operator. |
| RightJoin(string table, string alias) | ISqlJoinOnBuilder | Creates a table by joining the original table source with a new table source using the RIGHT OUTER JOIN operator. You need to specify an alias for the new table source. |
| RightJoin(string table, string alias, string schema) | ISqlJoinOnBuilder | Creates a table by joining the original table source with a new table source using the RIGHT OUTER JOIN operator. You need to specify a schema and an alias for the new table source. |
| RightJoin(ISqlBuilder sqlBuilder, string alias) | ISqlJoinOnBuilder | Creates a table by joining the original table source with a new table source (specified by a subquery generated by an ISqlBuilder object) using the RIGHT OUTER JOIN operator. You need to specify an alias for the new table source. |
| RightJoinRaw(string joinClause) | ISqlJoinOnBuilder | Uses the RIGHT OUTER JOIN operator to join the original table source directly with a raw SQL to create a joined table. |
| RightJoinRaw(string joinClause, string builderAlias) | ISqlJoinOnBuilder | Uses the RIGHT OUTER JOIN operator to join the original table source directly with a string of raw SQL to create a joined table. You need to specify an alias for the raw SQL. |