C# 数据访问类SQLHelper

分享最近学习到的C#中SQL数据通用访问类，希望一起进步（来自于视频学习中的代码，如有想法，欢迎讨论）：

/// <summary>
/// 通用数据访问类
/// </summary>
public class SQLHelper
{
    private static string connString = ConfigurationManager.ConnectionStrings["connString"].ToString();
    /// <summary>
    /// 执行增、删、改方法
    /// </summary>
    /// <param name="sql"></param>
    /// <returns></returns>
    public static int Update(string sql)
    {
        SqlConnection conn = new SqlConnection(connString);
        SqlCommand cmd = new SqlCommand(sql, conn);
        try
        {
            conn.Open();
            return cmd.ExecuteNonQuery();
        }
        catch (Exception ex)
        {
            //将错误信息写入日志...

            throw ex;
        }
        finally
        {
            conn.Close();
        }
    }
    /// <summary>
    /// 执行单一结果（select）
    /// </summary>
    /// <param name="sql"></param>
    /// <returns></returns>
    public static object GetSingleResult(string sql)
    {
        SqlConnection conn = new SqlConnection(connString);
        SqlCommand cmd = new SqlCommand(sql, conn);
        try
        {
            conn.Open();
            return cmd.ExecuteScalar();
        }
        catch (Exception ex)
        {
            //将错误信息写入日志...

            throw ex;
        }
        finally
        {
            conn.Close();
        }
    }
    /// <summary>
    /// 执行结果集查询
    /// </summary>
    /// <param name="sql"></param>
    /// <returns></returns>
    public static SqlDataReader GetReader(string sql)
    {
        SqlConnection conn = new SqlConnection(connString);
        SqlCommand cmd = new SqlCommand(sql, conn);
        try
        {
            conn.Open();
            return cmd.ExecuteReader(CommandBehavior.CloseConnection);
        }
        catch (Exception ex)
        {
            conn.Close();
            //将错误信息写入日志...

            throw ex;
        }
    }
    /// <summary>
    /// 执行查询返回一个DataSet
    /// </summary>
    /// <param name="sql"></param>
    /// <returns></returns>
    public static DataSet GetDataSet(string sql)
    {
        SqlConnection conn = new SqlConnection(connString);
        SqlCommand cmd = new SqlCommand(sql, conn);
        SqlDataAdapter da = new SqlDataAdapter(cmd);//创建数据适配器对象
        DataSet ds = new DataSet();//创建一个内存数据集
        try
        {
            conn.Open();
            da.Fill(ds);//使用数据适配器填充数据集
            return ds;
        }
        catch (Exception ex)
        {
            //将错误信息写入日志...

            throw ex;
        }
        finally
        {
            conn.Close();
        }
    }
}