DevForce Community Forum : Changing the Connection String at Runtime

DevForce Community Forum : Changing the Connection String at Runtime http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Changing the Connection String at Runtime Wed, 13 May 2026 09:41:30 -700 Fri, 02 Mar 2012 00:07:41 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3310 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Changing the Connection String at Runtime : Hi Sbelini,Thank you for the help,... http://www.ideablade.com/forum/forum_posts.asp?TID=3310&PID=12879#12879 Author: Sakar SR
Subject: 3310
Posted: 02-Mar-2012 at 12:07am

Hi Sbelini,

Thank you for the help, i solved the problem

Have a nice day

Regards,
Sakar

]]> Fri, 02 Mar 2012 00:07:41 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3310&PID=12879#12879 Changing the Connection String at Runtime : Hi Sakar,It might be possible... http://www.ideablade.com/forum/forum_posts.asp?TID=3310&PID=12878#12878 Author: sbelini
Subject: 3310
Posted: 01-Mar-2012 at 6:13pm

Hi Sakar,

It might be possible that your connection is sting is malformed. (I see opening single quotes on datapath, but no closing)

A good starting point would be looking at the connectionString created in your Model's app.config file (i.e. assuming you created your model based on an existing database)

For instance, I've tried the following without any issues: (I've copied the connectionString from app.config)

EdmKeyElement edmKey = new EdmKeyElement("NorthwindIBEntities");

edmKey.Connection = "metadata=res://*/NorthwindModel.csdl|res://*/NorthwindModel.ssdl|res://*/NorthwindModel.msl;provider=System.Data.SqlClient;provider connection string='data source=.;initial catalog=NorthwindIB;integrated security=True;multipleactiveresultsets=True;App=EntityFramework'";

IdeaBladeConfig.Instance.EdmKeys.Add(edmKey);

Also, you might want to use DataSourceExtensions.

You can find more details about DataSourceExtensions in the DevForce Resource Center.

Regards,

Silvio.

Edited by sbelini - 01-Mar-2012 at 6:44pm]]> Thu, 01 Mar 2012 18:13:57 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3310&PID=12878#12878 Changing the Connection String at Runtime : How to change the directory and... http://www.ideablade.com/forum/forum_posts.asp?TID=3310&PID=12871#12871 Author: Sakar SR
Subject: 3310
Posted: 01-Mar-2012 at 6:58am

How to change the directory and path of my database location ?

string datapath = @"'D:\SQLite Database\eFillerDB\eFilerDB.DAT";
string metadata = @"metadata= res://*/eFiler.csdl|//*/eFiler.ssdl|res://*/eFiler.msl;
                                provider=System.Data.SQLite;
                                provider connection string='data source='" + datapath;
string conn = metadata;

var config = IdeaBlade.Core.IdeaBladeConfig.Instance;
var keys = config.EdmKeys;

keys.Add(
                new EdmKeyElement
                {
                    Name = "eFilerDBEntities",
                    LogTraceString = false
                    Connection = conn
                });

When i try to run this code i get an runtime error saying to check the connection string.

my requirement is only to change the path and directory of the database location at runtime . what is wrong in the above code.

Please explain, to correct this problem.

]]> Thu, 01 Mar 2012 06:58:30 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3310&PID=12871#12871