Data

From BLToolkit.NET

Business Logic Toolkit for .NET www.bltoolkit.net
 

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.NET
How to configure
• Method 1   using app.config.
• Method 2   programmatically.
• Method 3   by passing DataProvider, Connection or Transaction object.
• Data Providers
• SetCommand   Using SQL statements
• SetSpCommand   Using stored procedures
• Parameters
• Prepare
• Transactions
• Close
• ExecuteDataSet
• ExecuteDataTable
• ExecuteDictionary
• ExecuteForEach
• ExecuteList
• ExecuteNonQuery
• ExecuteObject
• ExecuteReader
• ExecuteResultSet   Complex mapping
• ExecuteScalar
• ExecuteScalarDictionary
• ExecuteScalarList
 
© 2010 www.bltoolkit.net
support@bltoolkit.net