利用VS2010（C#）如何连接Oracle11g？

public abstract class DbServerOra

	{

        //数据库连接字符串(web.config来配置)，可以动态更改connectionString支持多数据库.	      

        public static string connectionString = @"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=" + ProgramInfo.Dbip + 

                                                ")(PORT=1521)))  (CONNECT_DATA=(SERVICE_NAME=" + ProgramInfo.Dbname + ")));User Id=" + ProgramInfo.Username + "; Password=" + ProgramInfo.Password + ";Unicode=True ";//

        public DbServerOra()

		{			

		}

        #region 公用方法

        

        public static int GetMaxID(string FieldName, string TableName)

        {

            string strsql = "select max(" + FieldName + ")+1 from " + TableName;

            object obj = DbServerOra.GetSingle(strsql);

            if (obj == null)

            {

                return 1;

            }

            else

            {

                return int.Parse(obj.ToString());

            }

        }

        public static bool Exists(string strSql)

        {

            object obj = DbServerOra.GetSingle(strSql);

            int cmdresult;

            if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))

            {

                cmdresult = 0;

            }

            else

            {

                cmdresult = int.Parse(obj.ToString());

            }

            if (cmdresult == 0)

            {

                return false;

            }

            else

            {

                return true;

            }

        }



        public static bool Exists(string strSql, params OracleParameter[] cmdParms)

        {

            object obj = DbServerOra.GetSingle(strSql, cmdParms);

            int cmdresult;

            if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))

            {

                cmdresult = 0;

            }

            else

            {

                cmdresult = int.Parse(obj.ToString());

            }

            if (cmdresult == 0)

            {

                return false;

            }

            else

            {

                return true;

            }

        }

        #endregion



		#region  执行简单SQL语句



		/// <summary>

		/// 执行SQL语句，返回影响的记录数

		/// </summary>

		/// <param name="SQLString">SQL语句</param>

		/// <returns>影响的记录数</returns>

		public static int ExecuteSql(string SQLString)

		{

			using (OracleConnection connection = new OracleConnection(connectionString))

			{				

				using (OracleCommand cmd = new OracleCommand(SQLString,connection))

				{

					try

					{		

						connection.Open();

						int rows=cmd.ExecuteNonQuery();

						return rows;

					}

					catch(System.Data.OracleClient.OracleException E)

					{					

						connection.Close();

						throw new Exception(E.Message);

                       // PubCommand.writeExceptionMsg("数据库", E);

					}

                    finally

                    {

                        cmd.Dispose();

                        connection.Close();

                    }

				}				

			}

		}