public static async Task<Product> FindProductAsync() { // Create and execute raw SQL query. using (var repository = new ProductRepository(new AdventureWorksContext())) { Product product = await repository.GetDbSet() .SqlQuery("SELECT * FROM Production.Product WHERE ProductID = @p0", 1) .SingleOrDefaultAsync(); return product; } }