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) |
Determines whether the specified object is equal to the current object. (Inherited from Object.) |
![]() |
ExecuteStream(CommandExecutionToken<(Of <<'(SqlCommand, SqlParameter>)>>), StreamingCommandImplementation<(Of <<'(SqlCommand>)>>), Nullable<(Of <<'(Object>)>>)) |
Executes the specified implementation.
|
![]() |
ExecuteStream(CommandExecutionToken<(Of <<'(TCommand, TParameter>)>>), StreamingCommandImplementation<(Of <<'(TCommand>)>>), Nullable<(Of <<'(Object>)>>)) |
Executes the specified implementation.
(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 <<'(TCommand, TParameter>)>>), StreamingCommandImplementationAsync<(Of <<'(TCommand>)>>), CancellationToken, Nullable<(Of <<'(Object>)>>)) |
Executes the specified implementation asynchronously.
(Inherited from DataSource<(Of <(<'TConnection, TTransaction, TCommand, TParameter>)>)>.) |
![]() |
Finalize |
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (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 |
Serves as the default hash function. (Inherited from Object.) |
![]() |
GetType |
Gets the Type of the current instance. (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 |
Creates a shallow copy of the current Object. (Inherited from Object.) |
![]() |
OnExecutionCanceled(ExecutionEventArgs) |
Raises the ExecutionCanceled event.
(Inherited from DataSource.) |
![]() |
OnExecutionCanceled(ExecutionToken, DateTimeOffset, DateTimeOffset, Nullable<(Of <<'(Object>)>>)) | (Inherited from DataSource.) |
![]() |
OnExecutionError(ExecutionEventArgs) |
Raises the ExecutionError event.
(Inherited from DataSource.) |
![]() |
OnExecutionError(ExecutionToken, DateTimeOffset, DateTimeOffset, Exception, Nullable<(Of <<'(Object>)>>)) | (Inherited from DataSource.) |
![]() |
OnExecutionFinished(ExecutionEventArgs) |
Raises the ExecutionFinished event.
(Inherited from DataSource.) |
![]() |
OnExecutionFinished(ExecutionToken, DateTimeOffset, DateTimeOffset, Nullable<(Of <<'(Int32>)>>), Nullable<(Of <<'(Object>)>>)) | (Inherited from DataSource.) |
![]() |
OnExecutionStarted(ExecutionEventArgs) |
Raises the ExecutionStarted event.
(Inherited from DataSource.) |
![]() |
OnExecutionStarted(ExecutionToken, DateTimeOffset, Nullable<(Of <<'(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 |
Returns a string that represents the current object. (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.) |