C#•10mo ago

Entity Framework Foreign Key

What is better? Declaring your foreign keys in your model and declaring it in your modelbuilder (.hasForeignKey) or doing it by only declaring the relationship in your modelbuilder?

3 Replies

HtmlCompiler•10mo ago

i believe modelbuilder is what would conventionally be suggested

Keswiik•10mo ago

There is also a ForeignKey attribute that you can use Means you don't need to configure it in your dbcontext at all

Angius•10mo ago

Personally, I use FKs and nav properties in my models

public class Blogpost
{
    public int Id { get; set; }
    public required string Title { get; set; }
    public User Author { get; set; }
    public int AuthorId { get; set; }
}

public class Blogpost
{
    public int Id { get; set; }
    public required string Title { get; set; }
    public User Author { get; set; }
    public int AuthorId { get; set; }
}

This way I can always construct a Blogpost with a related Author without having to fetch the author first And since it just works by convention, there's no configuration needed Be it with attributes or modelbuilder

Gaming

Programming

Entity Framework Foreign Key