Oracle数据库

Oracle数据库安装下载使用https://blog.csdn.net/xiaomanong123/article/details/108518368
Oracle 数据库中独有的类型 varchar2 比varchar多去尾空格

点击查看代码

using Oracle.ManagedDataAccess.Client;
using System.Data;
using System.Net;

namespace test3
{
    public class Class1
    {
        static void Main(string[] args)
        {
            OracleConnection conn = null;
            try
            {
                conn = OpenConn();
                //这里的查询语句块 会在第一个while 就跳出循环 无论表内有多少行数据 reader.Read()有问题？
                //var cmd = conn.CreateCommand();
                //cmd.CommandText = "select EMP_NAME from employees";
                ////cmd.CommandType = CommandType.Text;
                //var reader = cmd.ExecuteReader();
                //while (reader.Read())
                //{
                //    //Console.WriteLine(reader.GetString(0));
                //    Console.WriteLine(string.Format("AwbPre:{0}", reader["EMP_NAME"]));
                //}

                //插入语句可以正常执行
                string sql = "INSERT INTO employees (emp_id, emp_name) VALUES (:值1, :值2)";
                OracleCommand cmd = new OracleCommand(sql, conn);
                cmd.Parameters.Add("值1", OracleDbType.Int16).Value = 3;
                cmd.Parameters.Add("值2", OracleDbType.Varchar2).Value = "John";
                cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            finally
            {
                CloseConn(conn);
            }
        }

        static OracleConnection OpenConn()
        {
            //使用这种链接oracle数据库方式可以 具体参数参照 tnsnames.ora
            OracleConnection conn = new OracleConnection();
            conn.ConnectionString = "Data Source = (DESCRIPTION = " +
                    "(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))" +
                    "(CONNECT_DATA = (SERVICE_NAME = orcl))); " +
                    "Persist Security Info = True; " +
                    //"User ID = system; Password = Oracle123; ";
                    "User ID = C##user1; Password = user1; ";
            //string conStringUser = "User Id=C##user1" + ";Password=user1" + ";Data Source=" + db + ";";
            conn.Open();
            return conn;
        }
        static void CloseConn(OracleConnection conn)
        {
            if (conn == null) return;

            try
            {
                if (conn.State != ConnectionState.Closed)
                {
                    conn.Close();
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            finally
            {
                conn.Dispose();
            }
        }
    }
}