Chapter 17

The methods that you code for a data access class...

...can be either static or instance methods

The shortcoming that you encounter when you use data sources with databases is that you...

...can't separate the presentation code from the data access code

When you use a business class with an object data source, the business class...

...must have public properties that match the names of the bound fields

To create an object data source that provides for sorting, you must always...

...set a property that identifies the parameter in the select method in the data access class that will be used to sort the data

In a 3-layer application, the three layers are...

...the presentation layer, the middle layer, and the database layer

Which of the following methods do you use to execute a SqlCommand object that contains a Select statement?

ExecuteReader

To create an object data source that provides for paging, you must do all but one of the following. Which one is it?

Provide methods in the data access class that navigate to the first, previous, next, and last pages of the selected rows

Which of the following methods do you use to read the next row from a SqlDataReader object?

Read

When you create a SqlCommand object, you can specify the SQL statement it will execute, along with the _______ for the database.

SqlConnection object?

What information must you provide for an ObjectDataSource control at design time if that data source is used to select, insert, update, and delete data?

The names of the select, insert, update, and delete methods

Which of the following statements about the attributes you use within a data access class is true?

They're used at design time.

The definition for an ObjectDataSource control requires all but one of the following properties. Which one is it?

UpdateMethod

If a method of a data access class uses the properties of a business object for bound fields, the ObjectDataSource control generates the collection of parameters that are passed to the method based on all but one of the following factors. Which one is it?

Whether the method is marked as a data object method

Which of the following statements is not true about the use of object data sources?

You don't get the benefit of data binding.

Which of the following can not be used as the return type of a select method?

array

You can use C# _______ to identify data access classes and methods.

attributes

To use paging with an object data source, you need to provide a method in the data access class that returns a _______ of the rows that are retrieved by the related select method.

count

When you develop an application using a 3-layer architecture, the layer that stores the data access classes is called the _______ layer.

middle

When you develop an application using a 3-layer architecture, the layer that provides the user interface is called the _______ layer.

presentation

The .NET feature that's used to determine if a data access class contains the parameters expected by an object data source is called _______.

reflection