1. If your test project already has an app.config file, go to Define a Custom Configuration Section.

2. Right-click your test project in Solution Explorer, point to Add, and then click New Item.

   The Add New Item window opens.

3. Select the Application Configuration File template and click Add.

1. The root element of app.config should be the configuration element. Create a configSections element within the configuration element. The configSections should be the first element in the app.config file.

2. Within the configSections element, create a section element.

3. In the section element, add an attribute called name and assign it a value equal microsoft.visualstudio.testtools. Add another attribute called type and assign it a value equal Microsoft.VisualStudio.TestTools.UnitTesting.TestConfigurationSection, Microsoft.VisualStudio.QualityTools.UnitTestFramework, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a

1. After the configSections element, create a connectionStrings element.

2. Within the connectionStrings element, create two add elements.

3. In the first add element, create the following attributes and values for a connection to a Microsoft Access database:

In the second add element, create the following attributes and values for a connection to a Microsoft Excel spreadsheet:

1. After the connectionStrings element, create a microsoft.visualstudio.testtools element. This section was created in Define a Custom Configuration Section.

2. Within the microsoft.visualstudio.testtools element, create a dataSources element.

3. Within the dataSources element, create two add elements.

4. In the first add element, create the following attributes and values for a Microsoft Access data source:

In the second add element, create the following attributes and values for a Microsoft Excel data source:

1. Create a Microsoft Access database named testdatasource.accdb.

2. Create a table and name it MyDataTable in testdatasource.accdb.

3. Create two fields in MyDataTable named Arg1 and Arg2 using the Number data type.

4. Add five entities to MyDataTable with the following values for Arg1 and Arg2, respectively: (10,50), (3,2), (6,0), (0,8) and (12312,1000).

5. Save and close the database.

6. In the app.config file, change the connection string to point to the location of the database. Change the value of Data Source to reflect the location of the database.

1. Create a Microsoft Excel spreadsheet named data.xlsx.

2. Create a sheet named Sheet1 if it does not already exist in data.xlsx.

3. Create two column headers and name them Val1 and Val2 in Sheet1.

4. Add five entities to Sheet1 with the following values for Val1 and Val2, respectively: (1,1), (2,2), (3,3), (4,4) and (5,0).

5. Save and close the spreadsheet.

6. In the app.config file, change the connection string to point to the location of the spreadsheet. Change the value of dbq to reflect the location of the spreadsheet.

1. Add a unit test to the test project.

   For more information, see How to: Author a Unit Test.

2. Replace the auto-generated contents of the unit test with the following code:

   using System;
   using Microsoft.VisualStudio.TestTools.UnitTesting;
   
   namespace TestProject1
   {
        [TestClass]
       public class UnitTest1
       {
           private TestContext context;
   
           public TestContext TestContext
           {
               get { return context; }
               set { context = value; }
           }
   
           [TestMethod()]
           [DeploymentItem("MyTestProject\\testdatasource.accdb")]
           [DataSource("MyJetDataSource")]
           public void MyTestMethod()
           {
               int a = Int32.Parse(context.DataRow["Arg1"].ToString());
               int b = Int32.Parse(context.DataRow["Arg2"].ToString());
               Assert.AreNotEqual(a, b, "A value was equal.");
           }
   
           [TestMethod()]
           [DeploymentItem("MyTestProject\\data.xlsx")]
           [DataSource("MyExcelDataSource")]
           public void MyTestMethod2()
           {
               Assert.AreEqual(context.DataRow["Val1"], context.DataRow["Val2"]);
           }
       }
   }
   

3. Examine the DataSource attributes. Notice the setting names from the app.config file.

4. Build your solution and run MyTestMethod and MyTestMethod2 tests.