await using var context = new MainDbContext();

// The following prints True without the compiled model, False with
var tagsProperty = context.Model.GetEntityTypes().Single().FindProperty(nameof(Article.Tags));
Console.WriteLine($"IsPrimitiveCollection={tagsProperty.IsPrimitiveCollection}");

await context.Database.EnsureDeletedAsync();
await context.Database.EnsureCreatedAsync();

// Fails with the compiled model
_ = await context.Articles.Where(p => p.Tags.Any()).ToListAsync();

public class MainDbContext : DbContext
{
    public DbSet<Article> Articles { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        => optionsBuilder
            .UseSqlServer("Server=localhost;Database=test;User=SA;Password=Abcd5678;Connect Timeout=60;ConnectRetryCount=0;Encrypt=false")
            .LogTo(Console.WriteLine, LogLevel.Information)
            .EnableSensitiveDataLogging();
}

public class Article
{
    public string Id { get; set; } = null!;
    public string[] Tags { get; set; } = [];
}