Writing One to one relationship using Fluent API

Question

How to write a one-to-one--or-zero relationship using fluent api? Can someone help me out correct what i have written. I am not sure if its correct.

The scenario : One Student Can have one or zero Address.

Student Model

    public int Id{ get; set; }
    public string Name{ get; set; }
    public Address Address{ get; set; }

Address Model

    public int Id { get; set; }
    public string Street{ get; set; }
    public int StudentId { get; set; }

    public Student Student { get; set; }

What I tried:

        builder.HasOne(u => u.Address)
        .WithOne(b => b.Student)
        .HasForeignKey<Address>(b => b.StudentId);

`StudentId` in your **Address Model** should be declared as an int. — vinicius.ras, Dec 26 '18 at 17:45
Your solution btw is perfectly fine. The solution from the accepted answer is also fine, but **not mandatory**. — Ivan Stoev, Dec 26 '18 at 18:27

TanvirArjel · Accepted Answer · 2018-12-26T18:31:03.263

In case of one-to-one--or-zero relationship you don't need additional PrimaryKey along with the ForeignKey in dependent table. Primarykey of the Principle table will also be the PrimaryKey and ForeignKey of the dependent table at the same time.

So write your Address model class as follows:

public class Address
{
   public int StudentId { get; set; } // Here StudentId is the PrimaryKey and ForeignKey at the same time.
   public string Street{ get; set; }

   public Student Student { get; set; }
}

Then in the Fluent API configuration:

public class AddressConfiguration : IEntityTypeConfiguration<Address>
{
    public void Configure(EntityTypeBuilder<Address> builder)
    {
        builder.HasKey(u => u.StudentId)
        builder.HasOne(u => u.Student)
               .WithOne(b => b.Address)
               .HasForeignKey<Address>(b => b.StudentId);
    }
}

OP is not "close to the solution". Both one-to-one with Shared PK (yours) and FK (OPs) are supported by EF Core. — Ivan Stoev, Dec 26 '18 at 18:29

score 0 · Answer 2 · answered Dec 26 '18 at 18:18

0

To configure a one-to-zero-or-one relationship between the Student and Address entities with fluent api you can use HasOptional(s => s.Address) method like

modelBuilder.Entity<Student>()
            .HasOptional(s => s.Address) // Address property is optional in Student entity
            .WithRequired(ad => ad.Student); // Student property is required

answered Dec 26 '18 at 18:18

Llazar

3,167
3
17
24

This is for EF not for EF Core! – TanvirArjel Dec 26 '18 at 18:26

Writing One to one relationship using Fluent API

Student Model

Address Model

2 Answers2