Flylib.com

Books Software

 
 
 

BackCover

 

Back Cover

ADO .NET Programming provides a sophisticated reference to ADO .NET solution development. Aimed at database programmers with a working knowledge of the .NET Framework, this book dissects the ADO .NET component model and provides real-world examples demonstrating how ADO .NET can be used to manipulate data from different sources.

  • Discover the differences between ADO and ADO .NET.
  • Learn how to interact with databases using the Connection, Command, DataReader, and DataAdapter components and how to manipulate data with the DataSet component.
  • Understand how XML is integrated with ADO .NET and learn the best ways to use that technology in your programs.
  • Learn the subtle aspects of migrating ADO applications to ADO .NET.
  • Develop and manipulate a data warehouse with ADO .NET and develop your own .NET data provider.

The appendixes include references to the new object-oriented pradigm of VB .NET, database normalization, views, stored procedure and trigger programming, and techniques for adding SQL functionality.

About the Authors

Terrence J. Joubert is a software engineer for VCS, the leading IT solutions provider in Seychelles. He specializes in Microsoft development tools such as Visual Basic and Visual C++. He is currently developing with the Microsoft Visual Studio .NET product family and .NET Server and has extensive experience with PowerBuilder. Joubert is also an associate author and technical reviewer for several technology publishers.

Ryan N. Payet is the software team leader and system administrator for VCS. He has extensive experience with Microsoft SQL database technologies, .NET languages (VB .NET , C#, and C++), and various Microsoft Server technologies (Windows 2000, Exchange Server, Internet Information Server, and Internet Security and Access Server). Payet is an expert with PowerBuilder and specializes in the development of software for the hospitality industry. He is also a technical reviewer for technology publishers.

Part I: Introduction to ADO .NET

Chapter 1: Growing up from ADO

Chapter 1: Growing up from ADO

Chapter 1: Growing up from ADO

In This Chapter

ADO .NET presents a robust and revolutionary data access architecture at the core of the Microsoft .NET strategy. Being an integral member of the core class libraries of the .NET Framework, ADO .NET is nothing like its predecessor. While it does provide some traditional interfaces for backward compatibility and ADO migration, the rich set of tools available in the System.Data namespace that holds ADO .NET goes far beyond the most wonderful magic one can perform with ADO.

This chapter is about the differences between a father and a son. It is important for you, the ADO programmer, to understand the differences at the core conceptual level before you attempt to dive into anything that involves ADO .NET.

Part II: ADO .NET Revealed

Chapter 2: Interacting with Databases
Chapter 3: Data Manipulation
Chapter 4: Designing ADO.NET Applications
Chapter 5: XML Intergration with ADO.NET
Chapter 6: Practical ADO.NET Programming (Part One)
Chapter 7: Practical ADO.NET Programming (Part Two)

Chapter 2: Interacting with Databases

Chapter 2: Interacting with Databases

In This Chapter

Throughout Chapter 1, you learned about the existence of the components available as two distinct groups in ADO .NET. There is the group of components that allows connection to and interaction with data sources and another group that provides client manipulation of data.

This chapter is about the first aforementioned group of components that provides an interface to the data source. A complete reference is provided on the following components:

  • Connection

  • Command

  • DataReader

  • DataAdapter

As covered in Chapter 1, all .NET data providers must implement interfaces to all these components. Figure 2-1 shows the relationship of these components inside a .NET data provider. In this chapter, we will cover each of these components as they are implemented in the two original data providers shipped with the .NET Framework (SQL Server .NET Data Provider and OLE DB .NET Data Provider).

click to expand
Figure 2-1: A view inside a .NET data provider

This chapter is very conceptual and organized as a reference volume to the above objects. After learning about the concepts in this chapter, you will be provided with an overview of how everything fits together in a practical programming environment in Chapter 5.