Applied ADO. NET(c) Building Data-Driven Solutions
Authors: Chand M.,  Talbot D.
 Published year: 2006
 Pages: 5-8/214
Buy this book on amazon.com >>

Introduction

This book is for experienced developers who want to write desktop or Web-based database applications in .NET. This book assumes you have some prior programming knowledge of an object-oriented programming language such as C++, Java, or Visual Basic; some basic concepts of database programming; and some experience with previous versions of Visual Studio (VS). This book also assumes you know the basic concepts of .NET and how to install it.

The following sections briefly introduce this book's chapters.

Chapter 1: "ADO.NET Basics"

This chapter provides you with a high-level overview of ADO.NET. This chapter covers the basics of ADO.NET, describes its advantages over current data access technologies, and briefly introduces ADO.NET classes and namespaces. It also shows you how to use ADO.NET classes and namespaces to write simple database applications using VS .NET (VS .NET). Finally, Microsoft VS .NET provides tremendous support for writing database applications in no time using its wizards and utilities. This chapter also briefly introduces ADO.NET components and how they fit in the model and work together.



Chapter 2: "Data Components in Visual Studio .NET"

The Visual Studio .NET (VS .NET) Integrated Development Environment (IDE) provides design-time support to work with data components. In this chapter, you'll learn how to use these data components in the VS .NET IDE at design-time to create database applications. This chapter starts with the Server Explorer, a useful tool for database applications. You'll focus on developing database applications quickly using data components in VS .NET without writing a lot of code. You'll work through a step-by-step tutorial to help you develop and run a project. The chapter also discusses the Connection , DataAdapter , Command , DataSet , and DataView components in more detail. After finishing this chapter, you'll have a good understanding of data components and how to work with them in VS .NET.



Chapter 3: "ADO.NET in Disconnected Environments"

In this chapter, you'll get a broad view of the ADO.NET architecture and the basic building blocks of ADO.NET in a disconnected environment. This chapter plays a major role for later chapters as well. Actually, ADO.NET not only provides a way to work with databases, it also allows you to access various kinds of data sources and even in-memory representations of data. You'll learn how to write database applications without using a database. You'll also explore the System.Data and System.Data.Common namespace classes. Some of the common data objects covered in this chapter are DataTable , DataColumn , DataRow , and DataSet .



Chapter 4: "ADO.NET in Connected Environments"

This chapter examines ADO.NET functionality in a connected environment, which means you won't be storing data in memory. You'll be reading and storing data in data sources. You access data from a data source and save data back to the data source with the help of a bridge between the application and the data source; in ADO.NET this bridge is a data provider. ADO.NET provides many data providers for working with different data sources to make data access fast, reliable, and easy to use. Each data provider has data components (classes) that let you connect to a data source and read, write, add, delete, and update data. This chapter examines these components and shows how to use Windows data-bound controls to bind data with ADO.NET components .


Applied ADO. NET(c) Building Data-Driven Solutions
Authors: Chand M.,  Talbot D.
 Published year: 2006
 Pages: 5-8/214
Buy this book on amazon.com >>

Similar books