TemporalAll fails with JSON columns

[pekspro]

If you have a JSON column in a temporal table and calls TemporalAll(), an System.InvalidOperationException is thrown with the message:

 Temporal query is trying to use navigation to an entity 'BlogDetails' which itself 
 doesn't map to temporal table. Either map the entity to temporal table or use 
 join manually to access it.

This is very similar to #29156.

Full sample

using Microsoft.EntityFrameworkCore;

using (var db = new BloggingContext())
{
    await db.Database.EnsureDeletedAsync();
    await db.Database.EnsureCreatedAsync();

    var blog = new Blog { Url = "http://example.com", Details = new BlogDetails() { Title = "Title" } };
    db.Add(blog);
    db.SaveChanges();

    var blogs = db.Blogs.ToList();

    // This thwrows: System.InvalidOperationException:
    // Temporal query is trying to use navigation to an entity 'BlogDetails' which itself doesn't map to
    // temporal table. Either map the entity to temporal table or use join manually to access it.
    var blogsHistory = db.Blogs.TemporalAll().ToList();
}

public class BloggingContext : DbContext
{
    public DbSet<Blog> Blogs { get; set; }
    
    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder
            .UseSqlServer("Server=(localdb)\\mssqllocaldb;Database=ABlogDatabase;Trusted_Connection=True;")
            .LogTo(Console.WriteLine, new[] { DbLoggerCategory.Database.Command.Name, DbLoggerCategory.Database.Transaction.Name })
            ;
    }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        base.OnModelCreating(modelBuilder);

        modelBuilder
            .Entity<Blog>(entity =>
            {
                entity.ToTable("Blog", b => b.IsTemporal());

                entity.OwnsOne(e => e.Details, ownedNavigationBuilder =>
                {
                    ownedNavigationBuilder.ToJson();
                });
            });
    }
}

public class Blog
{
    public int BlogId { get; set; }
    public required string Url { get; set; }
    public BlogDetails Details { get; set; } = null!;
}

public class BlogDetails
{
    public string Title { get; set; } = null!;
}

Include provider and version information

EF Core version: 7.0.4
Database provider: Microsoft.EntityFrameworkCore.SqlServer
Target framework: .NET 7.0
Operating system: Windows 11
IDE: Visual Studio 2022 17.5

[maumar]

We have some validation making sure that the navigations coming from the entity mapped to temporal table can be expanded. However, we should circumvent all those checks for JSON entities, since those are always mapped to the same table as the owner (so they are always in sync) - we should also allow operations other than AsOf if all navigations are JSON based.

[iivmok]

Temporary workaround:

const string sqlServerIsTemporalAnnotation = "SqlServer:IsTemporal";
var entityType = (RuntimeEntityType)context.Model.FindRuntimeEntityType(typeof(YourJsonFieldType))!;

entityType.SetAnnotation(sqlServerIsTemporalAnnotation, true);

var data = await context.[Your query here];

entityType.RemoveAnnotation(sqlServerIsTemporalAnnotation);