Entity Framework Async Query

Entity Framework async query

The purpose of this example is explain how make async query using Entity Framework.


This example uses .NET Framework 4.5 (or highter) and Entity Framework 6.0 (or highter). The async and await keywords were introduced in .NET 4.5.

Defining the model

The model describes a product repository. The code below defines two entities : Product and ProductCategory. The repository class needs to extend DbContext and uses DbSet to implement the collection of objects.

Make async query

The code below describes the async query: while the statement await db.SaveChangesAync() write the new product category, main method is continuing the execution.
Since all other execution has completed, the thread will just halt on the task.Wait(). At the end, the QueryAsync() method write results to Console.


Entity Framework query result

Entity Framework query result