c# - How to refer to the datasource directory in MS Visual Studio unit test? -


i have created app.config file in ms visual studio. content of app.config file below:

 <?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="myexcelconn" connectionstring="dsn=excel files;dbq=testcases\data.xlsx;defaultdir=.; driverid=790;maxbuffersize=2048;pagetimeout=5" providername="system.data.odbc" />   </connectionstrings>   <microsoft.visualstudio.testtools>     <datasources>       <add name="myexceldatasource" connectionstring="myexcelconn" datatablename="testdata$" dataaccessmethod="sequential"/>     </datasources>   </microsoft.visualstudio.testtools> </configuration>

i have created folder named "testcases" in same directory app.config file. put data.xlsx file inside testcases folder. information, data.xlsx data source of unit tests. coded directory of data source testcases\data.xlsx doesn't work. don't want hard code "c:\user...." require me change code if wish run code on computer. suggestions?

there few options

  1. this easiest one. set [deploymentitem("yourexcelfile")] attribute on test class or test method, way can refer them config using relative path of .\yourexcelfile.

  2. this 1 harder, since mstest drops testresults folder in same location (relative solution) can use ..\..\..\..\project\yourexcelfile path it. beware, tfs' team build may use different relative path , before know need trickery in build system work.

  3. copy excel file wellknown location, c:\testsources\mydatasource , map file location using tfvc source control workspace setup. allow test configuration point full path, should able find.


Comments

Post a Comment

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

i make custom datepicker directive custom template. but have no idea how start building it... how include date data directive? i appreciate guide or give me advice work on more precisely. it might you! follow below steps html code sample: <label>birth date</label> <input type="text" ng-model="birthdate" date-options="dateoptions" custom-datepicker/> <hr/> <pre>birthdate = {{birthdate}}</pre> <script type="text/ng-template" id="custom-datepicker.html"> <div class="enhanced-datepicker"> <div class="proxied-field-wrap"> <input type="text" ui-date-format="yy-mm-dd" ng-model="ngmodel" ui-date="dateoptions"/> </div> <label> <button class="btn" type="button"><i class="icon-calendar"></i>
Read more

javascript - jQuery date picker - Disable dates after the selection from the first date picker -

<!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <title>jquery ui datepicker - default functionality</title> <link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css"> <script src="//code.jquery.com/jquery-1.10.2.js"></script> <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script> <link rel="stylesheet" href="/resources/demos/style.css"> <script> $(function () { $("#datepicker1").datepicker(); }); </script> <script> $(function () { $("#datepicker2").datepicker(); }); </script> </head> <body> <p>date 1: <input type="text" id="datepicker1"></p> <p>date 2: <input type="t
Read more