Tutorial :add connection string without using app.config



Question:

i created a data access layer dll using subsonic. however it uses the connectionstring from the app.config. i am using it in ninjatrader and dont want to mess around with the ninjatrader app.config for the connecitonstring. how do i avoid this issue.


Solution:1

I believe the best you can hope for here is to use a separate file for the connection strings:

in app.config

<connectionStrings ConfigSource="myConnStr.config" />  

in myConnStr.config:

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


Solution:2

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

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


Solution:3

Sample how to programatically 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);  

This sample use sqlite database which is located in this.ConfigFolder. ConfigDB contains name of a database file.


Note:If u also have question or solution just comment us below or mail us on toontricks1994@gmail.com
Previous
Next Post »