public static async Task <dynamic> GetDPDCityAsync(string cityName)
{
using (var ctx = new webapionlineContext())
{
var top10cities = await ctx.DpdCities.FromSqlRaw($"EXEC [dbo].[GetDPDCitiesTop10] @text = N'{cityName}'").ToListAsync();
return(top10cities);
}
}
public RatesController(webapionlineContext context, IRatesRepository ratesRepository)
{
_context = context;
_ratesRepository = ratesRepository;
}