SqlClauseJoin
Namespace: TagBites.Sql
Assembly: TagBites.DB.dll
Product: TagBites.DB v. 1.0.37
public class SqlClauseJoin : TagBites.Sql.SqlClauseCollectionBase<TagBites.Sql.SqlClauseJoinEntry>Inheritance: SqlClauseCollectionBase<SqlClauseJoinEntry> → SqlClauseJoin
Constructors
Section titled “Constructors”SqlClauseJoin()
Section titled “SqlClauseJoin()”public SqlClauseJoin()Methods
Section titled “Methods”Accept(SqlQueryResolver, SqlQueryBuilder)
Section titled “Accept(SqlQueryResolver, SqlQueryBuilder)”protected virtual void Accept(SqlQueryResolver resolver, SqlQueryBuilder builder)Parameters
Section titled “Parameters”resolverSqlQueryResolverbuilderSqlQueryBuilder
AddOn(SqlClauseJoinEntryType, SqlColumn, SqlColumn)
Section titled “AddOn(SqlClauseJoinEntryType, SqlColumn, SqlColumn)”public SqlTable AddOn(SqlClauseJoinEntryType joinType, SqlColumn joinTableColumn, SqlColumn otherTableColumn)Parameters
Section titled “Parameters”joinTypeSqlClauseJoinEntryTypejoinTableColumnSqlColumnotherTableColumnSqlColumn
Returns
Section titled “Returns”AddOn(SqlClauseJoinEntryType, SqlTable, string, SqlColumn)
Section titled “AddOn(SqlClauseJoinEntryType, SqlTable, string, SqlColumn)”public SqlTable AddOn(SqlClauseJoinEntryType joinType, SqlTable joinTable, string joinTableColumnName, SqlColumn otherTableColumn)Parameters
Section titled “Parameters”joinTypeSqlClauseJoinEntryTypejoinTableSqlTablejoinTableColumnNamestringotherTableColumnSqlColumn
Returns
Section titled “Returns”AddOn(SqlClauseJoinEntryType, SqlTable, string, SqlTable, string)
Section titled “AddOn(SqlClauseJoinEntryType, SqlTable, string, SqlTable, string)”public SqlTable AddOn(SqlClauseJoinEntryType joinType, SqlTable joinTable, string joinTableColumnName, SqlTable otherTable, string otherTableColumnName)Parameters
Section titled “Parameters”joinTypeSqlClauseJoinEntryTypejoinTableSqlTablejoinTableColumnNamestringotherTableSqlTableotherTableColumnNamestring
Returns
Section titled “Returns”AddOn(SqlClauseJoinEntryType, string, string, SqlColumn)
Section titled “AddOn(SqlClauseJoinEntryType, string, string, SqlColumn)”public SqlTable AddOn(SqlClauseJoinEntryType joinType, string joinTableName, string joinTableColumnName, SqlColumn otherTableColumn)Parameters
Section titled “Parameters”joinTypeSqlClauseJoinEntryTypejoinTableNamestringjoinTableColumnNamestringotherTableColumnSqlColumn
Returns
Section titled “Returns”AddOn(SqlClauseJoinEntryType, string, string, SqlTable, string)
Section titled “AddOn(SqlClauseJoinEntryType, string, string, SqlTable, string)”public SqlTable AddOn(SqlClauseJoinEntryType joinType, string joinTableName, string joinTableColumnName, SqlTable otherTable, string otherTableColumnName)Parameters
Section titled “Parameters”joinTypeSqlClauseJoinEntryTypejoinTableNamestringjoinTableColumnNamestringotherTableSqlTableotherTableColumnNamestring
Returns
Section titled “Returns”AddOn(SqlClauseJoinEntryType, string, string, string, SqlColumn)
Section titled “AddOn(SqlClauseJoinEntryType, string, string, string, SqlColumn)”public SqlTable AddOn(SqlClauseJoinEntryType joinType, string joinTableName, string joinTableAlias, string joinTableColumnName, SqlColumn otherTableColumn)Parameters
Section titled “Parameters”joinTypeSqlClauseJoinEntryTypejoinTableNamestringjoinTableAliasstringjoinTableColumnNamestringotherTableColumnSqlColumn
Returns
Section titled “Returns”AddOn(SqlClauseJoinEntryType, string, string, string, SqlTable, string)
Section titled “AddOn(SqlClauseJoinEntryType, string, string, string, SqlTable, string)”public SqlTable AddOn(SqlClauseJoinEntryType joinType, string joinTableName, string joinTableAlias, string joinTableColumnName, SqlTable otherTable, string otherTableColumnName)Parameters
Section titled “Parameters”joinTypeSqlClauseJoinEntryTypejoinTableNamestringjoinTableAliasstringjoinTableColumnNamestringotherTableSqlTableotherTableColumnNamestring
Returns
Section titled “Returns”AddOn<TSqlTable>(SqlClauseJoinEntryType, Func<TSqlTable, SqlColumn>, SqlColumn)
Section titled “AddOn<TSqlTable>(SqlClauseJoinEntryType, Func<TSqlTable, SqlColumn>, SqlColumn)”public TSqlTable AddOn(SqlClauseJoinEntryType joinType, Func<TSqlTable, SqlColumn> joinTableColumnSelector, SqlColumn otherTableColumn)Parameters
Section titled “Parameters”joinTypeSqlClauseJoinEntryTypejoinTableColumnSelectorFunc<TSqlTable, SqlColumn>otherTableColumnSqlColumn
Returns
Section titled “Returns”TSqlTable
AddOnExpression(SqlClauseJoinEntryType, SqlTable, SqlCondition)
Section titled “AddOnExpression(SqlClauseJoinEntryType, SqlTable, SqlCondition)”public SqlTable AddOnExpression(SqlClauseJoinEntryType joinType, SqlTable joinTable, SqlCondition expression)Parameters
Section titled “Parameters”joinTypeSqlClauseJoinEntryTypejoinTableSqlTableexpressionSqlCondition
Returns
Section titled “Returns”AddOnExpression(SqlClauseJoinEntryType, string, string, SqlCondition)
Section titled “AddOnExpression(SqlClauseJoinEntryType, string, string, SqlCondition)”public SqlTable AddOnExpression(SqlClauseJoinEntryType joinType, string joinTableName, string joinTableAlias, SqlCondition expression)Parameters
Section titled “Parameters”joinTypeSqlClauseJoinEntryTypejoinTableNamestringjoinTableAliasstringexpressionSqlCondition
Returns
Section titled “Returns”AddOnOrGet(SqlClauseJoinEntryType, SqlColumn, SqlColumn)
Section titled “AddOnOrGet(SqlClauseJoinEntryType, SqlColumn, SqlColumn)”public SqlTable AddOnOrGet(SqlClauseJoinEntryType type, SqlColumn joinColumn, SqlColumn otherTableColumn)Parameters
Section titled “Parameters”typeSqlClauseJoinEntryTypejoinColumnSqlColumnotherTableColumnSqlColumn
Returns
Section titled “Returns”AddOnOrGet<TSqlTable>(SqlClauseJoinEntryType, Func<TSqlTable, SqlColumn>, SqlColumn)
Section titled “AddOnOrGet<TSqlTable>(SqlClauseJoinEntryType, Func<TSqlTable, SqlColumn>, SqlColumn)”public TSqlTable AddOnOrGet(SqlClauseJoinEntryType type, Func<TSqlTable, SqlColumn> joinTableColumnSelector, SqlColumn otherTableColumn)Parameters
Section titled “Parameters”typeSqlClauseJoinEntryTypejoinTableColumnSelectorFunc<TSqlTable, SqlColumn>otherTableColumnSqlColumn
Returns
Section titled “Returns”TSqlTable
Find(SqlClauseJoinEntryType, SqlColumn, SqlColumn)
Section titled “Find(SqlClauseJoinEntryType, SqlColumn, SqlColumn)”public SqlClauseJoinEntry Find(SqlClauseJoinEntryType type, SqlColumn joinColumn, SqlColumn otherTableColumn)Parameters
Section titled “Parameters”typeSqlClauseJoinEntryTypejoinColumnSqlColumnotherTableColumnSqlColumn
Returns
Section titled “Returns”LazyAddOn(SqlClauseJoinEntryType, string, string, SqlColumn)
Section titled “LazyAddOn(SqlClauseJoinEntryType, string, string, SqlColumn)”public Func<SqlTable> LazyAddOn(SqlClauseJoinEntryType joinType, string joinTableName, string joinTableColumnName, SqlColumn otherTableColumn)Parameters
Section titled “Parameters”joinTypeSqlClauseJoinEntryTypejoinTableNamestringjoinTableColumnNamestringotherTableColumnSqlColumn
Returns
Section titled “Returns”LazyAddOn(SqlClauseJoinEntryType, string, string, SqlTable, string)
Section titled “LazyAddOn(SqlClauseJoinEntryType, string, string, SqlTable, string)”public Func<SqlTable> LazyAddOn(SqlClauseJoinEntryType joinType, string joinTableName, string joinTableColumnName, SqlTable otherTable, string otherTableColumnName)Parameters
Section titled “Parameters”joinTypeSqlClauseJoinEntryTypejoinTableNamestringjoinTableColumnNamestringotherTableSqlTableotherTableColumnNamestring
Returns
Section titled “Returns”LazyAddOn(SqlClauseJoinEntryType, string, string, string, SqlColumn)
Section titled “LazyAddOn(SqlClauseJoinEntryType, string, string, string, SqlColumn)”public Func<SqlTable> LazyAddOn(SqlClauseJoinEntryType joinType, string joinTableName, string joinTableAlias, string joinTableColumnName, SqlColumn otherTableColumn)Parameters
Section titled “Parameters”joinTypeSqlClauseJoinEntryTypejoinTableNamestringjoinTableAliasstringjoinTableColumnNamestringotherTableColumnSqlColumn
Returns
Section titled “Returns”LazyAddOn(SqlClauseJoinEntryType, string, string, string, SqlTable, string)
Section titled “LazyAddOn(SqlClauseJoinEntryType, string, string, string, SqlTable, string)”public Func<SqlTable> LazyAddOn(SqlClauseJoinEntryType joinType, string joinTableName, string joinTableAlias, string joinTableColumnName, SqlTable otherTable, string otherTableColumnName)Parameters
Section titled “Parameters”joinTypeSqlClauseJoinEntryTypejoinTableNamestringjoinTableAliasstringjoinTableColumnNamestringotherTableSqlTableotherTableColumnNamestring
Returns
Section titled “Returns”LazyAddOn<TSqlTable>(SqlClauseJoinEntryType, Func<TSqlTable, SqlColumn>, SqlColumn)
Section titled “LazyAddOn<TSqlTable>(SqlClauseJoinEntryType, Func<TSqlTable, SqlColumn>, SqlColumn)”public Func<TSqlTable> LazyAddOn(SqlClauseJoinEntryType joinType, Func<TSqlTable, SqlColumn> joinTableColumnSelector, SqlColumn otherTableColumn)Parameters
Section titled “Parameters”joinTypeSqlClauseJoinEntryTypejoinTableColumnSelectorFunc<TSqlTable, SqlColumn>otherTableColumnSqlColumn
Returns
Section titled “Returns”Func<TSqlTable>
LazyAddOnExpression(SqlClauseJoinEntryType, string, string, SqlCondition)
Section titled “LazyAddOnExpression(SqlClauseJoinEntryType, string, string, SqlCondition)”public Func<SqlTable> LazyAddOnExpression(SqlClauseJoinEntryType joinType, string joinTableName, string joinTableAlias, SqlCondition expression)Parameters
Section titled “Parameters”joinTypeSqlClauseJoinEntryTypejoinTableNamestringjoinTableAliasstringexpressionSqlCondition