AdoDataConnection Methods

Methods

Bool Returns proper Boolean implementation for connected AdoDataConnection database type.
DefineSettings Establishes default settings for the config file.
Dispose Releases all the resources used by the AdoDataConnection object.
Dispose(Boolean) Releases the unmanaged resources used by the AdoDataConnection object and optionally releases the managed resources.
DisposeAsync Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources asynchronously.
DisposeAsyncCore Asynchronously releases the resources used by the AdoDataConnection object.
EqualsDetermines whether the specified object is equal to the current object.
(Inherited from Object)
EscapeIdentifier Escapes an identifier, e.g., a table or field name, using the common delimiter for the connected AdoDataConnection database type or the standard ANSI escaping delimiter, i.e., double-quotes, based on the useAnsiQuotes flag.
ExecuteNonQuery(String, Object) Executes the SQL statement using Connection, and returns the number of rows affected.
ExecuteNonQuery(Int32, String, Object) Executes the SQL statement using Connection, and returns the number of rows affected.
ExecuteNonQueryAsync(String, CancellationToken, Object) Executes the SQL statement using Connection, and returns the number of rows affected.
ExecuteNonQueryAsync(Int32, String, CancellationToken, Object) Executes the SQL statement using Connection, and returns the number of rows affected.
ExecuteReader(String, Object) Executes the SQL statement using Connection, and builds a DbDataReader.
ExecuteReader(Int32, String, Object) Executes the SQL statement using Connection, and builds a DbDataReader.
ExecuteReader(CommandBehavior, Int32, String, Object) Executes the SQL statement using Connection, and builds a DbDataReader.
ExecuteReaderAsync(String, CancellationToken, Object) Executes the SQL statement using Connection, and builds a DbDataReader.
ExecuteReaderAsync(Int32, String, CancellationToken, Object) Executes the SQL statement using Connection, and builds a DbDataReader.
ExecuteReaderAsync(CommandBehavior, Int32, String, CancellationToken, Object) Executes the SQL statement using Connection, and builds a DbDataReader.
ExecuteScalar(String, Object) Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set.
ExecuteScalar(Int32, String, Object) Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set.
ExecuteScalar(Type, String, Object) Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set as type returnType.
ExecuteScalar(Type, Int32, String, Object) Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set as type returnType.
ExecuteScalar(Type, Object, String, Object) Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set as type returnType, substituting defaultValue if Value is retrieved.
ExecuteScalar(Type, Object, Int32, String, Object) Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set as type returnType, substituting defaultValue if Value is retrieved.
ExecuteScalarT(String, Object) Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set as type T.
ExecuteScalarT(Int32, String, Object) Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set as type T.
ExecuteScalarT(T, String, Object) Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set as type T, substituting defaultValue if Value is retrieved.
ExecuteScalarT(T, Int32, String, Object) Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set as type T, substituting defaultValue if Value is retrieved.
ExecuteScalarAsync(String, CancellationToken, Object) Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set.
ExecuteScalarAsync(Int32, String, CancellationToken, Object) Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set.
ExecuteScalarAsync(Type, String, CancellationToken, Object) Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set as type returnType.
ExecuteScalarAsync(Type, Int32, String, CancellationToken, Object) Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set as type returnType.
ExecuteScalarAsync(Type, Object, String, CancellationToken, Object) Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set as type returnType, substituting defaultValue if Value is retrieved.
ExecuteScalarAsync(Type, Object, Int32, String, CancellationToken, Object) Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set as type returnType, substituting defaultValue if Value is retrieved.
ExecuteScalarAsyncT(String, CancellationToken, Object) Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set as type T.
ExecuteScalarAsyncT(Int32, String, CancellationToken, Object) Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set as type T.
ExecuteScalarAsyncT(T, String, CancellationToken, Object) Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set as type T, substituting defaultValue if Value is retrieved.
ExecuteScalarAsyncT(T, Int32, String, CancellationToken, Object) Executes the SQL statement using Connection, and returns the value in the first column of the first row in the result set as type T, substituting defaultValue if Value is retrieved.
ExecuteScript(String) Executes the given SQL script using Connection.
ExecuteScript(TextReader) Executes the given SQL script using Connection.
Finalize Releases the unmanaged resources before the AdoDataConnection object is reclaimed by GC.
(Overrides ObjectFinalize)
GetHashCodeServes as the default hash function.
(Inherited from Object)
GetTypeGets the Type of the current instance.
(Inherited from Object)
Guid(Guid) Returns proper Guid implementation for connected AdoDataConnection database type.
Guid(DataRow, String) Retrieves Guid from a DataRow field based on database type.
MemberwiseCloneCreates a shallow copy of the current Object.
(Inherited from Object)
ParameterizedQueryString Creates a parameterized query string for the underlying database type based on the given format string and parameter names.
RetrieveData(String, Object) Executes the SQL statement using Connection, and returns the first DataTable of result set, if the result set contains at least one table.
RetrieveData(Int32, String, Object) Executes the SQL statement using Connection, and returns the first DataTable of result set, if the result set contains at least one table.
RetrieveDataAsAsyncEnumerable(String, CancellationToken, Object) Executes the SQL statement using Connection, and returns the first DataTable of result set, if the result set contains at least one table, as an asynchronous enumerable.
RetrieveDataAsAsyncEnumerable(DataTable, String, CancellationToken, Object) Executes the SQL statement using Connection using a DbDataReader and returns data rows based on the provided schema as an asynchronous enumerable.
RetrieveDataAsAsyncEnumerable(Int32, String, CancellationToken, Object) Executes the SQL statement using Connection, and returns the first DataTable of result set, if the result set contains at least one table, as an asynchronous enumerable.
RetrieveDataAsAsyncEnumerable(DataTable, Int32, String, CancellationToken, Object) Executes the SQL statement using Connection using a DbDataReader and returns data rows based on the provided schema as an asynchronous enumerable.
RetrieveDataAsAsyncEnumerable(DataTable, CommandBehavior, Int32, String, CancellationToken, Object) Executes the SQL statement using Connection using a DbDataReader and returns data rows based on the provided schema as an asynchronous enumerable.
RetrieveDataAsync(String, CancellationToken, Object) Executes the SQL statement using Connection, and returns the first DataTable of result set, if the result set contains at least one table.
RetrieveDataAsync(Int32, String, CancellationToken, Object) Executes the SQL statement using Connection, and returns the first DataTable of result set, if the result set contains at least one table.
RetrieveDataSet(String, Object) Executes the SQL statement using Connection, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
RetrieveDataSet(Int32, String, Object) Executes the SQL statement using Connection, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
RetrieveDataSetAsync(String, CancellationToken, Object) Executes the SQL statement using Connection, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
RetrieveDataSetAsync(Int32, String, CancellationToken, Object) Executes the SQL statement using Connection, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
RetrieveRow(String, Object) Executes the SQL statement using Connection, and returns the first DataRow in the result set.
RetrieveRow(Int32, String, Object) Executes the SQL statement using Connection, and returns the first DataRow in the result set.
RetrieveRowAsync(String, CancellationToken, Object) Executes the SQL statement using Connection, and returns the first DataRow in the result set.
RetrieveRowAsync(Int32, String, CancellationToken, Object) Executes the SQL statement using Connection, and returns the first DataRow in the result set.
ToDataProviderString Generates a data provider string for the given connection type.
ToStringReturns a string that represents the current object.
(Inherited from Object)
TryRetrieveRow(String, DataRow, Object) Tries to retrieve the first DataRow in the result set of the SQL statement using Connection.
TryRetrieveRow(Int32, String, DataRow, Object) Tries to retrieve the first DataRow in the result set of the SQL statement using Connection.
TryRetrieveRowAsync(String, CancellationToken, Object) Tries to retrieve the first DataRow in the result set of the SQL statement using Connection.
TryRetrieveRowAsync(Int32, String, CancellationToken, Object) Tries to retrieve the first DataRow in the result set of the SQL statement using Connection.

See Also