Connecting to 18c Oracle Database XE in Visual Studio 2019

Once you have installed 18c Oracle Database XE on Windows 10, you will need connection information to connect to the default database under visual studio 2019.

The article here provides the connection properties to establish a New Connection for use in Entity Data Model wizard using ODP.NET Managed driver under Visual Studio 2019.

The link here provides other details should you need further assistance.

STEP-1: Proceed to Choose Data Source page, select Oracle Database as Data Source and hit Continue.

STEP-2: When you are presented with the following Connection Properties page, fill the details that follow:

Connection Type: TNS Alias
TNS admin location:
If you accepted defaults when you installed the 18c XE database, then the admin directory path should look something similar to below:

C:\app\<user>\product\18.0.0\dbhomeXE\network\admin

Or set it to the path as per your installation preferences. However, verify you are able to locate the files — listener.ora, sqlnet.ora and tnsnames.ora at the directory of your choice.

Data Source name:
Once you fill the TNS admin location, the Data Source name should get auto-populated to LISTENER_XE

Use wallet file: Leave it unchecked.
Role: Set it to SYSDBA (Administrator)
User name: system
Password: GetStarted18c
Connection name: Should get auto-populated to SYSTEM.LISTENER_XE

Having filled the details as above, the page may appear something similar to below:

STEP-3: Click Test Connection to see the success message:

Congratulations !!
You have successfully made a connection to 18c Oracle Database XE.