#:package Microsoft.EntityFrameworkCore@10.0.2
#:package Npgsql.EntityFrameworkCore.PostgreSQL@10.0.0
#:package Testcontainers@4.10.0

using DotNet.Testcontainers.Builders;
using DotNet.Testcontainers.Containers;
using EfCore10Regression.Tests;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.Logging;
using Npgsql;
using static EfCore10Regression.Tests.Models;

var fixture = new PostgresContainerFixture();
await fixture.InitializeAsync();
Console.WriteLine($"Postgres started. ConnectionString={fixture.ConnectionString}");
Console.WriteLine($"Logging SQL to: {fixture.LogFilePath}");

await using (var ctx = fixture.CreateContext())
{
    var modelBs = new List<ModelB>
    {
        new() {
            Id = 1,
            ModelCs = []
        }
    };

    ctx.Models.Add(new ModelA
    {
        Id = 0,
        ModelBs = modelBs
    });

    await ctx.SaveChangesAsync();
}

await using var context = fixture.CreateContext();

var rawData = await context.Models.SingleAsync();
Console.WriteLine($"Nbr items before {rawData.ModelBs.Count}");

rawData.ModelBs = [.. rawData.ModelBs.Where(x => x.Id != 1)];
Console.WriteLine($"Nbr items after {rawData.ModelBs.Count}");

await context.SaveChangesAsync();
Console.WriteLine("SUCCESS!!");
Console.ReadLine();

await fixture.DisposeAsync();

namespace EfCore10Regression.Tests
{
    public class RegressionDbContext(DbContextOptions<RegressionDbContext> options) : DbContext(options)
    {
        public DbSet<Models.ModelA> Models => Set<Models.ModelA>();

        protected override void OnModelCreating(ModelBuilder modelBuilder)
        {
            modelBuilder.Entity<Models.ModelA>(b => b.ComplexCollection(c => c.ModelBs, c =>
            {
                c.ToJson();
            }));
        }
    }

    public static class Models
    {
        public class ModelA
        {
            public int Id { get; set; }
            public List<ModelB> ModelBs { get; set; } = [];
        }

        public class ModelB
        {
            public int Id { get; set; }
            public List<ModelC> ModelCs { get; set; } = [];
        }

        public record ModelC
        {
            public Guid Id { get; set; }
        }
    }

    public class PostgresContainerFixture : IAsyncLifetime
    {
        private readonly IContainer _pgContainer;
        private StreamWriter? _logWriter;
        public string ConnectionString { get; private set; } = string.Empty;
        public string? LogFilePath { get; private set; }

        public PostgresContainerFixture()
        {
            _pgContainer = new ContainerBuilder("postgis/postgis:latest")
                .WithPortBinding(5432, assignRandomHostPort: true)
                .WithEnvironment("POSTGRES_PASSWORD", "postgres")
                .WithEnvironment("POSTGRES_USER", "postgres")
                .WithEnvironment("POSTGRES_DB", "testdb")
                .WithWaitStrategy(Wait.ForUnixContainer().UntilInternalTcpPortIsAvailable(5432))
                .Build();
        }

        public async Task InitializeAsync()
        {
            await _pgContainer.StartAsync();
            var host = _pgContainer.Hostname;
            var port = _pgContainer.GetMappedPublicPort(5432);
            ConnectionString = new NpgsqlConnectionStringBuilder
            {
                Host = host,
                Port = port,
                Username = "postgres",
                Password = "postgres",
                Database = "testdb"
            }.ToString();

            LogFilePath = Path.Combine(Path.GetTempPath(), $"efcore-sql-{Guid.NewGuid():N}.log");
            _logWriter = new StreamWriter(File.Open(LogFilePath, FileMode.Create, FileAccess.Write, FileShare.Read))
            {
                AutoFlush = true
            };
        }

        public async Task DisposeAsync()
        {
            await _pgContainer.StopAsync();
            await _pgContainer.DisposeAsync();
            _logWriter?.Dispose();
        }

        public RegressionDbContext CreateContext()
        {
            var optionsBuilder = new DbContextOptionsBuilder<RegressionDbContext>()
                .UseNpgsql(ConnectionString, a => a.UseNetTopologySuite())
                .EnableSensitiveDataLogging()
                .EnableDetailedErrors();

            if (_logWriter is not null)
            {
                optionsBuilder.LogTo(_logW...

</details>



<!-- START COPILOT CODING AGENT SUFFIX -->

- Fixes dotnet/efcore#37585

<!-- START COPILOT CODING AGENT TIPS -->
---

✨ Let Copilot coding agent [set things up for you](https://github.com/dotnet/efcore/issues/new?title=✨+Set+up+Copilot+instructions&body=Configure%20instructions%20for%20this%20repository%20as%20documented%20in%20%5BBest%20practices%20for%20Copilot%20coding%20agent%20in%20your%20repository%5D%28https://gh.io/copilot-coding-agent-tips%29%2E%0A%0A%3COnboard%20this%20repo%3E&assignees=copilot) — coding agent works faster and does higher quality work when set up for your repo.