DevForce Community Forum : Code First Migration using DataSourceKey http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Code First Migration using DataSourceKey Wed, 13 May 2026 01:05:40 -700 Mon, 26 Nov 2012 22:50:52 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3800 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Code First Migration using DataSourceKey : Hi Koen,We have created a workaround... http://www.ideablade.com/forum/forum_posts.asp?TID=3800&PID=15280#15280 Author: Vonzkie
Subject: 3800
Posted: 26-Nov-2012 at 10:50pm

Hi Koen,

We have created a workaround that might help you as well.

On your Custom DbContext:

    public class GlobalDBContext : DbContext
    {
        public GlobalDBContext() :
             base(Web.GetLatestMigrationConnection("MyEntities") ?? "name=MyEntities")
        {

        }
    }

Just add a method call on the base Constructor parameter that compose your connection string on runtime.

Note that when you're creating migration script via Package Manager Console (Add-Migration 'Something') you need to comment out this base(Web.GetLatestMigrationConnection("MyEntities") ?? "name=MyEntities")
and replace it with a basic base("name=MyEntities") that gets connection string from your app.config.
The code that I gave you above only works on production runtime. :)

Thanks,
Von


]]> Mon, 26 Nov 2012 22:50:52 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3800&PID=15280#15280 Code First Migration using DataSourceKey : Any answers to this question,... http://www.ideablade.com/forum/forum_posts.asp?TID=3800&PID=15279#15279 Author: sky40627
Subject: 3800
Posted: 26-Nov-2012 at 10:38pm

Any answers to this question, I am trying to do the same.

Without any luck so far.

I also have a BOS that can connect to different databases.

Thx

Koen]]> Mon, 26 Nov 2012 22:38:38 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3800&PID=15279#15279 Code First Migration using DataSourceKey : Hi Silvio,Thanks for the info.However,... http://www.ideablade.com/forum/forum_posts.asp?TID=3800&PID=15211#15211 Author: Vonzkie
Subject: 3800
Posted: 15-Nov-2012 at 2:57pm

Hi Silvio,

Thanks for the info.
However, do you have an idea if EF has a dynamic way on constructing the connection string on Migration?

I ask this because our BOS' model handles not only one connection to the database and we use IDatasourceKeyResolver to compose the connection string.

Model1 can connection to Database A, Database B, Database C. So how do I perform automatic migration here in the production environment?

Thanks,
Von
]]> Thu, 15 Nov 2012 14:57:53 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3800&PID=15211#15211 Code First Migration using DataSourceKey : Hi Von,Since Migration does... http://www.ideablade.com/forum/forum_posts.asp?TID=3800&PID=15210#15210 Author: sbelini
Subject: 3800
Posted: 15-Nov-2012 at 10:58am

Hi Von,
 
Since Migration does not rely on DevForce, (i.e. it's pure EF) IDataSourceKeyResolver does not play a role in it and you will have to use the connectionString in the .config file.
 
   sbelini.
]]> Thu, 15 Nov 2012 10:58:40 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3800&PID=15210#15210 Code First Migration using DataSourceKey : Hi,We are trying to use Code First... http://www.ideablade.com/forum/forum_posts.asp?TID=3800&PID=15209#15209 Author: Vonzkie
Subject: 3800
Posted: 15-Nov-2012 at 2:43am

Hi,

We are trying to use Code First Migration in our database and it works well but the limitation is the connection string should be in the Web.config.

How can we do this process by invoking the IDataSourceKeyResolver or any way to dynamically compose the connection string to update the database.

Note that I'm doing the Update-Database command via code not in the Package Manager Console.

var migratorConfig = new Model.Migrations.Configuration();
var dbMigrator = new DbMigrator(migratorConfig);
dbMigrator.Configuration.AutomaticMigrationDataLossAllowed = false;
dbMigrator.Update();

Thanks,
Von
]]> Thu, 15 Nov 2012 02:43:52 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3800&PID=15209#15209