public static bool GetEntityConnection(string Username, string Password, string Host, string Database, string Name, bool IntegratedSecurity) { string connectionString; if (IntegratedSecurity) { connectionString = new System.Data.EntityClient.EntityConnectionStringBuilder { Metadata = "res://*", Provider = "System.Data.SqlClient", ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder { InitialCatalog = Database, DataSource = Host, IntegratedSecurity = true, MultipleActiveResultSets = true }.ConnectionString }.ConnectionString; } else { connectionString = new System.Data.EntityClient.EntityConnectionStringBuilder { Metadata = "res://*", Provider = "System.Data.SqlClient", ProviderConnectionString = new System.Data.SqlClient.SqlConnectionStringBuilder { InitialCatalog = Database, DataSource = Host, IntegratedSecurity = false, UserID = Username, Password = Password, MultipleActiveResultSets = true }.ConnectionString }.ConnectionString; } try { using (var Context = new finalDBEContext(connectionString)) { Context.Database.Connection.Open(); Context.Database.Connection.Close(); } } catch(Exception e) { Debug.WriteLine("Connection Failed. Message: " + e.Message); return false; } string BaseConnStr = connectionString; ConnDictionary.Add(Name, BaseConnStr.Replace(Password, "{0}")); ConnectionString = connectionString; return true; }
private void MenuItemNewEmp_Click(object sender, RoutedEventArgs e) { using (var Context = new finalDBEContext()) { } }