Utility methods for connection string handling

ConnectionStringExtension.cs

using System;
using System.Data;
using System.Data.SqlClient;

namespace Plastiline.Core.Utils.Sql {
    public static class ConnectionStringExtension {
        public static void Execute(this string connectionString, Action<IDbConnection> action) {
            using (IDbConnection conn = new SqlConnection(connectionString)) {
                conn.Open();
                action(conn);
            }
        }

        public static void Execute(this string connectionString, Action<IDbConnection, IDbTransaction> action) {
            using (IDbConnection conn = new SqlConnection(connectionString)) {
                conn.Open();
                using (IDbTransaction tx = conn.BeginTransaction()) {
                    try {
                        action(conn, tx);
                        tx.Commit();
                    } catch (Exception) {
                        tx.Rollback();
                        throw;
                    }                    
                }
            }
        }

        public static T Execute<T>(this string connectionString, Func<IDbConnection, T> action) {
            using (IDbConnection conn = new SqlConnection(connectionString)) {
                conn.Open();
                return action(conn);
            }
        }

        public static T Execute<T>(this string connectionString, Func<IDbConnection, IDbTransaction, T> action) {
            using (IDbConnection conn = new SqlConnection(connectionString)) {
                conn.Open();
                using (IDbTransaction tx = conn.BeginTransaction()) {
                    try {
                        T result = action(conn, tx);
                        tx.Commit();
                        return result;
                    } catch (Exception) {
                        tx.Rollback();
                        throw;
                    }
                }
            }
        }
    }
}