1、  Oralce官網 下載 安裝   ODTforVS2015_121025    重啟VS

2、項目引用 Oracle.ManagedDataaccess.dll

3、數據庫連接字符串： user id=xxxx;passWord=xxxx;data source=192.168.0.xxx:1521/orcl(數據庫名)

4、使用方法：

 OracleConnection con = new OracleConnection();                 con.ConnectionString = "user id=his3;password=his3;data source=192.168.1.237/ORCL";                 con.Open();                       OracleCommand cmd = new OracleCommand();                 cmd.CommandType = System.Data.CommandType.Text;                 cmd.CommandText = "select * from gy_yonghuxx";                 cmd.Connection = con;                      OracleDataAdapter da = new OracleDataAdapter();                da.SelectCommand = cmd;                DataSet ds = new DataSet();                da.Fill(ds);                     con.Close();                da.Dispose();                cmd.Dispose();                con.Dispose(); 工具類：
using System;using System.Collections.Generic;using System.Linq;using System.Text;using Oracle.ManagedDataAccess.Client;using System.Configuration;using System.Data;using System.Reflection;namespace NCToOA{    public class OracleHelper    {        #region 變量          /// <summary>          /// 數據庫連接對象          /// </summary>          PRivate static OracleConnection _con = null;        public static string constr = ConfigurationManager.ConnectionStrings["OracleStr"].ToString();        #endregion        #region 屬性          /// <summary>          /// 獲取或設置數據庫連接對象          /// </summary>          public static OracleConnection Con        {            get            {                if (OracleHelper._con == null)                {                    OracleHelper._con = new OracleConnection();                }                if (OracleHelper._con.ConnectionString == "")                {                    OracleHelper._con.ConnectionString = OracleHelper.constr;                }                return OracleHelper._con;            }            set            {                OracleHelper._con = value;            }        }        #endregion        #region 方法          #region 執行返回一行一列的數據庫操作          /// <summary>          /// 執行返回一行一列的數據庫操作          /// </summary>          /// <param name="commandText">Oracle語句或存儲過程名</param>          /// <param name="commandType">Oracle命令類型</param>          /// <param name="param">Oracle命令參數數組</param>          /// <returns>第一行第一列的記錄</returns>          public static int ExecuteScalar(string commandText, CommandType commandType, params OracleParameter[] param)        {            int count = 0;            using (OracleHelper.Con)            {                using (OracleCommand cmd = new OracleCommand(commandText, OracleHelper.Con))                {                    //try                    //{                        cmd.CommandType = commandType;                        if (param != null)                        {                            cmd.Parameters.AddRange(param);                        }                        OracleHelper.Con.Open();                        count = Convert.ToInt32(cmd.ExecuteScalar());                    //}                    //catch (Exception ex)                    //{                    //    count = 0;                    //}                }            }            return count;        }        #endregion        #region 執行不查詢的數據庫操作          /// <summary>          /// 執行不查詢的數據庫操作          /// </summary>          /// <param name="commandText">Oracle語句或存儲過程名</param>          /// <param name="commandType">Oracle命令類型</param>          /// <param name="param">Oracle命令參數數組</param>          /// <returns>受影響的行數</returns>          public static int ExecuteNonQuery(string commandText, CommandType commandType, params OracleParameter[] param)        {            int result = 0;            using (OracleHelper.Con)            {                using (OracleCommand cmd = new OracleCommand(commandText, OracleHelper.Con))                {                    try                    {                        cmd.CommandType = commandType;                        if (param != null)                        {                            cmd.Parameters.AddRange(param);                        }                        OracleHelper.Con.Open();                        result = cmd.ExecuteNonQuery();                    }                    catch (Exception ex)                    {                        result = 0;                    }                }            }            return result;        }        #endregion        #region 執行返回一條記錄的泛型對象          /// <summary>          /// 執行返回一條記錄的泛型對象          /// </summary>          /// <typeparam name="T">泛型類型</typeparam>          /// <param name="reader">只進只讀對象</param>          /// <returns>泛型對象</returns>          private static T ExecuteDataReader<T>(IDataReader reader)        {            T obj = default(T);            try            {                Type type = typeof(T);                obj = (T)Activator.CreateInstance(type);//從當前程序集里面通過反射的方式創建指定類型的對象                     //obj = (T)Assembly.Load(OracleHelper._assemblyName).CreateInstance(OracleHelper._assemblyName + "." + type.Name);//從另一個程序集里面通過反射的方式創建指定類型的對象                   PropertyInfo[] propertyInfos = type.GetProperties();//獲取指定類型里面的所有屬性                  foreach (PropertyInfo propertyInfo in propertyInfos)                {                    for (int i = 0; i < reader.FieldCount; i++)                    {                        string fieldName = reader.GetName(i);                        if (fieldName.ToLower() == propertyInfo.Name.ToLower())                        {                            object val = reader[propertyInfo.Name];//讀取表中某一條記錄里面的某一列                              if (val != null && val != DBNull.Value)                            {                                if (val.GetType() == typeof(decimal) || val.GetType() == typeof(int))                                {                                    propertyInfo.SetValue(obj, Convert.ToInt32(val), null);                                }                                else if (val.GetType() == typeof(DateTime))                                {                                    propertyInfo.SetValue(obj, Convert.ToDateTime(val), null);                                }                                else if (val.GetType() == typeof(string))                                {                                    propertyInfo.SetValue(obj, Convert.ToString(val), null);                                }                            }                            break;                        }                    }                }            }            catch (Exception ex)            {                throw;            }            return obj;        }        #endregion        #region 執行返回一條記錄的泛型對象          /// <summary>          /// 執行返回一條記錄的泛型對象          /// </summary>          /// <typeparam name="T">泛型類型</typeparam>          /// <param name="commandText">Oracle語句或存儲過程名</param>          /// <param name="commandType">Oracle命令類型</param>          /// <param name="param">Oracle命令參數數組</param>          /// <returns>實體對象</returns>          public static T ExecuteEntity<T>(string commandText, CommandType commandType, params OracleParameter[] param)        {            T obj = default(T);            using (OracleHelper.Con)            {                using (OracleCommand cmd = new OracleCommand(commandText, OracleHelper.Con))                {                    cmd.CommandType = commandType;                    cmd.Parameters.AddRange(param);                    OracleHelper.Con.Open();                    OracleDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);                    while (reader.Read())                    {                        obj = OracleHelper.ExecuteDataReader<T>(reader);                    }                }            }            return obj;        }        #endregion        #region 執行返回多條記錄的泛型集合對象          /// <summary>          /// 執行返回多條記錄的泛型集合對象          /// </summary>          /// <typeparam name="T">泛型類型</typeparam>          /// <param name="commandText">Oracle語句或存儲過程名</param>          /// <param name="commandType">Oracle命令類型</param>          /// <param name="param">Oracle命令參數數組</param>          /// <returns>泛型集合對象</returns>          public static List<T> ExecuteList<T>(string commandText, CommandType commandType, params OracleParameter[] param)        {            List<T> list = new List<T>();            using (OracleHelper.Con)            {                using (OracleCommand cmd = new OracleCommand(commandText, OracleHelper.Con))                {                    try                    {                        cmd.CommandType = commandType;                        if (param != null)                        {                            cmd.Parameters.AddRange(param);                        }                        OracleHelper.Con.Open();                        OracleDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);                        while (reader.Read())                        {                            T obj = OracleHelper.ExecuteDataReader<T>(reader);                            list.Add(obj);                        }                    }                    catch (Exception ex)                    {                        list = null;                    }                }            }            return list;        }        #endregion        #endregion    }}