using (OracleConnection con = new OracleConnection("connectionstring"))
            {
                con.Open();

                using (TransactionScope scope = new TransactionScope())
                {
                    OracleCommand cmd = new OracleCommand("Insert Into Producer(ProducerId,Name,NickName,Telephone,Nationality) Values(:ProducerId,:Name,:NickName,:Telephone,:Nationality)", con);
                    cmd.Parameters.Add(new OracleParameter("ProducerId", Guid.NewGuid()));
                    cmd.Parameters.Add(new OracleParameter("Name", "Test for Insert"));
                    cmd.Parameters.Add(new OracleParameter("NickName", "Test"));
                    cmd.Parameters.Add(new OracleParameter("Telephone", "111111"));
                    cmd.Parameters.Add(new OracleParameter("Nationality", "China"));

                    cmd.ExecuteNonQuery();
                    scope.Complete();
                }

                con.Close();
            }