Programming Microsoft® ADO.NET 2.0 Core Reference, 2nd Edition

Chapter 4. Querying Your Database

In this chapter:

Using SqlCommand Objects in Code

Working with the SqlDataReader

Working with Parameterized Queries

Microsoft Visual Studio Design-Time Features

Object Reference for SqlCommand, SqlDataReader, and SqlParameter

Questions That Should Be Asked More Frequently

In Chapter 3, you learned how to connect to a database using the Microsoft ADO.NET SqlConnection class. Now it’s time to learn how to execute queries against your database. In the ADO.NET object model, you execute queries using the SqlCommand class.

In this chapter, I’ll focus first on specific tasks that involve the SqlCommand class. I’ll examine how to execute queries that retrieve results and queries that modify, rather than return, data. We’ll take ...