❞ كتاب Mastering™ Visual Basic® .NET Database Programming ❝

Programming of databases using Visual Basic .NET

6
A First Look at ADO.NET
How does ADO.NET work?
Database Programming
The Connection object
The Command object
The DataAdapter object
The DataReader object
The DataSet object
Navigating through DataSets
Updating Your Database by using DataSets
Managing concurrency
It’s time now to get into some real database programming with the .NET Framework components.
In this chapter, you’ll explore the Active Data Objects (ADO).NET base classes. ADO.NET,
along with the XML namespace, is a core part of Microsoft’s standard for data access and storage.
As you recall from Chapter 1, “Database Access: Architectures and Technologies,” ADO.NET components
can access a variety of data sources, including Access and SQL Server databases, as well as
non-Microsoft databases such as Oracle. Although ADO.NET is a lot different from classic ADO,
you should be able to readily transfer your knowledge to the new .NET platform. Throughout this
chapter, we make comparisons to ADO 2.x objects to help you make the distinction between the
two technologies.
For those of you who have programmed with ADO 2.x, the ADO.NET interfaces will not
seem all that unfamiliar. Granted, a few mechanisms, such as navigation and storage, have changed,
but you will quickly learn how to take advantage of these new elements. ADO.NET opens up a
whole new world of data access, giving you the power to control the changes you make to your
data. Although native OLE DB/ADO provides a common interface for universal storage, a lot of



:
What are .NET data providers?
What are the ADO.NET classes?
What are the appropriate conditions for using a DataReader versus a DataSet?
How does OLE DB fit into the picture?
What are the advantages of using ADO.NET over classic ADO?
How do you retrieve and update databases from ADO.NET?
How does XML integration go beyond the simple representation of data as XML?
Let’s begin by looking “under the hood” and examining the components of the ADO.NET stack.


-
من كتب فجوال بيسك دوت نت كتب لغات البرمجة - مكتبة كتب تقنية المعلومات.