SmartStore SQLite Backup and Restore

        protected override async Task RestoreDatabaseCore(string backupFullPath, bool async, CancellationToken cancelToken = default)
        {
            using var backupConnection = Database.GetDbConnection() as SqliteConnection;
            var thisConnection = new SqliteConnection("Data Source=" + backupFullPath); 

            try
            {
                SqliteConnection.ClearAllPools();
                if (async)
                {
                    await thisConnection.OpenAsync(cancelToken);
                }
                else
                {
                    thisConnection.Open();
                }
                thisConnection.BackupDatabase(backupConnection);
            }
            finally
            {
                if (async)
                {
                    await backupConnection.CloseAsync();
                    await thisConnection.CloseAsync();
                }
                else
                {
                    backupConnection.Close();
                    thisConnection.Close();
                }
                SqliteConnection.ClearPool(thisConnection);
                SqliteConnection.ClearPool(backupConnection);
            }
            return 1;
        }

        protected override async Task BackupDatabaseCore(string fullPath, bool async, CancellationToken cancelToken = default)
        {
            using var backupConnection = new SqliteConnection($"Data Source={fullPath}");
            var thisConnection = Database.GetDbConnection() as SqliteConnection;

            try
            {
                if (async)
                {
                    await thisConnection.OpenAsync(cancelToken);
                }
                else
                {
                    thisConnection.Open();
                }
                
                thisConnection.BackupDatabase(backupConnection);
            }
            finally
            {
                if (async)
                {
                    await backupConnection.CloseAsync();
                    await thisConnection.CloseAsync();
                }
                else
                {
                    backupConnection.Close();
                    thisConnection.Close();
                }
                SqliteConnection.ClearPool(backupConnection);
                SqliteConnection.ClearPool(thisConnection);
            }
            
            return 1;
        }