DataAccess Class |
Exposes a set of enumMembers which encapsulates database interactions via a provider factory
Inheritance HierarchyNamespace: WorkflowGen.My.Data
Assembly: WorkflowGen.My (in WorkflowGen.My.dll) Version: 8.1.3.0 (8.1.3.20220620)
SyntaxThe DataAccess type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
 | DataAccess |
Initializes a new instance of the AbstractObjectDao class
|
Properties| Name | Description | |
|---|---|---|
 | CommandTimeout |
Command timeout
|
| ConnectionString |
Database connection string
|
| DbmsNativeSql |
List of SQL native functions specific to the current DBMS
|
| IsActiveTransaction |
Determines whether or not the inner transaction of the instance is started and
is assumed for every actions performed onto the database
|
| ProviderDbms |
Provider DBMS
|
| ProviderFactory |
Provider factory
|
| ProviderName |
Provider name
|
Methods| Name | Description | |
|---|---|---|
| BeginTransaction |
Starts a new global transaction assumed for every actions performed onto the database
|
| BeginTransaction(IsolationLevel) |
Starts a new global transaction assumed for every actions performed onto the database
|
| BuildFilterCriteria(Hashtable, FilterCriteria) |
Returns an SQL statement built from a given FilterCriteria
|
| BuildFilterCriteria(Hashtable, FilterCriteria, String) |
Returns an SQL statement built from a given FilterCriteria
|
| BuildFilterCriteriaCollection(Hashtable, FilterCriteriaCollection) |
Returns an SQL statement built from a given set of FilterCriteria
|
| BuildFilterCriteriaCollection(Hashtable, FilterCriteriaCollection, String) |
Returns an SQL statement built from a given set of FilterCriteria
|
| BuildOrderByStatement |
Build an ORDER BY SQL statement from a list of columns and sort orders
|
| BuildSelectStatement(IDictionary) |
Build a SELECT SQL statement including aliases from a list of columns
|
| BuildSelectStatement(String) |
Build a SELECT SQL statement from a list of columns
|
| CloseCommandConnection |
Closes the DbCommand's associated db connection if local scope
|
| CommitTransaction |
Commits the global transaction assumed for every actions performed onto the database
|
| ConnectAdapter(DbDataAdapter, DbConnection) |
Connect an adapter to a given database connection and return a new transaction handler if requested
|
| ConnectAdapter(DbDataAdapter, DbConnection, Boolean) |
Connect an adapter to a given database connection and return a new transaction handler if requested
|
| ConnectAdapter(DbDataAdapter, DbConnection, DbTransaction) |
Connect an adapter to a given database connection and return a new transaction handler if requested
|
| CopyDataReaderCurrentRowToDataTable |
Copies the current row a DataReader to the given DataTable
|
| CreateAdapter(String) |
Creates a data adapter using the specified select SQL query
|
| CreateAdapter(String, Boolean) |
Creates a data adapter using the specified select SQL query
|
| CreateAdapter(String, Hashtable) |
Creates a data adapter using the specified select SQL query
|
| CreateAdapter(String, Hashtable, Boolean) |
Creates a data adapter using the specified select SQL query
|
| CreateAdapter(String, String, String) |
Creates a data adapter using the specified actions SQL queries
|
| CreateAdapter(String, String, String, String) |
Creates a data adapter using the specified actions SQL queries
|
| CreateAdapter(String, Hashtable, String, String, String) |
Add a new adapter to the adapter collection
|
| CreateConnection |
Initializes a new connection to the database
|
| CreateDataTableFromDataReaderSchema |
Creates a DataTable from the schema of a DataReader
|
| CreateDeleteAdapter |
Creates a data adapter using the specified update SQL query
|
| CreateInsertAdapter |
Creates a data adapter using the specified insert SQL query
|
| CreateUpdateAdapter |
Creates a data adapter using the specified update SQL query
|
 | EscapeNationalLiterals |
Escape national literals into a SQL statement
|
| ExecuteNonQuery(String) |
Executes an action query.
|
| ExecuteNonQuery(String, Hashtable) |
Executes an action query.
|
| ExecuteNonQueryDirect |
Executes an action query without preparing command for parameters.
|
| ExecuteQuery(DbDataAdapter, String) |
Returns a dataset loaded with the results of the specified select SQL query
|
| ExecuteQuery(String, String) |
Returns a dataset loaded with the results of the specified select SQL query
|
| ExecuteQuery(String, Hashtable, String) |
Returns a dataset loaded with the results of the specified select SQL query
|
| ExecuteQuery(DbDataAdapter, String, Int32, Int32) |
Returns a dataset loaded with the results of the specified select SQL query
|
| ExecuteQuery(String, String, Int32, Int32) |
Returns a dataset loaded with the results of the specified select SQL query
|
| ExecuteQuery(DbDataAdapter, String, Int32, Int32, Boolean) |
Returns a dataset loaded with the results of the specified select SQL query
|
| ExecuteQuery(String, Hashtable, String, Int32, Int32) |
Returns a dataset loaded with the results of the specified select SQL query
|
| ExecuteQuery(String, String, Int32, Int32, Boolean) |
Returns a dataset loaded with the results of the specified select SQL query
|
| ExecuteQuery(String, Hashtable, String, Int32, Int32, Boolean) |
Returns a dataset loaded with the results of the specified select SQL query
|
| ExecuteQueryDirect(String, String) |
Returns a dataset loaded with the results of the specified select SQL query.
Doesn't look for any parameter
|
| ExecuteQueryDirect(String, String, Int32, Int32) |
Returns a dataset loaded with the results of the specified select SQL query
Doesn't look for any parameter
|
| ExecuteScalar(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
|
| ExecuteScalar(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
|
| ExecuteScalar(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
|
| ExecuteScalar(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
|
| ExecuteScalarDirect |
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
|
| ExecuteStoredProcedure(String) |
Executes a stored procedure.
|
| ExecuteStoredProcedure(String, Hashtable) |
Executes a stored procedure.
|
| ExecuteStoredProcedureDirect |
Executes a stored procedure without preparing command for parameters.
|
| ExecuteUpdates(KeyedList, DataSet) |
Updates the database with the given collection of adapters and the data table contained into the given dataset
|
| ExecuteUpdates(DbDataAdapter, DataSet, String) |
Updates the database with the changes contained into a given dataset
|
| ExecuteUpdates(KeyedList, DataSet, Boolean) |
Updates the database with the given collection of adapters and the data table contained into the given dataset
|
| ExecuteUpdates(DbDataAdapter, DataSet, String, Boolean) |
Updates the database with the changes contained into a given dataset
|
| FillTableFromQuery(DbDataAdapter, DataSet, String) |
Load the specified table of a given dataset with the results of the specified select SQL query
|
| FillTableFromQuery(String, DataSet, String) |
Load the specified table of a given dataset with the results of the specified select SQL query
|
| FillTableFromQuery(String, Hashtable, DataSet, String) |
Load the specified table of a given dataset with the results of the specified select SQL query
|
| FillTableFromQuery(DbDataAdapter, DataSet, String, Int32, Int32) |
Load the specified table of a given dataset with the results of the specified select SQL query
|
| FillTableFromQuery(String, DataSet, String, Int32, Int32) |
Load the specified table of a given dataset with the results of the specified select SQL query
|
| FillTableFromQuery(DbDataAdapter, DataSet, String, Int32, Int32, Boolean) |
Load the specified table of a given dataset with the results of the specified select SQL query
|
| FillTableFromQuery(String, Hashtable, DataSet, String, Int32, Int32) |
Load the specified table of a given dataset with the results of the specified select SQL query
|
| FillTableFromQuery(String, DataSet, String, Int32, Int32, Boolean) |
Load the specified table of a given dataset with the results of the specified select SQL query
|
| FillTableFromQuery(String, Hashtable, DataSet, String, Int32, Int32, Boolean) |
Load the specified table of a given dataset with the results of the specified select SQL query
|
| GetCommandWithConnection |
Gets a DbCommand with a new local db connection or an existing db connection from the global transaction if active
|
| GetDataRowFromReader |
Fill a DataRow from data extracted from a given data reader
|
| GetDateTimeFieldValue(Object, DateTime) |
Retrieve the value of a row view field value by replacing DbNull by a default value if empty
|
| GetDateTimeFieldValue(DataRow, String, DateTime) |
Retrieve the value of a row view field value by replacing DbNull by null if empty
|
| GetDateTimeFieldValue(DataRowView, String, DateTime) |
Retrieve the value of a row view field value by replacing DbNull by a default value if empty
|
| GetDoubleFieldValue(Object, Double) |
Retrieve the value of a row view field value by replacing DbNull by a default value if empty
|
| GetDoubleFieldValue(DataRow, String, Double) |
Retrieve the value of a row view field value by replacing DbNull by null if empty
|
| GetDoubleFieldValue(DataRowView, String, Double) |
Retrieve the value of a row view field value by replacing DbNull by a default value if empty
|
| GetFieldValue(Object) |
Retrieve the value of a row view field value by replacing DbNull by null if empty
|
| GetFieldValue(DataRow, String) |
Retrieve the value of a row view field value by replacing DbNull by null if empty
|
| GetFieldValue(DataRowView, String) |
Retrieve the value of a row view field value by replacing DbNull by null if empty
|
| GetFieldValue(Object, Object) |
Retrieve the value of a row field value by replacing DbNull by null if empty
|
| GetFieldValue(DataRow, String, Object) |
Retrieve the value of a row field value by replacing DbNull by null if empty
|
| GetFieldValue(DataRowView, String, Object) |
Retrieve the value of a row field value by replacing DbNull by null if empty
|
| GetInt32FieldValue(Object, Int32) |
Retrieve the value of a row view field value by replacing DbNull by a default value if empty
|
| GetInt32FieldValue(DataRow, String, Int32) |
Retrieve the value of a row view field value by replacing DbNull by null if empty
|
| GetInt32FieldValue(DataRowView, String, Int32) |
Retrieve the value of a row view field value by replacing DbNull by a default value if empty
|
| GetNullableDateTimeFieldValue(DataRow, String) |
Retrieve the value of a row view field value by replacing DbNull by null if empty
|
| GetNullableDateTimeFieldValue(DataRowView, String) |
Retrieve the value of a row view field value by replacing DbNull by null if empty
|
| GetNullableDoubleFieldValue(DataRow, String) |
Retrieve the value of a row view field value by replacing DbNull by null if empty
|
| GetNullableDoubleFieldValue(DataRowView, String) |
Retrieve the value of a row view field value by replacing DbNull by null if empty
|
| GetNullableInt32FieldValue(DataRow, String) |
Retrieve the value of a row view field value by replacing DbNull by null if empty
|
| GetNullableInt32FieldValue(DataRowView, String) |
Retrieve the value of a row view field value by replacing DbNull by null if empty
|
| GetStringFieldValue(Object) |
Retrieve the value of a row view field value by replacing DbNull by null if empty
|
| GetStringFieldValue(DataRow, String) |
Retrieve the value of a row view field value by replacing DbNull by null if empty
|
| GetStringFieldValue(DataRowView, String) |
Retrieve the value of a row view field value by replacing DbNull by null if empty
|
| GetStringFieldValue(Object, String) |
Retrieve the value of a row view field value by replacing DbNull by null if empty
|
| GetStringFieldValue(DataRow, String, String) |
Retrieve the value of a row view field value by replacing DbNull by null if empty
|
| GetStringFieldValue(DataRowView, String, String) |
Retrieve the value of a row view field value by replacing DbNull by default value if empty
|
| HasDataRowChanges(DataRow) |
Determines whether or not a given row has changes between original and current row's versions
|
| HasDataRowChanges(DataRow, ArrayList) |
Determines whether or not a given row has changes between original and current row's versions
|
| MoveRow(Int32, RowMoveAction, String, String, String, KeyedList) |
Moves a row order into a database table
|
| MoveRow(Int32, RowMoveAction, String, String, String, KeyedList, Boolean) |
Moves a row order into a database table
|
| MoveRow(Int32, RowMoveAction, String, String, String, FilterCriteriaCollection, KeyedList) |
Moves a row order into a database table
|
| MoveRow(Int32, RowMoveAction, String, String, String, FilterCriteriaCollection, KeyedList, Boolean) |
Moves a row order into a database table
|
| PrepareCommand(String, Hashtable) |
Builds an generic DbCommand according to a SQL statement and a set of parameters
|
| PrepareCommand(DbConnection, String, Hashtable) |
Builds a generic DbCommand according to a SQL statement and a set of parameters
|
| PrepareCommand(String, Hashtable, CommandType) |
Builds an generic DbCommand according to a SQL statement and a set of parameters
|
| PrepareCommand(DbConnection, String, Hashtable, CommandType) |
Builds a generic DbCommand according to a SQL statement and a set of parameters
|
| ReOrderColumn(String, String, String, DataSet) |
Reorders a numeric column of a database table
|
| ReOrderColumn(String, String, String, KeyedList) |
Reorders a numeric column of a database table
|
| ReOrderColumn(String, String, String, FilterCriteriaCollection, KeyedList) |
Reorders a numeric column of a database table
|
| RollbackTransaction |
Rollbacks the global transaction assumed for every actions performed onto the database
|
See Also