How to access the Oracle database in. net

Recently, I am working on an Oracle database project. Now I want to talk about some successive Oracle Database problems.

1. Download. Net managed provider for Oracle from Microsoft msdn on the download page of msdn:
Http://www.microsoft.com/downloads/ThankYou.aspx? Familyid = 4f55d429-17dc-45ea-bfb3-076d1c052524 & displaylang = ZH-CN
Note: This namespace, class, or member is only supported in. NET Framework 1.1.
2. reference the system. Data. oracleclient. dll file in your project. Then you can call system. Data. oracleclient; namespace.

The following are members of system. Data. oracleclient:

Class

Class	Description
Oraclebfile	Indicates hostingOraclebfileObject.BfileData types are used together. This class cannot be inherited.
Oraclecommand	SQL statements or stored procedures executed on the database. This class cannot be inherited.
Oraclecommandbuilder	Automatic Generation for coordinationDatasetTo change the single table command of the associated database. This class cannot be inherited.
Oracleconnection	Indicates an open connection to the database. This class cannot be inherited.
Oracledataadapter	Used for fillingDatasetAnd a set of data commands for updating the database and connections to the database. This class cannot be inherited.
Oracledatareader	Provides a method to read data rows from a data source. This class cannot be inherited.
Oracleexception	When the Oracle database or. NET Framework data for Oracle is providedProgramThe exception generated when a warning or error is returned. This class cannot be inherited.
Oracleinfomessageeventargs	Provides data for infomessage events. This class cannot be inherited.
Oraclelob	Indicates the "Large Object binary "(Lob) Data type. This class cannot be inherited.
Oracleparameter	The oraclecommand parameter.Datacolumn. This class cannot be inherited.
Oracleparametercollection	A set of oraclecommand-related parameters and their mappings to columns in dataset. This class cannot be inherited.
Oraclepermission	Enable the. NET Framework data provider for Oracle to ensure that users have sufficient security levels to access the Oracle database. This class cannot be inherited.
Oraclepermissionattribute	Associate a security operation with a custom security attribute.
Oraclerowupdatedeventargs	Provides data for rowupdated events. This class cannot be inherited.
Oraclerowupdatingeventargs	Provides data for rowupdating events. This class cannot be inherited.
Oracletransaction	Indicates the transaction to be generated in the database. This class cannot be inherited.

Structure

Structure	Description
Oraclebinary	A variable-length stream of binary data to be stored in or retrieved from a database.
Oracleboolean	Returns the value of the database comparison operation between Oracle data types, and discloses the method used to perform data type conversion.
Oracledatetime	Date and Time data. The value range is from January 1, January 1, 4712 BC to January 1, December 31, 4712 AD.
Oraclemonthspan	Represents the time interval represented by the month, and corresponds to Oracle 9iInterval year to monthData type.
Oraclenumber	The fixed precision and decimal point value to be stored in or retrieved from the database. The value is between-1038-1 and 10 38-1.
Oraclestring	Variable-length stream of characters to be stored in or retrieved from the database.
Oracletimespan	Indicates the time interval, and corresponds to Oracle 9iInterval day to secondData type.

Delegate

Delegate	Description
Oracleinfomessageeventhandler	The method that will process the infomessage event of oracleconnection.
Oraclerowupdatedeventhandler	The method that will process the rowupdated event of oracledataadapter.
Oraclerowupdatingeventhandler	The method that will process the rowupdating event of oracledataadapter.

Enumeration

Enumeration	Description
Oraclelobopenmode	Specify whether oraclelob should be enabled in read-only or read/write mode.
Oracletype	Specifies the Data Type of a field or attribute for oracleparameter.