/// <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"); }