Stored asynchronous Procedure

Question

When trying to run Process asynchronously

public async Task<ActionResult> Index()
    {
        Stopwatch watch = new Stopwatch();
        watch.Start();
        ContentManagement service = new ContentManagement();
        var contentTask = service.MesesAsync();
        var content = await contentTask;
        watch.Stop();                    
        ViewBag.WatchMilliseconds = watch.ElapsedMilliseconds;
        return View("Index");
     }

public async Task<List<SP_MESES_BUSCA_Result>> MesesAsync()
    {
        var ListarMes = await db.SP_MESES_BUSCA().ToList();
        return ListarMes;
    }

Returns the error:

Cannot await 'System.Collections.Generic.List'

Answer 1

The await in his method MesesAsync() is expecting an asynchronous instruction.

Just change the ToList() for ToListAsync() that will work.

Your code will look like this;

public async Task<List<SP_MESES_BUSCA_Result>> MesesAsync()
    {
        var ListarMes = await db.SP_MESES_BUSCA().ToListAsync();
        return ListarMes;
    }