Redundant FK constraint when using TPT inheritance and owned types

[kroatti]

I'm using table per type inheritance model and owned types in the same class hierarchy.
When I generate the migration an extra foreign key constraint will be added to the derived type.
Executing the update database returns an error:

'ORA-02274: duplicate referential constraint specifications'

The model:

public abstract class BaseType
{
   public Guid Id { get; set; }
}

public class DerivedType : BaseType
{
   public OwnedType Prop1 { get; set; }
}

public class OwnedType 
{
   public int Prop2 { get; set; }
}

Model configuration:

modelBuilder.Entity<BaseType>()
	.ToTable("BASETYPES");
            
modelBuilder.Entity<DerivedType>()
	.ToTable("DERIVEDTYPES")
	.OwnsOne(e => e.Prop1);

DbContext builder:

builder.Services.AddOracle<OraDb>("CONNSTR", null,
    optionsBuilder => optionsBuilder.UseUpperCaseNamingConvention());

Generated migration:

migrationBuilder.CreateTable(
	name: "BASETYPES",
	columns: table => new
	{
		ID = table.Column<Guid>(type: "RAW(16)", nullable: false)
	},
	constraints: table =>
	{
		table.PrimaryKey("PK_BASETYPES", x => x.ID);
	});

migrationBuilder.CreateTable(
	name: "DERIVEDTYPES",
	columns: table => new
	{
		ID = table.Column<Guid>(type: "RAW(16)", nullable: false),
		PROP1_PROP2 = table.Column<int>(type: "NUMBER(10)", nullable: true)
	},
	constraints: table =>
	{
		table.PrimaryKey("PK_DERIVEDTYPES", x => x.ID);
		table.ForeignKey(
			name: "FK_DERIVEDTYPES_BASETYPES_ID",
			column: x => x.ID,
			principalTable: "BASETYPES",
			principalColumn: "ID",
			onDelete: ReferentialAction.Cascade);
		table.ForeignKey(
			name: "FK_DERIVEDTYPES_DERIVEDTYPES_ID",
			column: x => x.ID,
			principalTable: "BASETYPES",
			principalColumn: "ID",
			onDelete: ReferentialAction.Cascade);
	});

FK_DERIVEDTYPES_DERIVEDTYPES_ID is redundant and its name is incorrect. When I don't use UseUpperCaseNamingConvention() or UseSnakeCaseNamingConvention() the migration is generated properly.

Used packages:

• EFCore.NamingConventions Version="8.0.3"
• Microsoft.EntityFrameworkCore Version="8.0.3"
• Oracle.EntityFrameworkCore Version="8.21.121"

[vasicvuk]

I have the same issue with SQL Server i created a reproduction here:

https://github.com/vasicvuk/ef-core-issue-33591

I also reported this to the EF community since I didn't know where the issue is:

dotnet/efcore#33591

Maybe @roji can help with this one

[AndriySvyryd]

Duplicate of #191

[4broadcast]

Hi, just hit same issue with a TPT hierarchy & UseSnakeCaseNamingConvention(), The migration will not generate the redundant constraints with default EF Core casing. Also on 8.0.3.