Update the connection string dynamically.
using System.Data.SqlClient;
using System.Data.EntityClient;
public virtual string UpdateConnectionString(string database)
{
var _connectionString = "Data Source=.;Initial Catalog=SampleDB;Integrated Security=SSPI;MultipleActiveResultSets=True"
var sqlBuilder = new SqlConnectionStringBuilder(_connectionString);
sqlBuilder.InitialCatalog = database.ToString();
return sqlBuilder.ConnectionString;
}
Change Entity Framework ConnectionString dynamically
public virtual string UpdateEFConnectionString(string newConnectionString)
{
var csBuilder = new EntityConnectionStringBuilder();
csBuilder.ProviderConnectionString = newConnectionString;
return csBuilder.ConnectionString;
}
Thanks for sharing excellent information. Your
ReplyDeletewebsite is very cool.
Premium
Premium
An iOS app development class provides guided learning for mobile apps. It focuses on practical assignments and clarity. This ios app development class supports career-focused learning. It is dependable.
ReplyDeleteInformative post! Our ui ux classes
ReplyDeletebuilds skills through real-world design use cases.