stored procedure SQl

patrickmzpatrickmz USMember ✭✭

January 24 in General
Dear All,

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?

Please advice

Best regards,

Tagged: General

Sign In or Register to comment.