SqlBuilder<(Of <(<'TDbType>)>)> Methods
The SqlBuilder<(Of <(<'TDbType>)>)> type exposes the following members.
Methods
| Name | Description | |
|---|---|---|
|
ApplyAnonymousFilterValue |
Applies the filter value, returning a set of expressions suitable for use in a WHERE clause.
|
|
|
ApplyArgumentValue(IDataSource, Nullable<(Of <<'(Object>)>>)) |
Applies the argument value for an undefined operation.
|
|
|
ApplyArgumentValue(IDataSource, OperationTypes, Nullable<(Of <<'(Object>)>>), Boolean) |
Applies the argument value.
|
|
|
ApplyArgumentValue(IDataSource, Object, InsertOptions) |
Applies the argument value.
|
|
|
ApplyArgumentValue(IDataSource, Object, DeleteOptions, Boolean) |
Applies the argument value.
|
|
|
ApplyArgumentValue(IDataSource, Object, UpsertOptions) |
Applies the argument value.
|
|
|
ApplyArgumentValue(IDataSource, Nullable<(Of <<'(Object>)>>), UpdateOptions, Boolean) |
Applies the argument value.
|
|
|
ApplyDesiredColumns |
Uses a desired columns enumeration to indicate which columns should be set to read-mode.
|
|
|
ApplyFilterValue |
Applies the filter value, returning a set of expressions suitable for use in a WHERE clause.
|
|
|
ApplyRulesForSelect |
Applies the audit rules for select operations.
|
|
|
ApplyTableType |
Applies a user defined table type as the argument.
|
|
|
BuildAnonymousFromFunctionClause |
Builds FROM clause for a function.
|
|
|
BuildAnonymousSetClause |
Builds a list of assignments suitable for using in the SET clause of UPDATE statement. This does not include the actual SET keyword.
This will mark key columns for use in parameter building.
|
|
|
BuildAnonymousSoftDeleteClause |
Builds the soft delete clause.
|
|
|
BuildAnonymousValuesClause |
Builds a list of columns suitable for using in the VALUES clause of INSERT statement. This does not include the actual VALUES keyword.
This will mark key columns for use in parameter building.
|
|
|
BuildAnonymousWhereClause |
Builds the standard WHERE clause from Key columns.
This will mark key columns for use in parameter building.
|
|
|
BuildDeleteStatement |
Builds a complete select statement using the keys as a filter. This is mostly used in conjunction with an UPDATE or DELETE operation.
|
|
|
BuildFromFunctionClause |
Builds FROM clause for a function.
|
|
|
BuildInsertClause |
Builds a list of columns suitable for using in an INSERT statement.
This will mark key columns for use in parameter building.
|
|
|
BuildInsertStatement |
Builds a complete insert statement.
|
|
|
BuildOrderByClause |
Builds an order by clause.
|
|
|
BuildSelectByKeyStatement |
Builds a complete select statement using the keys as a filter. This is mostly used in conjunction with an UPDATE or DELETE operation.
|
|
|
BuildSelectClause |
Builds a list of columns suitable for using in a SELECT or OUTPUT statement.
|
|
|
BuildSelectTvpForInsertClause |
Builds a list of columns suitable for using in a SELECT from @TableParameter clause.
|
|
|
BuildSetClause |
Builds a list of assignments suitable for using in the SET clause of UPDATE statement. This does not include the actual SET keyword.
This will mark key columns for use in parameter building.
|
|
|
BuildSoftDeleteClause |
Builds the soft delete clause.
|
|
|
BuildUpdateByKeyStatement |
Builds the complete update statement using primary keys.
|
|
|
BuildValuesClause(StringBuilder, String, String, Boolean) |
Builds a list of columns suitable for using in the VALUES clause of INSERT statement. This does not include the actual VALUES keyword.
This will mark key columns for use in parameter building.
|
|
|
BuildValuesClause<(Of <<'(TParameter>)>>)(StringBuilder, String, String, Boolean, String, List<(Of <<'(TParameter>)>>), ParameterBuilderCallback<(Of <<'(TParameter, TDbType>)>>)) |
Builds a list of columns suitable for using in the VALUES clause of INSERT statement. This does not include the actual VALUES keyword.
This will add the associated parameters to the parameters collection.
|
|
|
BuildWhereClause |
Builds the standard WHERE clause from Key columns.
This will mark key columns for use in parameter building.
|
|
|
Equals(System.Object) | (Inherited from Object.) |
|
Finalize | (Inherited from Object.) |
|
|
GetFormalParameters |
Gets every column with a ParameterValue.
|
|
|
GetHashCode | (Inherited from Object.) |
|
|
GetInsertColumns |
Gets the insert columns.
|
|
|
GetKeyColumns |
Gets the key columns.
|
|
|
GetKeyColumns2 |
Gets the key columns.
|
|
|
GetParameterizedColumns |
Gets every column with a ParameterValue.
|
|
|
GetParameters<(Of <<'(TParameter>)>>) |
Gets the parameters.
|
|
|
GetParametersKeysLast<(Of <<'(TParameter>)>>) |
Gets the parameters, but puts the keys last.
|
|
|
GetSelectColumnDetails |
Gets the select columns with metadata details.
|
|
|
GetSelectColumns |
Gets the select columns.
|
|
|
GetType | (Inherited from Object.) |
|
|
GetUpdateColumns |
Gets the update columns.
|
|
|
MemberwiseClone | (Inherited from Object.) |
|
|
OverrideArgumentValue |
Overrides the previous selected values with the values in the indicated object.
|
|
|
OverrideKeys |
Overrides the list of keys.
|
|
|
PrimaryKeyIsIdentity<(Of <<'(TParameter>)>>) |
Returns true is the primary key includes an identity column.
|
|
|
ToString | (Inherited from Object.) |