C#•10mo ago

❔ Setting up a One-To-Many-Relationship in EntityFramework Core

namespace GetOut.Models;

public class Provider(string slug, string name, string? description)
{
    public Guid Id { get; set; } = Guid.NewGuid();

    public DateTime CreatedAt { get; set; } = DateTime.Now;
    public DateTime UpdatedAt { get; set; } = DateTime.Now;
    public DateTime? DeletedAt { get; set; }

    public string Slug { get; set; } = slug;
    public string Name { get; set; } = name;
    public string? Description { get; set; } = description;
    
    public bool Verified { get; set; } = false;

    public City City { get; set; }
    public ICollection<Event>? Events { get; set; }
}

namespace GetOut.Models;

public class Provider(string slug, string name, string? description)
{
    public Guid Id { get; set; } = Guid.NewGuid();

    public DateTime CreatedAt { get; set; } = DateTime.Now;
    public DateTime UpdatedAt { get; set; } = DateTime.Now;
    public DateTime? DeletedAt { get; set; }

    public string Slug { get; set; } = slug;
    public string Name { get; set; } = name;
    public string? Description { get; set; } = description;
    
    public bool Verified { get; set; } = false;

    public City City { get; set; }
    public ICollection<Event>? Events { get; set; }
}

I want to establish a relation between Providers and City. 😉 Thanks.

11 Replies

Timo Martinson•10mo ago

what do I have to do?

Angius•10mo ago

Just reference one from the other

metomorphose•10mo ago

Is it one provider per city or vise versa?

Angius•10mo ago

class Foo
{
    public int Id { get; set; }
    public Bar Bar { get; set; }
    public int BarId { get; set; } 
}

class Bar
{
    public int Id { get; set; }
    public List<Foo> Foos { get; set; }
}

class Foo
{
    public int Id { get; set; }
    public Bar Bar { get; set; }
    public int BarId { get; set; } 
}

class Bar
{
    public int Id { get; set; }
    public List<Foo> Foos { get; set; }
}

metomorphose•10mo ago

It should look pretty similar to the Events property

Angius•10mo ago

Here's a simple one-to-many

Timo Martinson•10mo ago

one city has many providers

Angius•10mo ago

Then add a list of providers to the city And a city to a provider

Timo Martinson•10mo ago

how does it work ?

Angius•10mo ago

What do you mean? It just does EF picks up on the relationship you created, generates the appropriate SQL to execute, and executes it when you apply the migration

Accord•10mo ago

Was this issue resolved? If so, run /close - otherwise I will mark this as stale and this post will be archived until there is new activity.

Gaming

Programming

❔ Setting up a One-To-Many-Relationship in EntityFramework Core