ASP.NET CORE MVC Lookup showing keys instead of names

Question

I used the below article and scaffolded db first using postgres.

In this case for one page it geenerated keys rather than names .

See the screenshot I updated the lookup fields to names in Index page but don't know how to update for other pages like create as it it still shows keys

https://medium.com/@ankushjain358/entity-framework-core-with-postgresql-database-first-ab03bf1079c4

Capturepostgres2.JPGCapturepostgres1.JPG

Here is postgres sql create scripts

postgrestb.txt

https://github.com/KalyanAllam/SISPostgres

Here is the mvc code generated using sql server

https://github.com/KalyanAllam/StudentInformationSystemscript SQL.txt

Answer 1

I changed the value , initial it is key, key(studentid,studentid) I changed to key value (studentid,lastname)and it worked

  ViewData["Studentid"] = new SelectList(_context.Students.Where(e => e.Studentid == sid), "Studentid", "Lastname", enrollment.Studentid);