I need to create a dropdown for a type of sports (basketball,football,etc.) with a calendar so when the user choose a sport and a calendar and click on the button search or icon the listView show a list of reservation.
In my case I have two tables in DB using SQL Server and I create a stored procedure with two parameter (ID of type sports , Time) and retur the list of reservation, so the question is:
How to use Entity Framework with this stored procedure and put it in a WEB API Controller (to make a remote function) ?
N.B. : Xamarin Forms and SQL Server and Visual Studio
Many thanks and best regards,