private bool TestConnection(out string errorMessage) { DatabaseTester tester = new DatabaseTester( GetConnectionString(), ConfigurationManager.ConnectionStrings[StoreContext.ConnectionStringsTagName].ProviderName); return(tester.TestConnection(out errorMessage)); }
public async void Test(string sqlServerInstance, string databaseName, string login, string password) { ApplicationData.Current.LocalSettings.Values["canConnect"] = "Cannot establish connection"; DatabaseTester databaseTester = new DatabaseTester(GetConnectionString()); string message = string.Empty; try { await databaseTester.CanEstablishConnection(); System.Threading.Thread.Sleep(2000); var canConnect = ApplicationData.Current.LocalSettings.Values["canConnect"] as string; if (canConnect == "true") { message = "Connected, "; await databaseTester.IsDbNotOccupied(); System.Threading.Thread.Sleep(2000); var IsTheOnlyConnection = ApplicationData.Current.LocalSettings.Values["isTheOnlyConnection"] as string; if (IsTheOnlyConnection == "true") { message += "no other connections detected."; } else { message += "multiple database connections detected."; } } else { message = canConnect.ToString(); } } catch (SqlException e) { message = e.Message; } var dialog = new MessageDialog(message); await dialog.ShowAsync(); }
protected void uxTestReadButton_Click(object sender, EventArgs e) { try { DatabaseTester dbTest = CreateConnectionString(); string message; if (dbTest.TestSelectCommand("LanguageText", out message)) { uxResultLiteral.Text = AlertMessage("Test Read Permission Successful"); } else { uxResultLiteral.Text = DisplayErrorMessage(message); } } catch (Exception ex) { uxResultLiteral.Text = DisplayErrorMessage(ex.Message); } }
public void ShouldResolveAndExecuteAHandler() { new DatabaseTester().Clean(); var report = new ExpenseReport { Title = "TestExpens", Description = "This is an ", Number = "123", Status = ExpenseReportStatus.Cancelled }; using (var context = new StubbedDataContextFactory().GetContext()) { context.AddRange(report); context.SaveChanges(); } var container = new DatabaseTester().GetContainer(); var bus = container.GetInstance <Bus>(); var reports = bus.Send(new ListExpenseReportsCommand());; reports.Length.ShouldBe(1); }
private bool TestConnection(string connectionString, string providerName, out string errMessage) { DatabaseTester dbTest = new DatabaseTester(connectionString, providerName); return(dbTest.TestConnection(out errMessage)); }