Razor Page SelectList not populating when using ViewModel

[kmichelle7601]

Hi,
I feel like I'm doing exactly what the tutorial is saying in https://docs.microsoft.com/en-us/aspnet/core/data/ef-rp/update-related-data?view=aspnetcore-6.0 but my query to populate my select list is not returning any values. I am wondering if it's because I don't have foreign key relations on the database I inherited.

I see this in the Contuso sample but not sure if this is because the database is being created within the sample tutorial. Do I need this in my project too? Is this even related to my possible issue?

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity().ToTable(nameof(Course))
.HasMany(c => c.Instructors)
.WithMany(i => i.Courses);
modelBuilder.Entity().ToTable(nameof(Student));
modelBuilder.Entity().ToTable(nameof(Instructor));
}

[dhanur350]

Exactly, where is your foreign key in this code, without that you cannot get values return in your select list

[kmichelle7601]

The database that EF scaffolded doesn't have foreign keys. Can I add the foreign keys in the model after the scaffold?

[dhanur350]

Yes you can by using core command, dotnet ef migrations add key