c#链接oracle

下载并添加引用Oracle.ManagedDataAccess.dll

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Oracle.ManagedDataAccess.Client;

namespace testConnectionOracle
{
    class Program
    {
        static void Main(string[] args)
        {
            string connectionString;
            string queryString;

            connectionString = "Data Source=192.168.1.10/orcldb;User ID=zhangsan;PassWord=123456";

            queryString = "SELECT * FROM USERTABLE";

            OracleConnection myConnection = new OracleConnection(connectionString);

            OracleCommand myORACCommand = myConnection.CreateCommand();

            myORACCommand.CommandText = queryString;

            myConnection.Open();

            OracleDataReader myDataReader = myORACCommand.ExecuteReader();

            myDataReader.Read();

            Console.WriteLine("ID: " + myDataReader["ID"]);

            myDataReader.Close();

            myConnection.Close();

        }
    }
}