title: Getting the primary key for an inserted value
body: <p>I have a simple table with 2 columns - name and the primary key, id. When I insert a value, I wish to be able to retrieve the value straight away in my code.</p>
  
  <p>So I have : </p>
  
  <pre><code>db.Execute("INSERT INTO table(name) VALUES (@0)",name);
  </code></pre>
  
  <p>The id column is not automatically populated and the row is stored.</p>
  
  <p>So how can I <code>db.Query();</code> for this value when the name is not unique? Is this possible?</p>
  
  <p>An interesting problem, I think :)</p>