/// <summary>
/// Check the environment variable, and create a new ApplicationDbContext accordingly.
/// </summary>
/// <returns></returns>
public ApplicationDbContext Create()
{
if (LibUnityConfig.ChoosePlaceStoreFromConfig() == PlaceStoreFlag.MySql)
{
string envConnectionString = Environment.GetEnvironmentVariable(
"LockedNLoaded:ConnectionStringCloudSql");
if (envConnectionString != null)
{
// Pull the connection string from the environment variable.
return(new ApplicationDbContext(
new MySql.Data.MySqlClient.MySqlConnection(envConnectionString)));
}
}
else if (LibUnityConfig.ChoosePlaceStoreFromConfig() == PlaceStoreFlag.SqlServer)
{
string envConnectionString = Environment.GetEnvironmentVariable(
"LockedNLoaded:ConnectionStringSqlServer");
if (envConnectionString != null)
{
// Pull the connection string from the environment variable.
return(new ApplicationDbContext(
new System.Data.SqlClient.SqlConnection(envConnectionString)));
}
}
// Pulls connection string from Web.config.
return(new ApplicationDbContext());
}
public Configuration()
{
AutomaticMigrationsEnabled = false;
if (LibUnityConfig.ChoosePlaceStoreFromConfig() == PlaceStoreFlag.MySql)
{
SetSqlGenerator("MySql.Data.MySqlClient",
new MySql.Data.Entity.MySqlMigrationSqlGenerator());
}
else if (LibUnityConfig.ChoosePlaceStoreFromConfig() == PlaceStoreFlag.SqlServer)
{
SetSqlGenerator("System.Data.SqlClient",
new System.Data.Entity.SqlServer.SqlServerMigrationSqlGenerator());
}
}
/// <summary>
/// Pulls connection string from Web.config.
/// </summary>
internal ApplicationDbContext() : base("name=" +
((LibUnityConfig.ChoosePlaceStoreFromConfig() == PlaceStoreFlag.MySql)
? s_mySqlServerBaseName : s_sqlServerBaseName))
{
}
