run with dapper (and NHibernate session and ransaction)

dapperRun.cs

        public void RunInSql(Action<IDbConnection, IDbTransaction> action)
        {
            using (var connection = session.Connection)
            {
                using (var transaction = GetTransaction(session))
                {
                    try
                    {
                        action(connection, transaction);
                        transaction.Commit();
                    }
                    catch (Exception ex)
                    {
                        transaction.Rollback();
                        throw;
                    }
                }
            }
        }

dapperRun_usage.cs

DapperRun.RunInSql((conn, trans) => {
  var id = conn.ExecuteScalar<int>("select top 1 new_id from mytable", trans);
  conn.ExecuteScalar("insert into mytable", trans);
})