c#连接Oracle数据库 ODAC

在Oracle官网下载安装ODAChttp://www.oracle.com/technetwork/topics/dotnet/downloads/index.html

安装完成后在安装目录下找到Oracle.ManagedDataAccess.dll

（我的是在这个目录下C:\Program Files (x86)\Oracle Developer Tools for VS2017\odp.net\managed\common）

将Oracle.ManagedDataAccess.dll复制到项目下，并添加引用

添加命名空间：

using Oracle.ManagedDataAccess.Client;

using Oracle.ManagedDataAccess.Types;

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using Oracle.ManagedDataAccess.Client;
using Oracle.ManagedDataAccess.Types;




namespace CountMoney
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
          
            string connStr = "User Id=sunyue;Password=ayou;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=DESKTOP-252KE0G)(PORT=1521)))" +
                " (CONNECT_DATA =(SERVER = DEDICATED) (SERVICE_NAME = XE)))";
            OracleConnection conn = new OracleConnection();
            try
            {
                conn.ConnectionString = connStr;
                conn.Open();
                MessageBox.Show(conn.State.ToString());
                OracleCommand cmd = conn.CreateCommand();
                cmd.CommandText="select *from student  ";
                OracleDataReader ord = cmd.ExecuteReader();
                while(ord.Read())
                {
                    MessageBox.Show(ord.GetOracleString(1).ToString());
                    
                }
            }
            catch (Exception ex)
            {
               MessageBox.Show(ex.Message.ToString());
            }
            finally
            {
                conn.Close();
            }

        }
    }
}

其中

string connStr = "User Id=sunyue;Password=ayou;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=DESKTOP-252KE0G)(PORT=1521)))" +
                " (CONNECT_DATA =(SERVER = DEDICATED) (SERVICE_NAME = XE)))";

这句不知道怎么填的话，可以参考tnsnames.ora文件，以及自己的连接名之类的啦！