The
DbManager class is a high-level, data provider independent wrapper for
ADO.NET. It has been designed to simplify working with database and encapsulates most of
ADO.NET objects such as
Connection,
Transaction,
Command, and
Parameter in one single object.
Compare DbManager with ADO.NETHow to configure
•
Method 1
•
Method 2
•
Method 3
by passing DataProvider, Connection or Transaction object.
•
Data Providers•
SetCommand Using SQL statements.
•
SetSpCommand Using stored procedures.
•
Parameters
•
Prepare
•
Transaction
•
Close
•
ExecuteDataSet
•
ExecuteDataTable
•
ExecuteDictionary
•
ExecuteForEach
•
ExecuteList
•
ExecuteNonQuery
•
ExecuteObject
•
ExecuteReader
•
ExecuteResultSet Complex mapping
•
ExecuteScalar
•
ExecuteScalarDictionary
•
ExecuteScalarList