public static sp19TourClubEntities Connect(string userName, string password) { sp19TourClubEntities dbContext = null; try { if (userName != null) { entityString = new EntityConnectionStringBuilder() { Provider = "System.Data.SqlClient", Metadata = "res://*/TouristClubModel.csdl|res://*/TouristClubModel.ssdl|res://*/TouristClubModel.msl", ProviderConnectionString = @"data source=STAS\SQLEXPRESS;initial catalog=sp19TourClub;persist security info=True;MultipleActiveResultSets=True;App=EntityFramework" }; entityString.ProviderConnectionString += ";user id=" + userName + ";Password=" + password; } dbContext = new sp19TourClubEntities(entityString.ConnectionString); if (dbContext.Database.Exists()) { return(dbContext); } } catch (Exception ex) { Console.WriteLine(ex); } dbContext?.Dispose(); return(null); }
private void BtnRefresh_Click(object sender, RoutedEventArgs e) { try { this.context.Dispose(); this.context = LoginWindow.Connect(null, null); LoadAll(); } catch (Exception ex) { MessageBox.Show(GetRealException(ex).Message, "Exception", MessageBoxButton.OK, MessageBoxImage.Error); } }
public MainWindow(sp19TourClubEntities context) { this.context = context; InitializeComponent(); }