Implementing data access functionality is a core activity of most developers working with the .NET Framework. In a tied architecture the data access layers are an essential part of applications. This block (the CA.Blocks.DataAccess assembly) creates an abstract data access layer which can use used as a base for accessing those databases in a convenient and standardized way. The block is made up of a Core DataAccess Class and then specializations for specific providers such as SQL server and generic OLEDB implementation. It is designed to be the base class through which a standardized DataAccess Layer can be built.
Classes
| Class | Description | |
|---|---|---|
| DataAccessCore | This class provides the abstract implementation for the Code Associate Data Access Block. The Abstract implementation is build upon utilizing common System.Data methods and interfacing out the Specific DBCommand using the IDbCommand interface. In doing this all specializations built on top of this class will behave in the same manor. This class is abstract and cannot be created. | |
| DataHelper |
This class is a helper class for dealing data values. It is intended to be a static helper class only.
| |
| OledbDataAccess |
Provides a Oledb implementation for DataAccessCore. This block can be used to connect to any Oledb exposed database.
| |
| SqlServerDataAccess |
Provides a SQL server implementation for DataAccessCore
|