title: Dapper for NET Core: Insert into a table and return id of inserted row
body: <p>I have the following method in my repository. As of now, i believe the int returned is simply one indicating whether or not the operation was successful. I want the int to be the id (which is the single column of the table) to be returned after a successful execution. How do i accomplish this?</p>
  
  <pre><code>    public async Task&lt;int&gt; AddNewGroup()
      {
          using(_connection)
          {
              _connection.Open();
              var id = await _connection.ExecuteAsync("INSERT INTO groups").Single();
          }
      }
  </code></pre>