Creating dynamic menu from Sql Server database in asp.net core

(1) I have created and executed a query to retrieve values from a table's "key" column.
(2) I have seen examples of how to create a menu of selections in asp, using a predefined list of values.

How can I combine the two tasks, so that the list from which to select stays up to date(so that the list grows as new records are added to the table)?