SqlServerDataSource Members
The SqlServerDataSource type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
|
SqlServerDataSource(Nullable<(Of <<'(String>)>>), String, Nullable<(Of <<'(SqlServerDataSourceSettings>)>>)) |
Initializes a new instance of the SqlServerDataSource class.
|
|
|
SqlServerDataSource(String, Nullable<(Of <<'(SqlServerDataSourceSettings>)>>)) |
Initializes a new instance of the SqlServerDataSource class.
|
|
|
SqlServerDataSource(Nullable<(Of <<'(String>)>>), SqlConnectionStringBuilder, Nullable<(Of <<'(SqlServerDataSourceSettings>)>>)) |
Initializes a new instance of the SqlServerDataSource class.
|
|
|
SqlServerDataSource(SqlConnectionStringBuilder, Nullable<(Of <<'(SqlServerDataSourceSettings>)>>)) |
Initializes a new instance of the SqlServerDataSource class.
|
Methods
| Name | Description | |
|---|---|---|
|
|
BeginTransaction |
Creates a new transaction
|
|
|
BeginTransactionAsync |
Creates a new transaction
|
|
|
Equals(System.Object) | (Inherited from Object.) |
|
|
ExecuteStream(CommandExecutionToken<(Of <<'(SqlCommand, SqlParameter>)>>), StreamingCommandImplementation<(Of <<'(SqlCommand>)>>), Nullable<(Of <<'(Object>)>>)) |
Executes the specified implementation.
|
|
|
ExecuteStream(CommandExecutionToken<(Of <<'(UTP, UTP>)>>), StreamingCommandImplementation<(Of <<'(UTP>)>>), Object) | (Inherited from DataSource<(Of <(<'TConnection, TTransaction, TCommand, TParameter>)>)>.) |
|
|
ExecuteStreamAsync(CommandExecutionToken<(Of <<'(SqlCommand, SqlParameter>)>>), StreamingCommandImplementationAsync<(Of <<'(SqlCommand>)>>), CancellationToken, Nullable<(Of <<'(Object>)>>)) |
Executes the specified implementation asynchronously.
|
|
|
ExecuteStreamAsync(CommandExecutionToken<(Of <<'(UTP, UTP>)>>), StreamingCommandImplementationAsync<(Of <<'(UTP>)>>), CancellationToken, Object) | (Inherited from DataSource<(Of <(<'TConnection, TTransaction, TCommand, TParameter>)>)>.) |
|
Finalize | (Inherited from Object.) |
|
|
GetEffectiveSettings |
Gets the options that are currently in effect. This takes into account server-defined defaults.
|
|
|
GetEffectiveSettingsAsync |
Gets the options that are currently in effect. This takes into account server-defined defaults.
|
|
|
GetExtensionData<(Of <<'(TTKey>)>>) |
Gets the extension data.
(Inherited from DataSource.) |
|
|
GetHashCode | (Inherited from Object.) |
|
|
GetType | (Inherited from Object.) |
|
|
InsertBatch(SqlServerObjectName, DataTable, SqlServerObjectName, InsertOptions) |
Inserts the batch of records as one operation.
(Inherited from SqlServerDataSourceBase.) |
|
|
InsertBatch(SqlServerObjectName, DbDataReader, SqlServerObjectName, InsertOptions) |
Inserts the batch of records as one operation.
(Inherited from SqlServerDataSourceBase.) |
|
|
InsertBatch<(Of <<'(TObject>)>>)(SqlServerObjectName, IEnumerable<(Of <<'(TObject>)>>), SqlServerObjectName, InsertOptions) |
Inserts the batch of records as one operation.
(Inherited from SqlServerDataSourceBase.) |
|
|
InsertBatch<(Of <<'(TObject>)>>)(IEnumerable<(Of <<'(TObject>)>>), SqlServerObjectName, InsertOptions) |
Inserts the batch of records as one operation..
(Inherited from SqlServerDataSourceBase.) |
|
|
InsertBulk(SqlServerObjectName, DataTable, SqlBulkCopyOptions) |
Inserts the batch of records using bulk insert.
(Inherited from SqlServerDataSourceBase.) |
|
|
InsertBulk(SqlServerObjectName, IDataReader, SqlBulkCopyOptions) |
Inserts the batch of records using bulk insert.
(Inherited from SqlServerDataSourceBase.) |
|
|
InsertBulk<(Of <<'(TObject>)>>)(SqlServerObjectName, IEnumerable<(Of <<'(TObject>)>>), SqlBulkCopyOptions) |
Inserts the batch of records using bulk insert.
(Inherited from SqlServerDataSourceBase.) |
|
|
InsertBulk<(Of <<'(TObject>)>>)(DataTable, SqlBulkCopyOptions) |
Inserts the batch of records using bulk insert.
(Inherited from SqlServerDataSourceBase.) |
|
|
InsertBulk<(Of <<'(TObject>)>>)(IDataReader, SqlBulkCopyOptions) |
Inserts the batch of records using bulk insert.
(Inherited from SqlServerDataSourceBase.) |
|
|
InsertBulk<(Of <<'(TObject>)>>)(IEnumerable<(Of <<'(TObject>)>>), SqlBulkCopyOptions) |
Inserts the batch of records using bulk insert.
(Inherited from SqlServerDataSourceBase.) |
|
|
MemberwiseClone | (Inherited from Object.) |
|
|
OnExecutionCanceled(ExecutionEventArgs) | (Inherited from DataSource.) |
|
|
OnExecutionCanceled(ExecutionToken, DateTimeOffset, DateTimeOffset, Object) | (Inherited from DataSource.) |
|
|
OnExecutionError(ExecutionEventArgs) | (Inherited from DataSource.) |
|
|
OnExecutionError(ExecutionToken, DateTimeOffset, DateTimeOffset, Exception, Object) | (Inherited from DataSource.) |
|
|
OnExecutionFinished(ExecutionEventArgs) | (Inherited from DataSource.) |
|
|
OnExecutionFinished(ExecutionToken, DateTimeOffset, DateTimeOffset, Nullable<(Of <<'(Int32>)>>), Object) | (Inherited from DataSource.) |
|
|
OnExecutionStarted(ExecutionEventArgs) | (Inherited from DataSource.) |
|
|
OnExecutionStarted(ExecutionToken, DateTimeOffset, Object) | (Inherited from DataSource.) |
|
|
OnGetDatabaseMetadata | (Inherited from SqlServerDataSourceBase.) |
|
|
Sql |
Creates a operation based on a raw SQL statement.
(Inherited from SqlServerDataSourceBase.) |
|
|
StartSqlDependency |
Starts SQL dependency on this connection string.
|
|
|
StopSqlDependency |
Stops SQL dependency on this connection string.
|
|
|
TestConnection |
Tests the connection.
(Inherited from DataSource.) |
|
|
TestConnectionAsync |
Tests the connection asynchronously.
(Inherited from DataSource.) |
|
|
ToString | (Inherited from Object.) |
|
|
WithSettings |
Creates a new data source with the indicated changes to the settings.
|
Properties
| Name | Description | |
|---|---|---|
|
ArithAbort |
Terminates a query when an overflow or divide-by-zero error occurs during query execution.
|
|
|
AuditRules |
Gets or sets the audit rules.
(Inherited from DataSource.) |
|
|
Cache |
Gets the cache to be used by this data source. The default is .NET's System.Runtime.Caching.MemoryCache.
(Inherited from DataSource.) |
|
|
DatabaseMetadata |
This object can be used to lookup database information.
|
|
|
DefaultCommandTimeout |
Gets or sets the default command timeout.
(Inherited from DataSource.) |
|
|
DefaultNVarCharLength |
Gets the default length of nVarChar string parameters. This is used when the query builder cannot determine the best parameter type and the parameter's actual length is smaller than the default length.
|
|
|
DefaultStringType |
Gets the default type of string parameters. This is used when the query builder cannot determine the best parameter type.
|
|
|
DefaultVarCharLength |
Gets the default length of varChar string parameters. This is used when the query builder cannot determine the best parameter type and the parameter's actual length is smaller than the default length.
|
|
ExtensionCache | (Inherited from DataSource.) |
|
|
IsSqlDependencyActive |
Gets a value indicating whether SQL dependency support is active for this dispatcher.
|
|
|
Name |
Gets the name of the data source.
(Inherited from DataSource.) |
|
|
SequentialAccessMode |
Gets a value indicating whether to use CommandBehavior.SequentialAccess.
(Inherited from DataSource.) |
|
|
StrictMode |
Gets a value indicating whether strict mode is enabled.
(Inherited from DataSource.) |
|
|
SuppressGlobalEvents |
Gets or sets a value indicating whether to suppress global events.
(Inherited from DataSource.) |
|
|
UserValue |
Gets or sets the user value to use with audit rules.
(Inherited from DataSource.) |
|
|
XactAbort |
Rolls back a transaction if a Transact-SQL statement raises a run-time error.
|
Events
| Name | Description | |
|---|---|---|
|
ExecutionCanceled |
Raised when a executionDetails is canceled.
(Inherited from DataSource.) |
|
|
ExecutionError |
Raised when a procedure call fails.
(Inherited from DataSource.) |
|
|
ExecutionFinished |
Raised when a procedure call is successfully completed
(Inherited from DataSource.) |
|
|
ExecutionStarted |
Raised when a procedure call is started
(Inherited from DataSource.) |