Add SQLite DB relative path to app.config

Add SQLite DB relative path to app.config

I have a versioned project shared across a small team and I'd like to avoid using absolute paths for my connection string. Instead I'd like to use either an environment variable or a relative path based on where the project is located.

My question is related to the design phase (we are using the connection in our dataset). I do change the path at runtime, so that's not an issue. 

This is the connection string in my app.config file
  1. <add name="MyProject.Properties.Settings.ConnectionString" connectionString="Data Source=C:\workspace\MySolution\MyDb.db" providerName="Devart.Data.SQLite" />