ASP.NET & C# & IIS & Crystal Report & Database & ADO.NET

•Increased Interoperability

–Can save and load from XML

–XML is the way to exchange data between business

•any programming language use it.

•Increased Scalability

–Targets distributed, disconnected web scenarios

–Built in support for disconnected record sets

•Enables integration of data from multiple heterogeneous data sources

Automatic Connection Pooling (COM+ based)

Data Access Application Block (DAAB)

With this application block, developers can incorporate standard database functionality such

as (Connection, Command, Transaction etc.) in their applications.

ADO.NET provides many rich features that can be used to retrieve and display data in a number of ways.

But with this process we find ourselves repeating the same code again & again.

For this reason Microsoft introduced DAAB which can be used to perform common task in with less code.

Another point if different companies are using the DAAB then you will find the code more easier to understand.

Previous version of DAAB works by sqlclient provider.

DAAB 2.0 works with abstract provider DatabaseFactory, Database class.

DAAB 2.0 use the ADO.NET 2.0 classes

DbCommand

DbConnection

The abstract Database class provides a number of methods at your disposal that are your normal ADO.NET 2.0 commands

ExecuteDataSet

ExecuteNonQuery

ExecuteReader

ExecuteScalar

LoadDataSet

UpadateDataSet

AddInParameter

AddOutParameter

GetSqlStringCommand

GetStoreProcCommand