Click or drag to resize

AdoDataConnection Methods

The AdoDataConnection type exposes the following members.

Methods
  Name Description
Public method Bool Returns proper Boolean implementation for connected AdoDataConnection database type.
Public method Dispose Releases all the resources used by the AdoDataConnection object.
Protected method Dispose(Boolean) Releases the unmanaged resources used by the AdoDataConnection object and optionally releases the managed resources.
Public method Equals Determines whether the specified object is equal to the current object.
(Inherited from Object)
Public method 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.
Public method ExecuteNonQuery(String, Object) Executes the SQL statement using Connection, and returns the number of rows affected.
Public method ExecuteNonQuery(Int32, String, Object) Executes the SQL statement using Connection, and returns the number of rows affected.
Public method ExecuteReader(String, Object) Executes the SQL statement using Connection, and builds a IDataReader.
Public method ExecuteReader(Int32, String, Object) Executes the SQL statement using Connection, and builds a IDataReader.
Public method ExecuteReader(CommandBehavior, Int32, String, Object) Executes the SQL statement using Connection, and builds a IDataReader.
Public method 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.
Public method 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.
Public method 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.
Public method 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.
Public method 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.
Public method 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.
Public method 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.
Public method 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.
Public method 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.
Public method 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.
Public method ExecuteScript(String) Executes the given SQL script using Connection.
Public method ExecuteScript(TextReader) Executes the given SQL script using Connection.
Protected method Finalize Releases the unmanaged resources before the AdoDataConnection object is reclaimed by GC.
(Overrides ObjectFinalize)
Public method GetHashCode Serves as the default hash function.
(Inherited from Object)
Public method GetType Gets the Type of the current instance.
(Inherited from Object)
Public method Guid(Guid) Returns proper Guid implementation for connected AdoDataConnection database type.
Public method Guid(DataRow, String) Retrieves Guid from a DataRow field based on database type.
Protected method MemberwiseClone Creates a shallow copy of the current Object.
(Inherited from Object)
Public method ParameterizedQueryString Creates a parameterized query string for the underlying database type based on the given format string and parameter names.
Public method Static member ReloadConfigurationSettings Forces a reload of cached configuration connection settings.
Public method 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.
Public method 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.
Public method RetrieveDataSet(String, Object) Executes the SQL statement using Connection, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public method RetrieveDataSet(Int32, String, Object) Executes the SQL statement using Connection, and returns the DataSet that may contain multiple tables, depending on the SQL statement.
Public method RetrieveRow(String, Object) Executes the SQL statement using Connection, and returns the first DataRow in the result set.
Public method RetrieveRow(Int32, String, Object) Executes the SQL statement using Connection, and returns the first DataRow in the result set.
Public method Static member ToDataProviderString Generates a data provider string for the given connection type and adapter type.
Public method ToString Returns a string that represents the current object.
(Inherited from Object)
Public method TryRetrieveRow(String, DataRow, Object) Tries to retrieve the first DataRow in the result set of the SQL statement using Connection.
Public method TryRetrieveRow(Int32, String, DataRow, Object) Tries to retrieve the first DataRow in the result set of the SQL statement using Connection.
Top
Extension Methods
  Name Description
Public Extension Method GetEnumValueOrDefault Gets the enumeration constant for value, if defined in the enumeration, or a default value.
(Defined by EnumExtensions)
Public Extension Method GetEnumValueOrDefaultT Gets the enumeration constant for this value, if defined in the enumeration, or a default value.
(Defined by EnumExtensions)
Top
See Also