westdavidr/sequelocity-dotnet-async-fetch-customer.md

Last active May 25, 2016 13:26

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/westdavidr/a273d0391935ef7e63af0ed3e2f9cd57.js"></script>
Save westdavidr/a273d0391935ef7e63af0ed3e2f9cd57 to your computer and use it in GitHub Desktop.

Raw

sequelocity-dotnet-async-fetch-customer.md

Fetch customer asynchronously

public async Task<Customer> GetCustomerById(long id)
{
  var cmd = Sequelocity.GetDatabaseCommand();
  cmd.SetCommandText(@"select top 1 * from dbo.Customer where CustomerId = @CustomerId");
  cmd.AddParameter("@CustomerId", id, DbType.Int64);
  
  return await cmd.ExecuteToObjectAsync<Customer>();
}