public void TestSqliteConnectionCannotBeEstablished() { string connectionString = $"Data Source={Guid.NewGuid()};FailIfMissing=true;"; var xQuery = new XQuerySqlite(connectionString); Assert.IsFalse(xQuery.TestConnection()); }
private void App_OnStartup(object sender, StartupEventArgs e) { var defaultPath = DatabasePath = $@"{Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData)}\{Assembly.GetExecutingAssembly().GetName().Name}"; DatabaseFilePath = $@"{defaultPath}\ba.sqlite"; var connectionString = $@"Data Source={DatabaseFilePath};Version=3;UTF8Encoding=True;foreign keys=true;FailIfMissing=true;"; try { connectionString = ConfigurationManager.ConnectionStrings["SqliteConnection"].ConnectionString; DatabaseFilePath = ExtractFilePathFromConnectionString(connectionString); DatabasePath = ExtractPathFromFilePath(DatabaseFilePath); } catch (NullReferenceException) { // ignored } try { BackupRemoteFolderId = ConfigurationManager.AppSettings["BackupRemoteFolderId"]; } catch (NullReferenceException) { // ignored } if (Sqlite.TestConnection(connectionString)) { Sqlite.ConnectionString = connectionString; } else { MessageBox.Show($"Не удалось установить соединение с базой данных.{Environment.NewLine}Детали: {Sqlite.LastErrorMessage}", "Business Accounting", MessageBoxButton.OK, MessageBoxImage.Stop); Current.Shutdown(); } }
public void TestNoErrorWhileCheckingTheConnectionWithNull() { var xQuery = new XQuerySqlite(); Assert.IsFalse(xQuery.TestConnection()); }
public void TestSqliteConnectionCanBeEstablished() { var xQuery = new XQuerySqlite(SetUp.SqliteConnectionString); Assert.IsTrue(xQuery.TestConnection()); }