Oracle Database Interaction Using ODP.NET and ASP.NET: All Ways to Manipulate Data - What are all the possible ways to work with those classes?
(Page 2 of 5 )
Actually to improve performance for manipulating information for huge databases, we also need to consider stored procedures, functions, triggers, packages, objects, and so on (using Oracle server side programming). In this article, I don’t want to concentrate on performance issues (or Oracle server side programming, or other peripheral matters). If you need to know about Oracle server side programming, I suggest you follow the “Database Interaction with PL/SQL” series on www.devshed.com. My upcoming articles (of this series) will concentrate on working with PL/SQL (including stored procedures) from within ODP.NET. As of now, I'm concentrating on manipulating with just traditional SQL.
Most of the time we will work with the following methodologies to manipulate data in Oracle 10g database (keep in mind that I am not focusing on PL/SQL right now).
- Using single DML commands at a time
- Using multiple DML commands
- Multiple DML commands with parameters (two methods)
- Multiple DML commands with Array Binding (two methods)
- Using Dataset for automatic updating
- Using Dataset for automatic updating using command parameters
Even though this series started with the title ASP.NET, you can also work with the same kind of concept either in VB.NET or VC#.NET (or any other .NET supported language). I simply used an ASP.NET based “datagrid” control to display the manipulated data, fetched from an Oracle database (just for my convenience). Even though all of the above methodologies would make the same update to the database, we need to choose a particular method for a particular scenario based on all factors (like performance, speed, offline data, and so on). It is NOT something you can simply 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: Using a single DML command at a time >>
More ASP.NET Articles
More By Jagadish Chaterjee
