SQL Express connection string: mdf file location relative to application location

by

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 ...
}

More Related Contents:

  1. SQL Insert Query Using C#
  2. How to fix “The ConnectionString property has not been initialized”
  3. encrypt SQL connectionstring c#
  4. SQL/C# – Best method for executing a query
  5. Persist Security Info Property=true and Persist Security Info Property=false
  6. How do I update a value in C# and SQL Server? [closed]
  7. Error: You have an error in your SQL syntax – but SQL statement works
  8. Store value in Yes/No field in Access using C#
  9. How to save leap date ’02/29/2006′ to sql server database? [duplicate]
  10. how to get date difference between two dates using DateDiff Excluding the weekends [duplicate]
  11. C# Data Connections Best Practice?
  12. Is there a good LINQ way to do a cartesian product?
  13. Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints
  14. Entity Framework Timeouts
  15. Read SQL Table into C# DataTable
  16. SQL command INSERT is working but the data not appear in table
  17. Difference between Parameters.Add(string, object) and Parameters.AddWithValue
  18. Pass connection string to code-first DbContext
  19. How do I connect to an MDF database file?
  20. SQL injection on INSERT
  21. Equivalent of SQL ISNULL in LINQ?
  22. The C# using statement, SQL, and SqlConnection
  23. C# constructing parameter query SQL – LIKE %
  24. Generate class from database table
  25. What is passing parameters to SQL and why do I need it?
  26. Calling a SQL User-defined function in a LINQ query
  27. How to create NVarchar(max) Sqlparameter in C#? [duplicate]
  28. Enabling Foreign key constraints in SQLite
  29. no overload for method “ToString” takes 1 arguments
  30. How do I extract data from a DataTable?

Leave a Comment