ADO.Net 链接 Oracle 数据库

Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
Integrated Security=no;

链接远程数据库：

static void Main(string[] args)
 2         {
 3             string conStr = @"SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=IP地址)(PORT=端口号))(CONNECT_DATA=(SERVICE_NAME=监听服务)));
 4 uid=用户名;pwd=密码;";
 5             OracleConnection oracleConn = new OracleConnection(conStr);
 6 //oracleConn.ConnectionString =@"User Id=system;Password=123456;
 7 //                                     Data Source=oracleSN;";
 8             oracleConn.Open();
 9             OracleCommand cmd = new OracleCommand("select * from \"UserInfo\"", oracleConn);
10             DataSet ds = new DataSet();
11             OracleDataAdapter da = new OracleDataAdapter(cmd);
12             da.Fill(ds);
13 
14             oracleConn.Close();
15         }

复制代码

 这是陈毅老师给的一个例子，链接而是远程的电脑，端口号合监听服务也是他自己设置的

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using System.Data.OracleClient;
using System.Data;


namespace ConsoleApplication2
{
    class Program
    {
        static void Main(string[] args)
        {
            string conStr = @"SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.129.119)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)));
 uid=system;pwd=123456;";
            OracleConnection conn = new OracleConnection(conStr);
            string sql="select * from \"LoginInfo\"";
            OracleCommand cmd=new OracleCommand(sql,conn);
            OracleDataAdapter da = new OracleDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds);
            foreach (DataRow item in ds.Tables[0].Rows)
            {
                Console.WriteLine("ID:{0},Name:{1},pwd{2}",item["id"].ToString(),item["Name"].ToString(),item["pwd"].ToString());
            }

            Console.ReadKey();
        }
    }
}