App.config connection string relative path

by

You can specify a relative path as described in Lefty’s answer.

However this will be relative to the current working directory, which will not necessarily be the directory containing your executable.

One way round this is to modify the connection string before using it, e.g.

In app.config:

 connectionString="data source={AppDir}\data\EmailDatabase.sqlite

In your code:

ConnectionStringSettings c = ConfigurationManager.ConnectionStrings[name];    
if (c == null)
{
    ... handle missing connection string ...
}
string fixedConnectionString = c.ConnectionString.Replace("{AppDir}", AppDomain.CurrentDomain.BaseDirectory);
... use fixedConnectionString

More Related Contents:

  1. How do I set a connection string config programmatically in .net?
  2. Custom app.config Config Section Handler
  3. Encrypting connectionStrings section – utility for app.config
  4. How do I set CultureInfo.CurrentCulture from an App.Config file?
  5. What does ‘useLegacyV2RuntimeActivationPolicy’ do in the .NET 4 config?
  6. Could not load file or assembly ‘System.Data.SQLite’
  7. Pros and cons of AppSettings vs applicationSettings (.NET app.config / Web.config)
  8. Simplest way to have a configuration file in a Windows Forms C# application
  9. How to select different app.config for several build configurations
  10. Use XML includes or config references in app.config to include other config files’ settings
  11. How to modify .NET config files during installation?
  12. Using app.config with a class library
  13. .NET Config Files configSource outside the application directory folder
  14. SQLite equivalent to ISNULL(), NVL(), IFNULL() or COALESCE()
  15. How can I read/write app.config settings at runtime without using user settings?
  16. Added new application setting to app.config but MSI won’t install it (doesn’t overwrite)
  17. Connection string using Windows Authentication
  18. Entity Framework 6 with SQLite 3 Code First – Won’t create tables
  19. What is the difference between app.config file and XYZ.settings file?
  20. How to enable configSource attribute for Custom Configuration Section in .NET?
  21. system.data.sqlite .net 4
  22. Powershell Calling .NET Assembly that uses App.config
  23. How to conditionally deploy an app.config based on build configuration?
  24. How to securely store a connection string in a WinForms application?
  25. .Net app.config in library project
  26. Wrap a delegate in an IEqualityComparer
  27. Making WPF applications look Metro-styled, even in Windows 7? (Window Chrome / Theming / Theme)
  28. Why does OpenFileDialog change my working directory?
  29. How reliable is the FileSystemWatcher in .netFramwork 4?
  30. How do I bind a Byte array to an Image in WPF with a value converter?

Leave a Comment