كتاب 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.
-
من كتب فجوال بيسك دوت نت كتب لغات البرمجة - مكتبة كتب تقنية المعلومات.