Difference between revisions 70427111 and 71648507 on enwiki

* '''DAAB''' stands for Data Access Application Block, a proprietary Microsoft technology that is part of the [[Microsoft .NET]] framework.  It is a software component for accessing stored procedures and issuing textual SQL queries -- for [[MS SQL Server]] databases.  DAAB supports the languages C# and Visual Basic .NET.   It is quite akin to [[JDBC]] (Java Database Connectivity) as in both cases you pass in text strings of SQL commands to access a database.  While JDBC is aimed at portability, DAAB is specific to MS SQL Server. 

DAAB can also be viewed as a basic [[Object Relational Mapping]] tool, that simplifies simple developments.  Where DAAB is perhaps not the best choice is where more sophisticated relationships are involved such as "Order" linking to many "Order Lines".  Whereas frameworks such as [[Java EE]] separate business logic from presentation, in [[Microsoft .NET|.NET]] (and hence in DAAB) the two are much more tightly coupled.  

As the stored procedure languages of Oracle and MS SQL Server are different, so DAAB 1.0 and 2.0 code was limited to SQL Server.  DAAB 3.0 is anticipated to support both.Microsoft technology that is reusable and extensible source code-based guidance that simplifies development of common data access functionality in [[Microsoft .NET]] applications.  Applications can use the application block in a variety of situations, such as reading data for display, obtaining data to pass through application layers, and submitting changed data back to the database system.  The application block includes support for both stored procedures and in-line SQL, and common housekeeping tasks such as managing connections and creating and caching parameters are encapsulated in the application block's methods.  DAAB supports the languages C# and Visual Basic .NET.   

Previous versions of the DAAB were stand-alone application blocks; the new DAAB is a part of the new Enterprise Library collection of application blocks

The current release of Enterprise Library for .NET Framework 2.0 is a relatively minor update to the existing Enterprise Library DAAB. It will support the same key scenarios, but it’s been redesigned to leverage some new features in .NET Framework 2.0, and to sport a simpler architecture

The Data Access Application Block has the following features:

    * It reduces the need to write boilerplate code to perform standard tasks.
    * It helps maintain consistent data access practices, both in an application and across the enterprise.
    * It reduces difficulties in changing the physical database target.
    * It relieves developers from learning different programming models for different types of databases.
    * It reduces the amount of code that needs to be rewritten when porting applications to different types of databases.

''Common Scenarios''

Developers often write applications that use databases. Because it is so common, developers may find themselves writing the same code over and over, for each application. In addition, these applications may need to work with different types of databases. Although the tasks are the same, the code must be adapted to suit the programming model of each database. The Data Access Application Block solves these problems by providing an implementation of the most common data access tasks. Developers only need to do the following:

   1. Create the database object.
   2. Supply the parameters for the command, if they are needed.
   3. Call the appropriate method.

The '''DAAB''' is optimized for performance, designed for portability and it works transparently with SQL Server, DB2, and Oracle databases.⏎


*'''DAAB''' is also the name of a most popular polish Reggae-Band/formed in 1983/         http://daabwww.w.interia.pl

{{4CC}}