Shulou(Shulou.com)06/02 Report--

This article mainly explains "how to use AOP.NET OracleDataReader object". The content in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn how to use AOP.NET OracleDataReader object.

AOP.NET OracleDataReader object

A brief understanding of the new features of ADO.NET SqlConnection

Revealing the Secret of ADO.NET VC Joint use

The ADO.NET2.0 database of the novice must-see article

Five minutes to teach you to understand the ADO.NET data sheet

Describe the advantages and disadvantages of ADO.NET stored procedures

Many database operations require us to simply read a set of data. At this point, the data reader object is used. Through the data reader object, we can get the results from the SELECT statement of the command object. For performance reasons, the data stream returned by data reader is designed to be read-only and unidirectional, which means that you can only pull data from the data stream in a certain order. Although you have also achieved a performance improvement here, but the disadvantage is also obvious, can not operate to retrieve data, if you need to manipulate and edit data, the solution is to use DataSet.

AOP.NET OracleDataAdapter object

Sometimes we just need to read the data, and you don't need to modify them to write the changes back to the data source. But there are also cases where we cache the data in memory in order to reduce the number of database calls. Data adapter easily handles the latter situation by breaking the model. When the batch read and write operations to the database are completed and the changes are written back to the database, the data adapter populates (fill) the DataSet object. Data adaapter contains connection objects, and when reading or writing to a data source, data adapter automatically opens or closes the connection. In addition, data adapter contains command object references to SELECT,INSERT,UPDATE and DELETE operations on the data. If we specify data adapter for every table in DataSet, it will help you handle all database operations with connections. All we need to do is tell data adapter when to read or write to the database.

The steps of writing a database connection program with C#

To use a subset of classes in the System.Data.OracleClient namespace to operate on the Oracle database in your program:

1. Add a reference to System.Data.OracleClient (the Microsoft .NET Framework data provider for Oracle) to the project.

2. Import the types in the OracleClient class using the using directive.

Using System.Data.OracleClient

3. Create an OracleConnection object.

OracleConnection conn = new OracleConnection ("Data Source=oracledb;User Id=UserID;PasswordPassword=Password;")

4. Create an OracleCommand object. Set its Connection property to the connection you created in the previous step. Set its CommandText to the operation you want to do on the database table, that is, the SQL statement.

OracleCommand cmd = new OracleCommand (); cmd.Connection = conn; cmd.CommandText = "select * from table"

5. Create an OracleParameter object and add it to the parameter collection of the OracleCommand object. (if there are parameters in CommandText, you need to create this object)

Cmd.Parameters.Add ("reccount", OracleType.Number)

6. If you want to browse the result set of the operation, create a DataSet, DataTable, or DataReader.

7. Use an Execute method of the OracleCommand object to execute the SQL statement in CommandText, as shown below:

Conn.Open (); cmd.ExecuteNonQuery (); conn.Close (); Thank you for reading, this is the content of "how to use AOP.NET OracleDataReader object". After the study of this article, I believe you have a deeper understanding of how to use AOP.NET OracleDataReader object, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.