How to: Add a Database Data Source to a Web Test
Before you can add data binding to a Web request, you must add a data source to the Web test. After you add a data source to a Web test, you can bind a Web request to the data. For more information, see How to: Add Data Binding to a Web Request. After you add data binding to a Web request, you must configure the test run to access one or more rows of data. For more information, see How to: Configure Data Binding in a Web Test.
To add the data source to the Web test
In the Web Test Editor, right-click the top node of the Web test and then click Add Data Source.
The New Test Data Source Wizard appears.
In the Data source name box type a name for your data source.
In the Data source type list click Database.
Select an existing connection, or follow these steps:
Click New Connection.
The Choose Data Source dialog box appears.
In the Data source list, click the appropriate source for your database.
(Optional) In the Data provider list, click the appropriate provider for your database.
(Optional) Clear the Always use this selection check box.
The Connection Properties dialog box appears.
Enter the information to connect to your database.
(Optional) Click the Test Connection button to verify your connection to the database.
Click OK to close the Connection Properties dialog box.
The connection string to access the database is entered in the wizard.
Under Choose from the available tables for this data source, select the check box next to each table that you want to include in the data source.
If your database is a file, for example a Microsoft Access database, a dialog box appears that asks you if you want to add the file to your current project. You can use the following information to help you decide:
The file is copied to the project.
When the project is deployed, there is no extra work that is required.
The file is not copied to the project. When the project is deployed, you might have to update the path of the file.
Some data files can be very large, and should be maintained separate from the project. Some data files must be shared among several members of a team, and should be maintained in a central location that all members can access.
Click Yes or No.
A Data Sources node is added to the Web test, and the database and tables appear in the hierarchy.
On the File menu click Save to save the Web test.