Chapter 18. Using ADO.NET
After completing this chapter, you will be able to:
Connect to a database.
Execute SQL statements to query the database.
Execute SQL statements to update the database.
Create disconnected applications, which use a DataSet to cache tables in memory.
Create a report displaying data from the database.
ADO.NET is the data access API from Microsoft for the .NET Framework. ADO.NET has been optimized to work with .NET, making it possible for distributed applications and services to exchange data easily and reliably.
ADO.NET offers two distinct programming models, depending on the type of application you need to build:
If you require forward-only, read-only access to the data, you can use a DataReader to iterate over the results of a ...