Using app.config file to define a data source, odbc driver, access database engine, data driven testing , Excel

https://docs.microsoft.com/en-us/visualstudio/test/walkthrough-using-a-configuration-file-to-define-a-data-source?view=vs-2019


Install Access Database Engine

Install 32 bit

Add ODBC Data Source:
















    1. Create a  CodedUI Project
    2. Create a Excel sheet data. (Copy always)
   
         

    2. Add App.config file
 

?xml version="1.0" encoding="utf-8" ?>

<configuration>

    <configSections>

        <section name="microsoft.visualstudio.testtools" type="Microsoft.VisualStudio.TestTools.UnitTesting.TestConfigurationSection, Microsoft.VisualStudio.QualityTools.UnitTestFramework, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>

    </configSections>

    <connectionStrings>

        <add name="MyJetConn" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\testdatasource.accdb; Persist Security Info=False;" providerName="System.Data.OleDb" />

        <add name="MyExcelConn" connectionString="Dsn=Excel Files;dbq=data.xlsx;defaultdir=.\; driverid=790;maxbuffersize=2048;pagetimeout=5" providerName="System.Data.Odbc" />

    </connectionStrings>

    <microsoft.visualstudio.testtools>

        <dataSources>

            <add name="MyJetDataSource" connectionString="MyJetConn" dataTableName="MyDataTable" dataAccessMethod="Sequential"/>

            <add name="MyExcelDataSource" connectionString="MyExcelConn" dataTableName="Sheet1$" dataAccessMethod="Sequential"/>

        </dataSources>

    </microsoft.visualstudio.testtools>

</configuration>

Write Test:

  [TestMethod()]

        [DeploymentItem("data.xlsx")]

        [DataSource("MyExcelDataSource")]

        public void MyTestMethod2()

        {

            Console.WriteLine(TestContext.DataRow["Val1"]);

            Console.WriteLine(TestContext.DataRow["Val2"]);           

        }

Troubleshoot:

In App.config, Yellow highlighted is having same version of the visual studio Unit Framework dll.

--EoF--