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) |
Determines whether the specified object is equal to the current object. (Inherited from Object.) |
|
Finalize |
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
|
|
GetFormalParameters |
Gets every column with a ParameterValue.
|
|
|
GetHashCode |
Serves as the default hash function. (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 |
Gets the Type of the current instance. (Inherited from Object.) |
|
|
GetUpdateColumns |
Gets the update columns.
|
|
|
MemberwiseClone |
Creates a shallow copy of the current Object. (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 |
Returns a string that represents the current object. (Inherited from Object.) |