Database SQL Oracle MySql
New Topic
Loading...
  • Blog Post
  • News By Category
Thursday, April 10, 2014
Benefits of ADO.NET

Benefits of ADO.NET

Benefits of 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)



Read More
Data Access Application Block (DAAB)

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
Read More
Sunday, March 23, 2014
no image

ADO.NET Components

Database Classes
Access and update databases
Uses “Managed Provider” to connect to DB
Data Classes
Hold data in-memory, disconnected from database
User defined structure. Does not have to map to DB.
DataSet” is the key class

Database Classes
Execute database commands and make results available.
Connection: a database connection
Command: what to execute, generally SQL
DataReader: Read-only, forward-only cursor.
DataAdapter: Connects a DataSet to the database and can resolve changes back to DB
CommandAdaptor: Automatically generates Insert/Update/Delete commands from a Select command (expensive!)
Connections are always made thru “Managed Providers”
Essentially the next version of OLEDB
Native, .net managed data-access components
Remember: Managed means .net handles memory management, security etc.
Only two Managed Providers at time of writing:
Microsoft SQL Server, included with .net
Microsoft OLEDB, included with .net
Enables developers to work with existing OLEDB drivers until managed versions available.

Data classes: DataSet
Hold a disconnected, in-memory version of the data
Designed to hold >=1 table of data at a time
improvement over ADO where a RecordSet could only hold a single table.
Can model relationships between those tables and enforce them on the client
Save as XML with schema
Can design visually in Visual Studio or use DataSet class directly – see next slide for details
May or may not be direct representation of database
Note: By default, DataAdapter can only automatically insert/update/delete direct representations of database
Read More
Benefits of ADO.NET

Benefits of 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)


Read More
What is ADO.NET

What is ADO.NET

Acronym for ActiveX Data Objects
ADO.NET is the successor to Microsoft’s ADO technology
Both provided consistent, high-performance access to data
ADO.NET more focused on needs of today’s eCommerce environment

A data access framework and API
Read More

Featured Slider

Technical Blog post

Copyright © 2014 ASP.NET & C# & IIS & Crystal Report & Database & ADO.NET All Right Reserved
Designed by ASP.NET Tuts