Db.db-shm and db.db-wal cannot be cleaned up automatically

[84819760]

class

public class Table1
{
    public long Id { get; set; }

    public string? Value { get; set; }
}

public class DbContext : Microsoft.EntityFrameworkCore.DbContext
{
    public DbSet<Table1>? Tables { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        var conn = new SqliteConnectionStringBuilder()
        {
            DataSource = @"D:\tmp\EF6.db",
        };
        optionsBuilder.UseSqlite(conn.ToString());
    }
}

Program.cs

using var db = new DbContext();
using var bt = db.Database.BeginTransaction();
Enumerable.Range(0, 10000)
    .Select(i => new Table1 { Value = i.ToString() })
    .ToList()
    .ForEach(item => db.Add(item));
await bt.CommitAsync();
await db.SaveChangesAsync();

The above code can be executed normally in entityframeworkcore5, and ef6.db-shm and ef6.db-wal can be cleaned up automatically.

After upgrading entityframeworkcore6, a write data exception will occur. Data will only be written to ef6.db-wal. There is no data in ef6.db, and ef6.db-shm and ef6.db-wal will not be cleaned up automatically. This phenomenon also occurs when PM> Update-Databaseis executed.

EF Core version:
Database provider: (e.g. Microsoft.EntityFrameworkCore.Sqlite 6.0.0)
Target framework: (e.g. .NET 6.0)
Operating system:
IDE: (e.g. Visual Studio 2022 17.0.1)

[ajcvickers]

Duplicate of #26422.

[84819760]

复本#26422.

Thank you.