On a web application (browser-based) using visual studio 2017 and MySQL for Database and IIS for publishing the web app.
Someone ask me to add an item on a dropdown menu, when I search the pool from where can I add an item on a dropdown menu, I've found out that the pool was on the business logic folder on visual studio and not on the database.
My question is, what is the best practice or most efficient when it comes to updating the dropdown list? Is it best to put it on the controller or on the database?
Thank you in advance.
Best practice would be to put all data in SQL and then use the controller to retrieve the data from SQL to put into the View.