current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 16 down vote favorite
4

I am using a SQL express databases as part of a unit test project in c#.

My databases is located in ./Databases/MyUnitTestDB.mdf

I would like to use a relative path or variable in the app.config rather than having my connection string defined as:

.. AttachDbFilename=C:\blah\blah\blah\yea\yea\yea\MyApplication\Databases\MyUnitTestDB.mdf ..

I have seen the use of |DataDirectory| but am I correct in thinking this is only applicable to web?

I want to control this in the application configuration file, as in production the application uses a hosted sql database.

share|improve this question
add comment

5 Answers 5

up vote 2 down vote

I don't have Visual Studio here, but what about:

using System.IO;
using System.Windows.Forms;

string appPath = Path.GetDirectoryName(Application.ExecutablePath);
AttachDBFilme = appPath + "\\MyUnitTestDB.mdf"
share|improve this answer
2  
I would suggest something along that line, perhaps used together with ADO.NET's connection string builders to put together the final connection string. –  stakx Aug 17 '10 at 9:12
add comment
up vote 7 down vote

Yes, |DataDirectory| is only for Web application to select the App_Data directory of the web application.

You have two posiblities to create the connection:

1.- Use a relative path:

String con ="... AttachDbFilename=Databases\MyUnitTestDB.mdf ... ";

2.- get the application path and add to the String.
In c# Windows Application you can use Application.StartupPath

 String con= " ... AttachDbFilename=" + Application.StartupPath + "\Databases\MyUnitTestDB.mdf ... ";

Depending on the applicaiton type or launch mode you got different properties. Ex:

  • Application.StartupPath -- The start path of the exe application that starts the application

  • Application.ExecutablePath -- the start path an name of the exe application that stats the application But to use Application you need to include System.Windows.Forms that is not included for example into console applications.

  • System.IO.Path.GetDirectoryName( System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) -- This gets the path from the current assembly "dll,exe,..." Is not affected by application type, path changes,... Always return the directory when the Assemby resides.

  • Environment.CurrentDirectory -- the current directory. This can be changed for example if you navigate into folders.

You can find more about the different connection string options here http://www.connectionstrings.com/sql-server-2005

share|improve this answer
    
Thanks Dubas, option 1 is what I want to use however I cannot get this working. –  Adam Jenkin Aug 17 '10 at 10:25
    
Option 1 depends on your executing path. If your UInit test are executing with a different path that your application probably the use of a relative path gives you to a different path that the expected path. –  Dubas Aug 17 '10 at 11:53
add comment
up vote 21 down vote accepted

Thanks everyone, I used a combination of your responses.

In my app.config file my connection string is defined as follows

<add name="MyConnectionString"
    connectionString="Server=.\SQLExpress;AttachDbFilename=|DataDirectory|\MyDatabase.mdf;Database=MyDatabaseForTesting;Trusted_Connection=Yes;" />

In my unit test class I set the DataDirectory property using the following

[TestInitialize]
public void TestInitialize()
{
    AppDomain.CurrentDomain.SetData("DataDirectory", System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Databases"));

    // rest of initialize implementation ...
}
share|improve this answer
    
To learn more about the DataDirectory term: msdn.microsoft.com/en-us/library/cc716756.aspx (look for "DataDirectory", it's at the end of the document) –  Yves M. Mar 14 at 15:32
add comment
up vote 3 down vote

I have spent a whole day googling to work this through and finally have a clue from this

Here is my solution:
1. Use |DataDirectory| in connection string

<add name="NorthwindConnectionString" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDbFilename=|DataDirectory|\Northwind.mdf;User Instance=True" providerName="System.Data.SqlClient" />

2.Set DataDirectory in ClassInitialize

[ClassInitialize()]
public static void MyClassInitialize(TestContext testContext)
{
    string baseDir = AppDomain.CurrentDomain.BaseDirectory;
    int index = baseDir.IndexOf("TestResults");
    string dataDir = baseDir.Substring(0, index) + System.Reflection.Assembly.GetExecutingAssembly().GetName().Name;
    AppDomain.CurrentDomain.SetData("DataDirectory", dataDir);
}

enter image description here

share|improve this answer
add comment
up vote 2 down vote

I'm building a simple Windows Forms App with VS2010 with C#3.0. Also using SQL Express 2008 RC2.

I am able to use: |DataDirectory|MyDb.mdf in the connection string alone without changing anything else. The |DataDirectory| points to the location of my .exe file.

I will think that this would be the first thing all of you would try, so that is why I'm specifying my VS and SQL version. Or maybe it is new to C#3.0.

My complete Connection String:

"Server=.\SQLExpress;AttachDbFilename=|DataDirectory|App_Data\ThumbsUpPlayer.mdf;Database=ThumbsUpPlayer;Trusted_Connection=Yes;"

Note that I have added a "App_Data" folder to my application, because I'm used to the Db in that folder, the folder is not recognised by VS.

share|improve this answer
2  
Did you mean to say "App_Data" instead of "App_Code" in the last sentence? –  Manfred Dec 6 '12 at 3:53
    
@Manfred yes you are correct! Edited answer. –  Wasted_Coder Jun 17 at 20:25
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.