Oracle Database Interaction Using ODP.NET and ASP.NET: All Ways to Retrieve Data - What are all of the possible ways to work with these classes?
(Page 2 of 5 )
Actually to improve performance for retrieving information from huge databases, we also need to consider stored procedures, functions, triggers, packages, objects, and so forth (using Oracle server side programming). In this article, I don’t want to concentrate on performance issues (or Oracle server side programming). If you need to know about Oracle server side programming, I suggest you to follow the series “Database Interaction with PL/SQL” on www.devshed.com. A number of my articles in that series concentrate on working with PL/SQL (including stored procedures) from within ODP.NET. For now, I am concentrating on interacting with just traditional SQL.
Most of the time we will work with the following methodologies to retrieve data from an Oracle 10g database (keep in mind that I am not dealing with PL/SQL right now).
- Getting information/data with just only a table name
- Getting information/data with SELECT statement
- Getting single value from database
- Single parameterized queries
- Multiple parameterized queries
- Making an offline (connection less) cache using “OracleDataReader”
- Making as offline cache using “OracleDataAdapter”
- Parameterized queries using “OracleDataAdapter”
Even though this series started with the title ASP.NET, you can also work with the same type of concept either in VB.NET or VC#.NET (or any other .NET supported language). I simply used the ASP.NET based “datagrid” control to display the data fetched from an Oracle database (just for my convenience). Even though all of those methodologies would give the same result, we need to choose a particular method for a particular scenario based on all factors (like performance, speed, offline data, and so forth). It is NOT simply something you can take for granted.
Before working with any of these examples, don’t forget to import “Oracle.DataAccess.Client” at the top of your class. This would be present, if and only if you install ODP.NET on your machine. If your development machine is simply an Oracle Client, don’t forget to configure SQL*Net and the TNS stuff. So, let us start with each of those methodologies.
Next: Getting data with only a table name >>
More ASP.NET Articles
More By Jagadish Chaterjee
