How to pull data from SQL table?

Question

JavaScript

I am writing WEB.API using EF. There are three tables: The first (Settlement) where I take the city, the second (MedOrganization) where the ID of the selected city from the first and the ID of the organization that is in this city are stored. And the third table (Organization) where I take the name of the organization from the city I chose. I chose a city, found out the ID of the organization that is in this city BUT I don’t know how to display these organizations in the DropDownList. Tell me please!

Photo of the script itself

Answer 1

the second (MedOrganization) where the IDs of the selected city are stored

WHERE (by area code).