/// <summary>
/// Inicia ou atualiza o contexto de dados do Entity Framework
/// </summary>
private void RefreshEFContext()
{
EFContext = new AlphaEntities();
EFHelper.ChangeDatabase(EFContext, "Alpha", mainWindowContext.settings.SqlInstance, "sa", "sic742", true, "AlphaEntities");
var config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
var connectionStringsSection = (ConnectionStringsSection)config.GetSection("connectionStrings");
Console.WriteLine(connectionStringsSection.ConnectionStrings["AlphaEntities"].ConnectionString);
}
/// <summary>
/// Classe responsável por alterar a conexão do Entity Framework.
/// </summary>
/// <param name="source">Contexto de dados</param>
/// <param name="initialCatalog">Banco de dados</param>
/// <param name="dataSource">Instância</param>
/// <param name="userId">Usuário</param>
/// <param name="password">Senha</param>
/// <param name="integratedSecurity"></param>
/// <param name="configConnectionStringName"></param>
public static void ChangeDatabase(AlphaEntities source, string initialCatalog = "", string dataSource = "", string userId = "", string password = "", bool integratedSecurity = true, string configConnectionStringName = "")
{
try
{
var configNameEf = string.IsNullOrEmpty(configConnectionStringName)
? source.GetType().Name
: configConnectionStringName;
// Adiciona a referencia ao Configuration Manager.
var entityCnxStringBuilder = new EntityConnectionStringBuilder
(System.Configuration.ConfigurationManager
.ConnectionStrings[configNameEf].ConnectionString);
// Inicia o sqlbuilder com a cadeia de conexão
var sqlCnxStringBuilder = new SqlConnectionStringBuilder
(entityCnxStringBuilder.ProviderConnectionString);
// Adiciona apenas os campos passados por parâmetros.
if (!string.IsNullOrEmpty(initialCatalog))
{
sqlCnxStringBuilder.InitialCatalog = initialCatalog;
}
if (!string.IsNullOrEmpty(dataSource))
{
sqlCnxStringBuilder.DataSource = dataSource;
}
if (!string.IsNullOrEmpty(userId))
{
sqlCnxStringBuilder.UserID = userId;
}
if (!string.IsNullOrEmpty(password))
{
sqlCnxStringBuilder.Password = password;
}
// Define o estado integrated security
sqlCnxStringBuilder.IntegratedSecurity = integratedSecurity;
// Muda as propriedades
source.Database.Connection.ConnectionString
= sqlCnxStringBuilder.ConnectionString;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
/// <summary>
/// Inicializa componentes da classe.
/// </summary>
private void InitializeComponents()
{
GetMainWindow();
settings = JsonHelper.JsonFileReader(@"\AlphaSettings.json");
EFContext = new AlphaEntities();
EFHelper.ChangeDatabase(EFContext, "Alpha", settings.SqlInstance, "sa", "sic742", true, "AlphaEntities");
CenterWindowOnScreen();
#region Inicialização dos comandos
registerMenuCommand = new RelayCommand(ShowOrHideSubRegisterSubMenu);
showProvidersWindowCommand = new RelayCommand(ShowProviderWindow);
showProductsWindowCommand = new RelayCommand(ShowProductWindow);
maxProductWindowCommand = new RelayCommand(MaxProductWindow);
maxProviderWindowCommand = new RelayCommand(MaxProviderWindow);
signOutCommand = new RelayCommand(SignOut);
#endregion
}
/// <summary>
/// Inicia ou atualiza o contexto de dados do Entity Framework.
/// </summary>
private void RefreshEFContext()
{
EFContext = new AlphaEntities();
EFHelper.ChangeDatabase(EFContext, "Alpha", mainWindowContext.settings.SqlInstance, "sa", "sic742", true, "AlphaEntities");
}
