: This article mainly discusses ADO.NET as one of the implementation of basic database operation methods, as well as the basic comparison of ADO.NET and ADO
ADO.NET will become the basis for building a data perception. Net application. Different from ADO, ADO.NET is more versatile, not that design for databases. ADO.NET aggregate all data processing Class. These classes present Data Container Objects with typical database functions, such as index, sort, browsing. Although ADO.NET is an important .NET database application solution, it is more showing comprehensive design Not only is the same as the ADO model as a database center. .
ADO .NET is very different from ADO. It is a new access programming model. When you start using ADO.NET, you will find anything you master on the ADO skills in building effective procedures and solve problems. There is a great help to you, you can help you develop more flexible and more securely in the problem.
ADO.NET is not ADO to improve the .NET basic constructs. When you slowly understand the syntax of ADO.NET, you will be clear after the code design, and transplantation.
Data Access in NET
Accessing the data source in ADO.NET is controlled by the hosting provider. Although the host DB has two major differences from OLE DB, both are extremely similar. First, the hosted provider runs in the .NET environment, Search and display data through the DataReader and the DataTable .Net class. Second, their architecture is relatively simple because it is optimized for adaptation .NET.
At this point, ADO.NET is divided into two different types of managed providers: a kind of SQL Server® 7.0 or higher, another suitable for all OLE DB providers you may have already installed. Although use in two The category in the hosted provider is different, but they follow similar naming methods. Other names are the same outside the prefix. The previous case is SQL, the latter is ADO.
You need to use the SQL class to access the SQL Server table, because the SQL class skips the intermediate layer presented by the OLE DB provider, and directly enter the internal API of the database server. ADO class is a .NET interface located at the top of the OLE DB provider. The COM Intero Bridge is working.
About Ado.Net Getting Started Know, you can read the article of Omri Gazitt's, and the article mainly introduces ADO :
About Microsoft's Database Access Services (Data Access Services), and the discussion of ADO in my article mainly points out the evolution of data species. The former is more purely technically, and provides a higher level about ADO.NET Overview of the programming model. The latter is mainly to explain ADO.NETR's goals and links with XML, scripts, and other technologies.
