Click or drag to resize

DataAccess Methods

The DataAccess type exposes the following members.

Methods
  NameDescription
Public methodBeginTransaction
Starts a new global transaction assumed for every actions performed onto the database
Public methodBeginTransaction(IsolationLevel)
Starts a new global transaction assumed for every actions performed onto the database
Public methodBuildFilterCriteria(Hashtable, FilterCriteria)
Returns an SQL statement built from a given FilterCriteria
Public methodBuildFilterCriteria(Hashtable, FilterCriteria, String)
Returns an SQL statement built from a given FilterCriteria
Public methodBuildFilterCriteriaCollection(Hashtable, FilterCriteriaCollection)
Returns an SQL statement built from a given set of FilterCriteria
Public methodBuildFilterCriteriaCollection(Hashtable, FilterCriteriaCollection, String)
Returns an SQL statement built from a given set of FilterCriteria
Public methodBuildOrderByStatement
Build an ORDER BY SQL statement from a list of columns and sort orders
Public methodBuildSelectStatement(IDictionary)
Build a SELECT SQL statement including aliases from a list of columns
Public methodBuildSelectStatement(String)
Build a SELECT SQL statement from a list of columns
Public methodCloseCommandConnection
Closes the DbCommand's associated db connection if local scope
Public methodCommitTransaction
Commits the global transaction assumed for every actions performed onto the database
Public methodConnectAdapter(DbDataAdapter, DbConnection)
Connect an adapter to a given database connection and return a new transaction handler if requested
Public methodConnectAdapter(DbDataAdapter, DbConnection, Boolean)
Connect an adapter to a given database connection and return a new transaction handler if requested
Public methodConnectAdapter(DbDataAdapter, DbConnection, DbTransaction)
Connect an adapter to a given database connection and return a new transaction handler if requested
Public methodCopyDataReaderCurrentRowToDataTable
Copies the current row a DataReader to the given DataTable
Public methodCreateAdapter(String)
Creates a data adapter using the specified select SQL query
Public methodCreateAdapter(String, Boolean)
Creates a data adapter using the specified select SQL query
Public methodCreateAdapter(String, Hashtable)
Creates a data adapter using the specified select SQL query
Public methodCreateAdapter(String, Hashtable, Boolean)
Creates a data adapter using the specified select SQL query
Public methodCreateAdapter(String, String, String)
Creates a data adapter using the specified actions SQL queries
Public methodCreateAdapter(String, String, String, String)
Creates a data adapter using the specified actions SQL queries
Public methodCreateAdapter(String, Hashtable, String, String, String)
Add a new adapter to the adapter collection
Public methodCreateConnection
Initializes a new connection to the database
Public methodCreateDataTableFromDataReaderSchema
Creates a DataTable from the schema of a DataReader
Public methodCreateDeleteAdapter
Creates a data adapter using the specified update SQL query
Public methodCreateInsertAdapter
Creates a data adapter using the specified insert SQL query
Public methodCreateUpdateAdapter
Creates a data adapter using the specified update SQL query
Public methodStatic memberEscapeNationalLiterals
Escape national literals into a SQL statement
Public methodExecuteNonQuery(String)
Executes an action query.
Public methodExecuteNonQuery(String, Hashtable)
Executes an action query.
Public methodExecuteNonQueryDirect
Executes an action query without preparing command for parameters.
Public methodExecuteQuery(DbDataAdapter, String)
Returns a dataset loaded with the results of the specified select SQL query
Public methodExecuteQuery(String, String)
Returns a dataset loaded with the results of the specified select SQL query
Public methodExecuteQuery(String, Hashtable, String)
Returns a dataset loaded with the results of the specified select SQL query
Public methodExecuteQuery(DbDataAdapter, String, Int32, Int32)
Returns a dataset loaded with the results of the specified select SQL query
Public methodExecuteQuery(String, String, Int32, Int32)
Returns a dataset loaded with the results of the specified select SQL query
Public methodExecuteQuery(DbDataAdapter, String, Int32, Int32, Boolean)
Returns a dataset loaded with the results of the specified select SQL query
Public methodExecuteQuery(String, Hashtable, String, Int32, Int32)
Returns a dataset loaded with the results of the specified select SQL query
Public methodExecuteQuery(String, String, Int32, Int32, Boolean)
Returns a dataset loaded with the results of the specified select SQL query
Public methodExecuteQuery(String, Hashtable, String, Int32, Int32, Boolean)
Returns a dataset loaded with the results of the specified select SQL query
Public methodExecuteQueryDirect(String, String)
Returns a dataset loaded with the results of the specified select SQL query. Doesn't look for any parameter
Public methodExecuteQueryDirect(String, String, Int32, Int32)
Returns a dataset loaded with the results of the specified select SQL query Doesn't look for any parameter
Public methodExecuteScalar(String)
Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored
Public methodExecuteScalar(String, Hashtable)
Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored
Public methodExecuteScalar(String, Object)
Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored
Public methodExecuteScalar(String, Hashtable, Object)
Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored
Public methodExecuteScalarDirect
Executes the query, and returns the first column of the first row in the result set returned by the query. Extra columns or rows are ignored
Public methodExecuteStoredProcedure(String)
Executes a stored procedure.
Public methodExecuteStoredProcedure(String, Hashtable)
Executes a stored procedure.
Public methodExecuteStoredProcedureDirect
Executes a stored procedure without preparing command for parameters.
Public methodExecuteUpdates(KeyedList, DataSet)
Updates the database with the given collection of adapters and the data table contained into the given dataset
Public methodExecuteUpdates(DbDataAdapter, DataSet, String)
Updates the database with the changes contained into a given dataset
Public methodExecuteUpdates(KeyedList, DataSet, Boolean)
Updates the database with the given collection of adapters and the data table contained into the given dataset
Public methodExecuteUpdates(DbDataAdapter, DataSet, String, Boolean)
Updates the database with the changes contained into a given dataset
Public methodFillTableFromQuery(DbDataAdapter, DataSet, String)
Load the specified table of a given dataset with the results of the specified select SQL query
Public methodFillTableFromQuery(String, DataSet, String)
Load the specified table of a given dataset with the results of the specified select SQL query
Public methodFillTableFromQuery(String, Hashtable, DataSet, String)
Load the specified table of a given dataset with the results of the specified select SQL query
Public methodFillTableFromQuery(DbDataAdapter, DataSet, String, Int32, Int32)
Load the specified table of a given dataset with the results of the specified select SQL query
Public methodFillTableFromQuery(String, DataSet, String, Int32, Int32)
Load the specified table of a given dataset with the results of the specified select SQL query
Public methodFillTableFromQuery(DbDataAdapter, DataSet, String, Int32, Int32, Boolean)
Load the specified table of a given dataset with the results of the specified select SQL query
Public methodFillTableFromQuery(String, Hashtable, DataSet, String, Int32, Int32)
Load the specified table of a given dataset with the results of the specified select SQL query
Public methodFillTableFromQuery(String, DataSet, String, Int32, Int32, Boolean)
Load the specified table of a given dataset with the results of the specified select SQL query
Public methodFillTableFromQuery(String, Hashtable, DataSet, String, Int32, Int32, Boolean)
Load the specified table of a given dataset with the results of the specified select SQL query
Public methodGetCommandWithConnection
Gets a DbCommand with a new local db connection or an existing db connection from the global transaction if active
Public methodGetDataRowFromReader
Fill a DataRow from data extracted from a given data reader
Public methodStatic memberGetDateTimeFieldValue(Object, DateTime)
Retrieve the value of a row view field value by replacing DbNull by a default value if empty
Public methodStatic memberGetDateTimeFieldValue(DataRow, String, DateTime)
Retrieve the value of a row view field value by replacing DbNull by null if empty
Public methodStatic memberGetDateTimeFieldValue(DataRowView, String, DateTime)
Retrieve the value of a row view field value by replacing DbNull by a default value if empty
Public methodStatic memberGetDoubleFieldValue(Object, Double)
Retrieve the value of a row view field value by replacing DbNull by a default value if empty
Public methodStatic memberGetDoubleFieldValue(DataRow, String, Double)
Retrieve the value of a row view field value by replacing DbNull by null if empty
Public methodStatic memberGetDoubleFieldValue(DataRowView, String, Double)
Retrieve the value of a row view field value by replacing DbNull by a default value if empty
Public methodStatic memberGetFieldValue(Object)
Retrieve the value of a row view field value by replacing DbNull by null if empty
Public methodStatic memberGetFieldValue(DataRow, String)
Retrieve the value of a row view field value by replacing DbNull by null if empty
Public methodStatic memberGetFieldValue(DataRowView, String)
Retrieve the value of a row view field value by replacing DbNull by null if empty
Public methodStatic memberGetFieldValue(Object, Object)
Retrieve the value of a row field value by replacing DbNull by null if empty
Public methodStatic memberGetFieldValue(DataRow, String, Object)
Retrieve the value of a row field value by replacing DbNull by null if empty
Public methodStatic memberGetFieldValue(DataRowView, String, Object)
Retrieve the value of a row field value by replacing DbNull by null if empty
Public methodStatic memberGetInt32FieldValue(Object, Int32)
Retrieve the value of a row view field value by replacing DbNull by a default value if empty
Public methodStatic memberGetInt32FieldValue(DataRow, String, Int32)
Retrieve the value of a row view field value by replacing DbNull by null if empty
Public methodStatic memberGetInt32FieldValue(DataRowView, String, Int32)
Retrieve the value of a row view field value by replacing DbNull by a default value if empty
Public methodStatic memberGetNullableDateTimeFieldValue(DataRow, String)
Retrieve the value of a row view field value by replacing DbNull by null if empty
Public methodStatic memberGetNullableDateTimeFieldValue(DataRowView, String)
Retrieve the value of a row view field value by replacing DbNull by null if empty
Public methodStatic memberGetNullableDoubleFieldValue(DataRow, String)
Retrieve the value of a row view field value by replacing DbNull by null if empty
Public methodStatic memberGetNullableDoubleFieldValue(DataRowView, String)
Retrieve the value of a row view field value by replacing DbNull by null if empty
Public methodStatic memberGetNullableInt32FieldValue(DataRow, String)
Retrieve the value of a row view field value by replacing DbNull by null if empty
Public methodStatic memberGetNullableInt32FieldValue(DataRowView, String)
Retrieve the value of a row view field value by replacing DbNull by null if empty
Public methodStatic memberGetStringFieldValue(Object)
Retrieve the value of a row view field value by replacing DbNull by null if empty
Public methodStatic memberGetStringFieldValue(DataRow, String)
Retrieve the value of a row view field value by replacing DbNull by null if empty
Public methodStatic memberGetStringFieldValue(DataRowView, String)
Retrieve the value of a row view field value by replacing DbNull by null if empty
Public methodStatic memberGetStringFieldValue(Object, String)
Retrieve the value of a row view field value by replacing DbNull by null if empty
Public methodStatic memberGetStringFieldValue(DataRow, String, String)
Retrieve the value of a row view field value by replacing DbNull by null if empty
Public methodStatic memberGetStringFieldValue(DataRowView, String, String)
Retrieve the value of a row view field value by replacing DbNull by default value if empty
Public methodStatic memberHasDataRowChanges(DataRow)
Determines whether or not a given row has changes between original and current row's versions
Public methodStatic memberHasDataRowChanges(DataRow, ArrayList)
Determines whether or not a given row has changes between original and current row's versions
Public methodMoveRow(Int32, RowMoveAction, String, String, String, KeyedList)
Moves a row order into a database table
Public methodMoveRow(Int32, RowMoveAction, String, String, String, KeyedList, Boolean)
Moves a row order into a database table
Public methodMoveRow(Int32, RowMoveAction, String, String, String, FilterCriteriaCollection, KeyedList)
Moves a row order into a database table
Public methodMoveRow(Int32, RowMoveAction, String, String, String, FilterCriteriaCollection, KeyedList, Boolean)
Moves a row order into a database table
Public methodPrepareCommand(String, Hashtable)
Builds an generic DbCommand according to a SQL statement and a set of parameters
Public methodPrepareCommand(DbConnection, String, Hashtable)
Builds a generic DbCommand according to a SQL statement and a set of parameters
Public methodPrepareCommand(String, Hashtable, CommandType)
Builds an generic DbCommand according to a SQL statement and a set of parameters
Public methodPrepareCommand(DbConnection, String, Hashtable, CommandType)
Builds a generic DbCommand according to a SQL statement and a set of parameters
Public methodReOrderColumn(String, String, String, DataSet)
Reorders a numeric column of a database table
Public methodReOrderColumn(String, String, String, KeyedList)
Reorders a numeric column of a database table
Public methodReOrderColumn(String, String, String, FilterCriteriaCollection, KeyedList)
Reorders a numeric column of a database table
Public methodRollbackTransaction
Rollbacks the global transaction assumed for every actions performed onto the database
Top
See Also