将List集合插入到数据库中，C#中的事物实现

SqlConnection conn = new SqlConnection();
        conn.Open();
        SqlTransaction tran = conn.BeginTransaction();

        try
        {
            foreach()
            {
                string sql="";
                SqlCommand cmd=new SqlCommand(sql,conn,tran);

                SqlParameter[] pars=new SqlParameter[]{
                    new SqlParameter("",value),
                    ...
                }

                cmd.Parameters.AddRange(pars);
                cmd.ExecuteNonQuery();                    
            }
            tran.Commit();
        }catch
        {
            tran.Rollback();
        }
        finally
        {
            conn.Close();
        }