ASP Net MVC how to make this async?

Question

I have this database call in my controller:

var addresses = db.Addresses.Where(a=>a.EmployeeId == id).ToList();

It works fine the way it is, but I am having a hard time to make it async. When I do make it async, I am able to select all records in the table or a single record, just fine. However, I can't seem to get multiple records with matching EmployeeId.

"When I do make it async", can you please add the code also? It may be because one employee has multiple Addresses! — Anil
– Anil, Commented Apr 4, 2017 at 5:06
Yes, some Employees do have multiple addresses. So, how do you write an async code to retrieve a list of addresses with matching EmployeeId? — ASvistun
– ASvistun, Commented Apr 4, 2017 at 5:49
As your code seems correct to me and it should works as expected. Further, you can add Addresses and Employee entity definition, sample tables data and your async call code. — Anil
– Anil, Commented Apr 4, 2017 at 6:23

ASvistun · Accepted Answer · 2017-04-04 06:23:06Z

2

I found the solution to my own question.

var addresses = db.Addresses.Where(a=>a.EmployeeId == id).ToList();

To make the above call asynchronous I changed it to:

var addresses = await db.Addresses.Where(a=>a.EmployeeId == id).ToListAsync();

The entire method will look like following:

  public async Task<ActionResult> FindAddress(int? id)
    {
        if(id == null)
        {
            return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
        }
        var addresses = await db.Addresses.Where(a=>a.EmployeeId == id).ToListAsync();

        if (addresses == null)
            return HttpNotFound();

        return View(addresses);

    }

answered Apr 4, 2017 at 6:23

ASvistun

414 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

ASP Net MVC how to make this async?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related