How to connection multiple connection string (runtime)
Posted: Tue 04 Aug 2015 18:30
1. use entity framework 6.1.3 / Devart version 8.3.264.4
2. use entity framework => Dbcontext / database first
3. I try change connection string use
var mysqlBuilder = new Devart.Data.MySql.MySqlConnectionStringBuilder();
mysqlBuilder.UserId = "****";
mysqlBuilder.Password = "******";
mysqlBuilder.Database = "developer";
mysqlBuilder.Host = "localhost";
mysqlBuilder.Port = ****;
mysqlBuilder.PersistSecurityInfo = true;
string providerString = mysqlBuilder.ToString();
var entityBuilder = new EntityConnectionStringBuilder();
entityBuilder.Provider = "Devart.Data.MySql";
entityBuilder.Metadata = @"res://*/Entities.DataModelEntities.csdl|res://*/Entities.DataModelEntities.ssdl|res://*/Entities.DataModelEntities.msl";
entityBuilder.ProviderConnectionString = providerString;
var uow = new DbContext(entityBuilder.ConnectionString);
database not change connection string use old database. how to change connection string run time.
Please help me
Thank you.
2. use entity framework => Dbcontext / database first
3. I try change connection string use
var mysqlBuilder = new Devart.Data.MySql.MySqlConnectionStringBuilder();
mysqlBuilder.UserId = "****";
mysqlBuilder.Password = "******";
mysqlBuilder.Database = "developer";
mysqlBuilder.Host = "localhost";
mysqlBuilder.Port = ****;
mysqlBuilder.PersistSecurityInfo = true;
string providerString = mysqlBuilder.ToString();
var entityBuilder = new EntityConnectionStringBuilder();
entityBuilder.Provider = "Devart.Data.MySql";
entityBuilder.Metadata = @"res://*/Entities.DataModelEntities.csdl|res://*/Entities.DataModelEntities.ssdl|res://*/Entities.DataModelEntities.msl";
entityBuilder.ProviderConnectionString = providerString;
var uow = new DbContext(entityBuilder.ConnectionString);
database not change connection string use old database. how to change connection string run time.
Please help me
Thank you.