The Fluent API WithMany Method

The Entity Framework Core Fluent API WithMany method is used to configure the many side of a one-to-many relationship.

The WithMany method must be used in conjunction with the HasOne method to fully configure a valid relationship, adhering to the Has/With pattern for relationship configuration.

The following model represents companies and employees with an inverse navigation property defined in the dependent entity (Employee):

One-To-Many Example

public class Company
{
    public int Id { get; set; }
    public string Name { get; set; }
    public ICollection<Employee> Employees { get; set; }
}

public class Employee
{
    public int Id { get; set; }
    public string Name { get; set; }
    public Company Company { get; set; }
}

A company has many employees, each with one company. That relationship is represented as follows:

protected override void OnModelCreating(Modelbuilder modelBuilder)
{
    modelBuilder.Entity<Employee>()
        .HasOne(e => e.Company);
        .WithMany(c => c.Employees)
        
}

Data Annotations

Relationships can be defined with the ForeignKey and InverseProperty attributes.

Further Reading

Last updated: 27/02/2018 13:23:21

© 2018 - Learn Entity Framework Core.
All rights reserved.