Ado. NET Introduction

Ado. NET is the latest technology since the development of database access technology, which was marked by the use of Open DB Connectivity (ODBC) application technology a few years ago. So, something interesting happened. COM technology began to involve the database realm, and it reached a peak with OLE DB. Later, ActiveX data Objects (ADO), a rough, OLE DB version of the object, was chosen to use the object in conjunction with Visual Basic and ASP, a windows-based database developer.
Now that you have. NET, Microsoft offers a universal framework-framework class library, the class library will span all existing Windows API functions, and, in particular, it will contain some frequently used libraries, and users will find that the XML and ADO object models are integrated into a tree-like collection of classes, This collection is called Ado.net.
Not like ADO, ADN. NET has been designed to follow general database access guidelines that do not have database-oriented flaws, ADO. NET collects all the data access-related classes, which are composed of data container objects that have general data processing capabilities---indexing,sorting,viewing,ado. NET is a development approach that is defined for. NET database applications, and Ado.net is a complete design environment for the database, not just around data access and processing, as ADO does.
Ado. NET and ADO are very different, it is a new data access program model, need a thorough understanding. However, once the user has used ado.net, all ADO techniques will be found to be helpful to the user programming in the ado.net environment.
A ado.net application needs to first establish a Connection object to read data from the data source. It can be SqlConnection or adoconnection, depending on the provider (Provider) environment, but the user needs to remember that it is best to use SQL Serverole DB providers to access the SQL Server database. Users can also use ado.net classes to connect to a SQL Server database, the only drawback is that the user's code must be passed from a layer of unnecessary code, it will invoke the ADO provider, and then call the SQL Serverole DB provider. However, if a user uses a SQL Server provider directly, it is only necessary to access the database directly. There is also a Ado.net Connection object and ADO the difference is that the Ado.net connection object does not provide a "cursorlocation" attribute. In ADO, you can create a Recordset object by specifying a connection and a database command.