Resolve SQLite database file bloat in ASP.NET Core by performing a manual vacuum operation to reclaim space from deleted records and unoptimized WAL settings.