Stored procedure asynchronous

Question

Stored procedure asynchronous

Navigation

#1 by (2 votes)

1

When attempting to execute procedure 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:

Can not await 'System.Collections.Generic.List'

c# asp.net mvc

asked by anonymous 14.06.2016 / 20:25

1 answer

How to create a view that lists the domains in Firebird 2.5? Navigation between Pages

score 2 · Answer 1

The await in your MesesAsync() method is waiting for an asynchronous statement.

Just change the ToList() to 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;
    }