Required one-to-one Dependents
Required one-to-one Dependents
EF Core allows you to model entity types that can only ever appear on navigation properties of other entity types. These are called owned entity types. The entity containing an owned entity type is its owner.
- In EF Core 3.1, the dependent end of a one-to-one relationship was always considered optional.
- This was most apparent when using owned entities.
Let's consider the following model.
1
public class Customer
2
{
3
public int Id { get; set; }
4
public string Name { get; set; }
5
6
public Address HomeAddress { get; set; }
7
public Address BillingAddress { get; set; }
8
}
9
10
public class Address
11
{
12
public string Street { get; set; }
13
public string City { get; set; }
14
public string State { get; set; }
15
public string Country { get; set; }
16
}
Copied!
Here is the implementation of the context class which contains the configuration.
1
public class EntityContext : DbContext
2
{
3
protected override void OnConfiguring(DbContextOptionsBuilder opBuilder)
4
{
5
opBuilder.UseSqlServer("Data Source=(localdb)\\ProjectsV13;Initial Catalog=PeopleContextDb1;");
6
}
7
8
protected override void OnModelCreating(ModelBuilder modelBuilder)
9
{
10
modelBuilder.Entity<Customer>(b =>
11
{
12
b.OwnsOne(e => e.HomeAddress);
13
14
b.OwnsOne(e => e.BillingAddress,
15
b =>
16
{
17
b.Property(e => e.Street).IsRequired();
18
b.Property(e => e.City).IsRequired();
19
b.Property(e => e.State).IsRequired();
20
});
21
22
});
23
}
24
25
public DbSet<Customer> Customers { get; set; }
26
}
Copied!
When migrations or
EnsureCreated are used to create the database. On SQL Server, it will translate to the following SQL.1
CREATE TABLE [dbo].[Customers] (
2
[Id] INT IDENTITY (1, 1) NOT NULL,
3
[Name] NVARCHAR (MAX) NULL,
4
[HomeAddress_Street] NVARCHAR (MAX) NULL,
5
[HomeAddress_City] NVARCHAR (MAX) NULL,
6
[HomeAddress_State] NVARCHAR (MAX) NULL,
7
[HomeAddress_Country] NVARCHAR (MAX) NULL,
8
[BillingAddress_Street] NVARCHAR (MAX) NULL,
9
[BillingAddress_City] NVARCHAR (MAX) NULL,
10
[BillingAddress_State] NVARCHAR (MAX) NULL,
11
[BillingAddress_Country] NVARCHAR (MAX) NULL,
12
CONSTRAINT [PK_Customers] PRIMARY KEY CLUSTERED ([Id] ASC)
13
);
Copied!
As you can see all the columns are nullable, even though some of the
BillingAddress properties have been configured as required.- When you query for a
Customer, and all the columns for any of the addresses arenull. - EF Core will leave all the properties of that address
null, instead of setting an empty instance of address.
In EF Core 5.0, the
BillingAddress navigation can now be configured as a required dependent.1
protected override void OnModelCreating(ModelBuilder modelBuilder)
2
{
3
modelBuilder.Entity<Customer>(b =>
4
{
5
b.OwnsOne(e => e.HomeAddress);
6
7
b.OwnsOne(e => e.BillingAddress,
8
b =>
9
{
10
b.Property(e => e.Street).IsRequired();
11
b.Property(e => e.City).IsRequired();
12
b.Property(e => e.State).IsRequired();
13
});
14
b.Navigation(e => e.BillingAddress).IsRequired();
15
});
16
}
Copied!
Now when you create migration or call the
EnsureCreated method, you will see that it will now include non-nullable columns for the required properties of the required dependent.1
CREATE TABLE [dbo].[Customers] (
2
[Id] INT IDENTITY (1, 1) NOT NULL,
3
[Name] NVARCHAR (MAX) NULL,
4
[HomeAddress_Street] NVARCHAR (MAX) NULL,
5
[HomeAddress_City] NVARCHAR (MAX) NULL,
6
[HomeAddress_State] NVARCHAR (MAX) NULL,
7
[HomeAddress_Country] NVARCHAR (MAX) NULL,
8
[BillingAddress_Street] NVARCHAR (MAX) NOT NULL,
9
[BillingAddress_City] NVARCHAR (MAX) NOT NULL,
10
[BillingAddress_State] NVARCHAR (MAX) NOT NULL,
11
[BillingAddress_Country] NVARCHAR (MAX) NULL,
12
CONSTRAINT [PK_Customers] PRIMARY KEY CLUSTERED ([Id] ASC)
13
);
Copied!
EF Core will now throw an exception if an attempt is made to save a customer with a null
BillingAddress.Last modified 10mo ago
Copy link
Contents
Required one-to-one Dependents