CODEWITHSUNDEEP
c#entity-frameworkasync-awaitasp.net-web-api2
Daina Hodges
Daina Hodges

Reputation: 853

Make IEnumerable Entity Framework result async Web API

I have a Web API (not .core web API) method uses Entity Framework to return some records from the database. The result is IEnumerable Model and I would like to modify it to use Async/Await technique to improve the performance, but I don't know how! I tried to use ToListAsync but it did not work.

My Web API method code

[HttpGet]
[Route("api/student/{id}/")]
public IEnumerable<Student> Get(int id)
{            
    try
    {
        var db = new DBEntities();
        return db.GetStudentDetails(id);
    }
    catch(Exception exception)
    {
        _logger.Error(exception.Message);
        throw new HttpResponseException(HttpStatusCode.ExpectationFailed);
    }
}

My Entity Framework function code:

public virtual ObjectResult<Student> GetStudentDetails(int id)
{
     var idParameter = id.HasValue ?
            new ObjectParameter("id", id) :
            new ObjectParameter("id", typeof(int));

        return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Student>("sp_get_student_details", idParameter);
 }

Thanks in advance.

Upvotes: 0

Views: 549

Answers (1)

Thomas Clague
Thomas Clague

Reputation: 537

This should do the trick

public virtual async Task<ObjectResult<Student>> GetStudentDetails(int id)
{
      var idParameter = id.HasValue ?
      new ObjectParameter("id", id) :
      new ObjectParameter("id", typeof(int));

      return await ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<Student>("sp_get_student_details", idParameter);
}

Upvotes: -3

Related Questions