title: Invalid operation. The Connection is closed error when using Petapoco FetchAsync
body: <p>I am using the petapoco.compiled v6.0.441 in my MVC project. This is working fine for all the synchronous operations. But when I try to use the FetchAsync&lt;> it is throwing an error 'Invalid Operation. The Connection is closed'. </p>
  
  <pre><code>//controller
  public async Task&lt;ActionResult&gt; Index()
  {
       IEnumerable&lt;UserEntity&gt; users= await userService.GetAllAsync();
       return View(users);
  }
  
  //user service
  public Task&lt;List&lt;UserEntity&gt;&gt; GetAllAsync()
  {
      return userrepository.GetAllAsync();
  }
  
  //user repo - trial 1
  public Task&lt;List&lt;UserEntity&gt;&gt; GetAllAsync()
  {
      var res = db.FetchAsync&lt;UserEntity&gt;("select query");
  
      return res;
  }
  
  also tried
  //user repo - trial 2
  public async Task&lt;List&lt;UserEntity&gt;&gt; GetAllAsync()
  {
      var res = await db.FetchAsync&lt;UserEntity&gt;("select query");
  
      return res;
  }
  </code></pre>
  
  <p>Not sure whether the above implementation is correct or I missed something, Do I have to configure petapoco to support Async? </p>
  
  <p>Thanks,
  Narendra</p>