Microsoft® Visual C#® .NET 2003 Kick Start

In Brief

This chapter gave us our start in database handling. Here's an overview of this chapter's topics:

• ADO.NET is the main data access protocol in C#. ADO.NET centers on three primary objects—connection objects, which let you connect to data sources; data adapter objects, which store SQL statements and are responsible for fetching and storing data; and dataset objects, which hold a copy of your data locally. ADO.NET uses a disconnected data architecture, where no connection to the data source is maintained. Connections are made when you need to get more data or update the data in the data source.

• The IDE comes with several visual tools that let you work with databases. For example, the Server Explorer lets you examine not only which database ...