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;
}
}
