Question: how to get dropdown value from database in mvc?
Answer: Firstly, we are creating a table in our database. ... 
After that, select the ADO.NET Entity Data Model and click on "Add" button.
Here, check the college table and in View, we have checked our View with the name schoolname.
And now, add new View.
Now, click on "Add" button. ... 
Compile your code and run it.