I want to create a dropdown that take from SQL Server DB, type of sports is a table : Football, BasketBall, etc but this dropdown change this type of sports in case of another table named gym.
we have gym1 --> type of sports --> Football, BasketBall
gym2 --> type of sports --> Football only
Usually I create a stored procedure named: TypeSportsByGymId, the question is:
How to use this stored procedure with WebAPI 2 and Controller and HTTPClient or there are another solutions or a demo or a links ?
Another question, if it possible with stored procedure, the same result with one or many parameters?