Entity Framework 6 - how to convert this line to async?

Question

I am wondering how do I change this statement to be async?

    var findBarCode = context.Barcodes
        .Where(x => x.Code == barcode)
        .Select(x => x.Product).FirstOrDefault();

I don't see like any async where statement I can use.

Answer 1

There's an extension method called FirstOrDefaultAsync in System.Data.Entity:

using System.Data.Entity;
...
var findBarCode = await context.Barcodes
    .Where(x => x.Code == barcode)
    .Select(x => x.Product).FirstOrDefaultAsync();

This requires Entity Framework 6.0.