title: How to rollback a transaction using dapper
body: <p>I have this: </p>
  
  <pre><code>            using (var con= new SqlConnection(ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString))
              {
                  try
                  {
                    // many transactions
                  }
                  catch (Exception e)
                  {
                      con.BeginTransaction().Rollback();
                  }
              }
  </code></pre>
  
  <p>Will this work is my question.. I know another method is to make a transaction then open it then rollback.</p>