Error on entity.HasKey line in specific model

[marcelaopimenta]

Hello Folks!

I generated the database models via Entity Framework scaffolding.

dotnet ef dbcontext scaffold "Server=.;Database=<DataBase>;Trusted_Connection=True;MultipleActiveResultSets=true;TrustServerCertificate=True" Microsoft.EntityFrameworkCore.SqlServer -o Models

I have a key in a table that is between a GUID field and a LONG field (Bigint in Sql Server). It generates the classes.

But when it passes through this point in the generated DbContext File the code it crashes,

modelBuilder.Entity<Order>(entity =>
{
    entity.HasKey(e => new { e.Id, e.OrderId }).HasName("PK_Orders_1");

    entity.Property(e => e.Id).HasDefaultValueSql("(newid())");
    entity.Property(e => e.OrderId).ValueGeneratedOnAdd();
    entity.Property(e => e.Address)
        .HasMaxLength(255)
        .IsUnicode(false);
    entity.Property(e => e.City)
        .HasMaxLength(255)
        .IsUnicode(false);
    entity.Property(e => e.Complement)
        .HasMaxLength(255)
        .IsUnicode(false);
    entity.Property(e => e.Country)
        .HasMaxLength(255)
        .IsUnicode(false);
    entity.Property(e => e.CountryPrefix)
        .HasMaxLength(255)
        .IsUnicode(false);
    entity.Property(e => e.Created).HasColumnType("datetime");
    entity.Property(e => e.Currency)
        .HasMaxLength(3)
        .IsUnicode(false);
    entity.Property(e => e.DocumentId)
        .HasMaxLength(255)
        .IsUnicode(false);
    entity.Property(e => e.Modified).HasColumnType("datetime");
    entity.Property(e => e.Neighborhood)
        .HasMaxLength(255)
        .IsUnicode(false);
    entity.Property(e => e.Number)
        .HasMaxLength(255)
        .IsUnicode(false);
    entity.Property(e => e.ProductGroup)
        .HasMaxLength(50)
        .IsUnicode(false);
    entity.Property(e => e.ReturnProcess).HasColumnType("text");
    entity.Property(e => e.State)
        .HasMaxLength(255)
        .IsUnicode(false);
    entity.Property(e => e.Status)
        .HasMaxLength(50)
        .IsUnicode(false);
    entity.Property(e => e.Type)
        .HasMaxLength(255)
        .IsUnicode(false);
    entity.Property(e => e.VatId)
        .HasMaxLength(255)
        .IsUnicode(false);
    entity.Property(e => e.ZipCode)
        .HasMaxLength(255)
        .IsUnicode(false);

    entity.HasOne(d => d.Customer).WithMany(p => p.Orders)
        .HasForeignKey(d => d.CustomerId)
        .OnDelete(DeleteBehavior.ClientSetNull)
        .HasConstraintName("FK_Orders_Customers");

    entity.HasOne(d => d.PaymentGateway).WithMany(p => p.Orders)
        .HasForeignKey(d => d.PaymentGatewayId)
        .OnDelete(DeleteBehavior.ClientSetNull)
        .HasConstraintName("FK_Orders_PaymentGateways");
});

it doesn't return an error or anything, it just consumes memory until the machine crashes. I imagine it's because of mixing two different types, but I couldn't solve it.

Can you help?

Thanks!

EF Core version: 9.0.0
Database provider: Microsoft.EntityFrameworkCore.SqlServer
Target framework: .NET Core 9.0
Operating system: Windows 11
IDE: Visual Studio 2022 17.12.13

[AndriySvyryd]

@marcelaopimenta This certainly looks like a bug. Can you share a small runnable project that shows the issue?

[marcelaopimenta]

@marcelaopimenta This certainly looks like a bug. Can you share a small runnable project that shows the issue?

Hi Andriy,

I found the cause of the error in the post below on StackOverflow.

https://stackoverflow.com/questions/76668197/ef-core-ends-in-infinite-loop

The problem was that in many-to-many relationships it generated the class with the same name as the property in several cases. So getting into a infinity loop.

I solved it by adding the --data-annotations parameter to the scaffolding command.

Thanks!