Searching for a simple (!) sample for accessing an Oracle database and read some data from it

[Ken Williams]

WhenI search Internet there thousands of comments and samples for database conenction and tuning.
They are all advanced and comprehesive.

I didn't found a simple "Hello World" for accessing an Oracle database.

This sample should contain just
- connecting to database,
- pass an SELECT FROM WHERE statement and
- read the result into a CSharp internal table/records.

Does someone know such sample ?

Ken

 

[Ben Voigt]

WhenI search Internet there thousands of comments and samples for database
conenction and tuning.
They are all advanced and comprehesive.

I didn't found a simple "Hello World" for accessing an Oracle database.

This sample should contain just
- connecting to database,
- pass an SELECT FROM WHERE statement and
- read the result into a CSharp internal table/records.

Does someone know such sample ?

Well, here's a nice example of INSERT INTO

http://msdn2.microsoft.com/en-us/library/system.data.oracleclient.oracleconnection.aspx

Here are some SELECT examples, some more complex than others

http://msdn2.microsoft.com/en-us/library/system.data.oracleclient.oracledatareader.aspx

 

[Egghead]

Did you try Oracle website? They have a walkthrough.