Mastering Visual Basic .NET Database Programming

Posted by Unknown 0 komentar
Mastering Visual Basic .NET Database Programming | 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 the data activity is hidden from you. With client-side disconnected RecordSets, you can’t control how your updates occur. They just happen “magically.” ADO.NET opens that black box, giving you more granularity with your data manipulations. ADO 2.x is about common data access. ADO.NET extends this model and factors out data storage from common data access. Factoring out functionality makes it easier for you to understand how ADO.NET components work. Each ADO.NET component has its own specialty, unlike the RecordSet, which is a jack-of-all-trades. The RecordSet could be disconnected or stateful; it could be read-only or updateable; it could be stored on the client or on the server—it is multifaceted. Not only do all these mechanisms bloat the RecordSet with functionality you might never use, it also forces you to write code to anticipate every possible chameleon-like metamorphosis of the RecordSet. In ADO.NET, you always know what to expect from your data access objects, and this lets you streamline your code with specific functionality and greater control. Download free IMastering Visual Basic .NET Database Programming.pdf here

0 komentar:

Post a Comment