About SQLite Support

                if (_db.Database.ProviderName != "Microsoft.EntityFrameworkCore.Sqlite")
                    model.DatabaseSize = Convert.ToInt64(mbSize * 1024 * 1024);
                else
                    model.DatabaseSize = Convert.ToInt64(mbSize);

                new SelectListItem { Value = "sqlite", Text = T("UseSqlite"), Selected = isWindows },

public override string EncloseIdentifier(string identifier)
        {
            Guard.NotEmpty(identifier, nameof(identifier));
            return identifier.EnsureStartsWith('`').EnsureEndsWith('`');
        }


        public override string ApplyPaging(string sql, int skip, int take)
        {
            Guard.NotNegative(skip, nameof(skip));
            Guard.NotNegative(take, nameof(take));


            return $@"{sql} LIMIT {take} OFFSET {skip}";
        }


        public override string[] GetTableNames()
        {
            return Database.ExecuteQueryRaw<string>(
                $"SELECT name FROM sqlite_schema WHERE type ='table' AND name NOT LIKE 'sqlite_%';").ToArray();
        }


        public override async Task<string[]> GetTableNamesAsync()
        {
            return await Database.ExecuteQueryRawAsync<string>(
                $"SELECT name FROM sqlite_schema WHERE type ='table' AND name NOT LIKE 'sqlite_%';").AsyncToArray();
        }


        protected override int? GetTableIncrementCore(string tableName)
        {
            return Database.ExecuteScalarInterpolated<ulong>(
                 $"SELECT seq FROM sqlite_sequence WHERE NAME = {tableName}").Convert<int?>();
        }


        protected override async Task<int?> GetTableIncrementCoreAsync(string tableName)
        {
            return (await Database.ExecuteScalarInterpolatedAsync<ulong>(
                $"SELECT seq FROM sqlite_sequence WHERE NAME = {tableName}")).Convert<int?>();
        }


        protected override void SetTableIncrementCore(string tableName, int ident)
        {
            Database.ExecuteSqlRaw(
                $"UPDATE sqlite_sequence SET seq=0 WHERE NAME='{tableName}';");
        }


        protected override Task SetTableIncrementCoreAsync(string tableName, int ident)
        {
            return Database.ExecuteSqlRawAsync(
                $"UPDATE sqlite_sequence SET seq=0 WHERE NAME='{tableName}';");
        }


        public override int ShrinkDatabase()
        {
            return Database.ExecuteQueryRaw<int>($"VACUUM;PRAGMA wal_checkpoint=TRUNCATE;PRAGMA optimize;PRAGMA wal_autocheckpoint;").FirstOrDefault();
        }


        public override async Task<int> ShrinkDatabaseAsync(CancellationToken cancelToken = default)
        {
            //https://www.sqlite.org/pragma.html#pragma_journal_mode
            //https://www.sqlite.org/lang_analyze.html
            return await Database.ExecuteQueryRawAsync<int>($"VACUUM;PRAGMA wal_checkpoint=TRUNCATE;PRAGMA optimize;PRAGMA wal_autocheckpoint;").FirstOrDefaultAsync();
        }


        /// <summary>
        /// GetDatabaseSize
        /// MaintenanceController.cs line 296 change 
        ///     if (_db.Database.ProviderName != "Microsoft.EntityFrameworkCore.Sqlite")
        ///         model.DatabaseSize = Convert.ToInt64(mbSize* 1024 * 1024);
        ///     else
        ///         model.DatabaseSize = Convert.ToInt64(mbSize);
        /// </summary>
        public override decimal GetDatabaseSize()
        {
            return Database.ExecuteQueryRaw<decimal>(
                $"SELECT (page_count * page_size) as size FROM pragma_page_count(), pragma_page_size();").FirstOrDefault();
        }


        public override async Task<decimal> GetDatabaseSizeAsync()
        {
            //https://stackoverflow.com/questions/6364577/how-to-get-the-current-sqlite-database-size-or-package-size-in-android
            return await Database.ExecuteQueryRawAsync<decimal>(
                $"SELECT (page_count * page_size) as size FROM pragma_page_count(), pragma_page_size();").FirstOrDefaultAsync();
        }


        public override async Task<int> InsertIntoAsync(string sql, params object[] parameters)
        {
            //https://stackoverflow.com/questions/8892973/how-to-get-last-insert-id-in-sqlite
            Guard.NotEmpty(sql, nameof(sql));
            return (await Database.ExecuteQueryRawAsync<decimal>(
                sql + "; SELECT last_insert_rowid();", parameters).FirstOrDefaultAsync()).Convert<int>();
        }