SqlConnection建立的一种方法

ConnectionStringSettings setting = new ConnectionStringSettings();
        setting = ConfigurationManager.ConnectionStrings["Codematic"];
        DbProviderFactory facotory = DbProviderFactories.GetFactory(setting.ProviderName);
        IDbConnection connection = facotory.CreateConnection();
        connection.ConnectionString = setting.ConnectionString;
        connection.Open();
        SqlTransaction st = connection.BeginTransaction();
        //Execute more sql
        st.Commit();
        connection.Close();