Wednesday, December 14, 2011

Best way to change the ConnectionString dynamically in C#



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;
}

3 comments:

  1. Thanks for sharing excellent information. Your
    website is very cool.
    Premium
    Premium

    ReplyDelete
  2. 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.

    ReplyDelete
  3. Informative post! Our ui ux classes
    builds skills through real-world design use cases.

    ReplyDelete