How to properly set up relationships in Entity Framework Core?

Question

.NET

There are two models:

[Table("params")]
    public class ParamModel {
        [Key]
        [Column("id")]
        public int Id {
            get; set;
        }
        [Column("name")]
        public string Name {
            get; set;
        }
        [Column("value")]
        public string Value {
            get; set;
        }
        [Column("algorithm")]
        public int AlgorithmID {
            get; set;
        }
        public AlgorithmModel Algorithm {
            get; set;
        }
    }
    [Table("algorithms")]
    public class AlgorithmModel {
        [Key]
        [Column("id")]
        public int Id {
            get; set;
        }
        [Column("name")]
        public string Name {
            get; set;
        }
        public List<ParamModel> Params {
            get; set;
        }
    }

The links are built like this:

modelBuilder.Entity<AlgorithmModel>().HasMany(p => p.Params).WithOne(p => p.Algorithm).
                HasForeignKey(p => p.AlgorithmID);
            modelBuilder.Entity<ParamModel>().HasOne(p => p.Algorithm).WithMany(p => p.Params).
                HasForeignKey(p=>p.AlgorithmID);

But when I read the Params property from the AlgorithmModel, I get null. (database full) How to fix?

Answer 1

Somehow it's not very nicely done. The [Column("name")] attributes are redundant. I understand that one algorithm has several parameters, so I would add the ForignKey attribute to the AlgorithmID and the virtual modifier to the List list