Add connection string without using app.config

Question

I created a data access level dll using subsonic. however, it uses the connection string from app.config. I use it in ninjatrader and don't want to mess with ninjatrader app.config for connecitonstring. how can i avoid this problem.

Answer 1

I believe that best of all you can count on using a separate file for connection strings:

in app.config

<connectionStrings ConfigSource="myConnStr.config" />

in myConnStr.config:

<connectionStrings > 
  <add .... />
  <add .... />
</connectionStrings > 

Answer 2

I believe that you can set it at runtime using the SetDefaultConnectionString method :

SubSonic.DataService.GetInstance("InstanceName").SetDefaultConnectionString("ConnectionString");

Answer 3

, hardcode connectionstring:

string connectionString = string.Format(@"Data Source={0}", Path.Combine(this.ConfigFolder, ConfigDb));
string providerName = @"System.Data.SQLite";
var provider = ProviderFactory.GetProvider(connectionString, providerName);
_configRepo = new SimpleRepository(provider, SimpleRepositoryOptions.RunMigrations);

sqlite, .ConfigFolder. ConfigDB .