Oracle Developer Tools for Visual Studio - Final Edition

Howdy All!

In this last article, we will be exploring on how to install Oracle Developer Tools for Visual Studio and get some data from your oracle 23ai database running in Virtual Box.

Setup Information:

1) Oracle Developer Tools for Visual Studio Extension which can be found in the Extensions Marketplace as shown below. You will need to close and restart Visual Studio for the extension to be applied.

2) Download and install the Oracle 23ai VirtualBox OVA file and import it.

The link to the download is below

Oracle VM VirtualBoxFilenameOracle_Database_23ai_Free_Developer.ova

Import the 23ai Free .ova file into your local Oracle VM VirtualBox setup.

See Oracle Database 23ai Free VirtualBox Appliance for what’s in the Oracle VM VirtualBox image and Resource requirements.

3) Launch Visual Studio

4) Create a new WPF Application Project

5) Navigate to the Server Explorer and you should see the Oracle Cloud Infrastructure along with Database Tools. Right Click on Data Connections and choose Add new Connection. Make sure you choose the Oracle Database (ODP.NET, Managed Driver).

Fill in your connection information below.

Test the connection to make sure it works.

Now you will see the tables and Views being displayed in the Server Explorer.

Next you can right click on a Table and view the data as shown below

Here are the results

If you wish to launch the Query Window --> Right Click and Choose Launch Query Window

Run a Sample Query to get the version information of our Oracle23ai Database.

SELECT *
FROM V$VERSION;        

The output will be displayed below

Congratulations! You have successfully installed and run your very first set of activities using Oracle Developer Tools for Visual Studio. You may now use your favorite language of choice C# / VB.NET to code the application.