DataSource Methods

System.Data.Generic

DataSource Methods

The DataSource type exposes the following members.

Methods
  Name Description
Public method ClearPool
Empties the connection pool associated with the current connection.
Public method Static member ClearPools
Empties all connection pool(s).
Public method Close Obsolete.
Close the data connection.
Public method CommitTransaction Obsolete.
Commits a transaction from the specified context.
Public method CreateTransaction
Create a new transaction context.
Public method CreateTransaction(String)
Create a new transaction context and leaves the connection open.
Public method Dispose
Releases all resources used by the Component.
Public method Equals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Public method Static member EscapeSql(String)
Escapes standard SQL characters.
Public method Static member EscapeSql(String, Object) Obsolete.
Escapes standard SQL characters. Can be used as String.Format.
Public method ExecuteCallBack
Executes the query, and raises a callback of ItemCallBackDelegate for each item it iterates.
Public method ExecuteDataSet
Executes the SQL query and returns a DataSet.
Public method ExecuteDataTable
Sends the SQL Query to the Connection and returns a DataTable.
Public method ExecuteDictionary
Executes the SQL statement and returns a dictionary of the first row. Keys in the dictionary are field names and values associated.
Public method ExecuteListT
Executes the query, and returns a collection of the first column.
Public method ExecuteNObjectsT
Executes the query, and returns a collection of object by the type T; hieratically compounded by the provided SQL JOIN and realted classes.
Public method ExecuteNoReturn(String)
Executes the Query against the datasource without returning any value.
Public method ExecuteNoReturn(String, TransactionContext)
Executes the Query against the datasource without returning any value. Supports transactions.
Public method ExecuteObjectT
Executes the query, and returns a object by the type T.
Public method ExecuteObjectsT
Executes the query, and returns a collection of object by the type T.
Public method ExecuteReader
Sends the SQL Query to the Connection and builds a SqlDataReader.
Public method ExecuteScalar(String)
Executes the query, and returns the first column of the first row in the result set returned by the query.
Public method ExecuteScalarT(String)
Executes the query, and returns the first column of the first row in the result set returned by the query.
Public method ExecuteScalarT(String, T)
Executes the query, and returns the first column of the first row in the result set returned by the query.
Public method ExecuteScalarT(String, TransactionContext, T)
Executes the query, and returns the first column of the first row in the result set returned by the query. Supports transactions.
Public method ExecuteXmlReader
Executes the Query against the datasource and returns a XML reader.
Public method GetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object.)
Public method Open Obsolete.
Open the data connection.
Public method Static member PrepareSql
Formats a SQL statement based on the data type of the parameters parameters.
Public method RollbackTransaction Obsolete.
Rolls back a transaction from the specified context.
Public method ToString
Returns a string that represents the current object.
(Inherited from Object.)
Top
See Also