70-316 Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET Study Guide

Microsoft ™

70-316 Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET

Note 1: 70-316 Exhibit and all related diagrams are not shown in demo questions.
Note 2: 70-316 Answers are not shown in demo questions.
Exhibits and Answers are only provided in the Full Version.

Demo Question 12.

You are working on a Web Application at Silva Inc. You discover that the stored procedure's parameters have been changed. The database administrator is on medical leave. Which of the following methods should you use to determine which stored procedures have parameters that no longer match the parameters that you have already established in your code? (Select the best choice.)

A. SqlDataReader.GetName
B. DataAdapter.FillSchema
C. SqlCommandBuilder.RefreshSchema
D. SqlCommandBuilder.DeriveParameters

Display Answer

Purchase Full Version:

70-316 Printable PDF Prep Guide $49.95 BUY NOW!

70-316 Test Simulation Engine $69.95 BUY NOW!

70-316 PDF & Test Simulation Engine $99.95 BUY NOW!

Answer: D The DeriveParameters method of the SqlCommandBuilder class allows you to retrieve the parameters of stored procedures. You could compare the parameters that are returned by DeriveParameters against the parameters in existing code to see if they match. The GetName method of the SqlDataReader class returns the name of a column at a specified index. The RefreshSchema method is used when the underlying query of a SqlCommandBuilder object changes in order to update the database schema information.

Explanation: