Data Set Designer Drag-and-Drop Test

The Data Set Designer Drag-and-Drop test validates that third-party data source objects are successfully dropped onto the DataSet Designer from the Visual Studio Server Explorer.

Test Procedure

  1. In Visual Studio, create a new Windows Application project.

  2. Add a DataSet project item.

  3. Show the Server Explorer.

  4. Add a connection to the database using the generic provider, using required steps for adding a database connection.

  5. Drag tables and columns to the DataSet Designer and verify that TableAdapters are successfully created and properties are correctly set.

  6. Drag related tables to the DataSet Designer and verify that relationships are successfully created for tables in the database.

  7. Drag views and columns to the DataSet Designer and verify that TableAdapters are successfully created and that properties are correctly set.

  8. Drag stored procedures, which return rowsets onto the DataSet Designer, and verify that TableAdapters are created and that properties are correctly set.

  9. Drag stored procedures, which return scalar values or null values onto the DataSet Designer; verify that Queries are created and that properties are correctly set.

  10. Drag functions that return rowsets to the DataSet Designer and verify that TableAdapters are created and that properties are correctly set.

  11. Drag functions that return scalar or no values to the DataSet Designer and verify that Queries are created and that properties are correctly set.

See Also

Concepts

Validating End User Applications of DDEX