VS2010 C# 如何连接Oracle 11g数据库

vs2010 c# 连接远程oracle 11g的数据库

需要安装ODTwithODAC1120320_32bit；
安装说明：
1.setup.exe
2.选择安装的产品（Oracle Client）而不是 (Oracle Server) 
3.项目添加Oracle.DataAccess.dll的引用
4.Oracle.DataAccess.dll
   例如：D:\app\dell\product\11.2.0\client_1\odp.net\bin\4文件夹下面  

------

        using Oracle.DataAccess.Client;
	public string GetEmail(string id)
	{
		string strCon = "Data Source=(DESCRIPTION=" + "(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))" + "(CONNECT_DATA=(SERVICE_NAME=orcl)));" + "User Id=id;Password=password;";
		OracleConnection conn = new OracleConnection(strCon);
		try
		{
			string sql = "select name from table where id=\'" + id+"\'";
			//string sql = "select * from table";
			OracleCommand com = conn.CreateCommand();
			com.CommandText = sql;
			conn.Open();   
			string result = Convert.ToString(com.ExecuteScalar());

			//OracleDataAdapter oraDA = new OracleDataAdapter(com);
			//DataSet ds = new DataSet();
			//oraDA.Fill(ds);
			//conn.Clone();
			//DataTable dt = ds.Tables[0];
			//string result = "";
			//if (dt != null && dt.Rows.Count > 0)
			//{
			//    foreach (DataRow dr in dt.Rows)
			//    {
			//        //string a = dr["a"].ToString();
			//        //string b = dr["b"].ToString();
			//        //string c = dr["c"].ToString();
			//        //string d = dr["d"].ToString();
			//    } 
			//} 

			return result; 
		}  
		catch (Exception ex)
		{
			return "no";
		} 
		finally
		{
			conn.Close();
		}

	}

----

见图：