Connect to Oracle using EF Core

Mar 27, 2025

In this tutorial, we’ll demonstrate how to create an Entity Framework Core model and connect a.NET console application to an Oracle database. We’ll guide you step by step, showing how to set up your connection, install the necessary components, and use Entity Developer to generate a model based on your Oracle database. By the end of this video, you'll have a functional setup to interact with Oracle tables directly within your.NET console application.

Timestamps

0:00 – Introduction

0:34 – Creating a new console application in Visual Studio

0:42 – Connecting to Oracle database in Visual Studio

1:27 – Setting up Entity Framework Core and dotConnect for Oracle

1:53 – Creating an Entity Framework Core model using Entity Developer

3:45 – Connecting to the database and retrieving data

4:03 – Conclusion

If you want to follow along, you can choose between a 30-day free trial or the full version of the tool. The free trial offers all features but is not for commercial use.

Code Example:
Find the code example mentioned in the video here: https://dotnetfiddle.net/8Wfojd

👉 Check full overview of dotConnect for Oracle here: https://www.devart.com/dotconnect/oracle/

🔥 You can download dotConnect for Oracle trial here: https://www.devart.com/dotconnect/oracle/download.html

🔔 Subscribe to our channel and get dozens of tutorials about Devart tools: @DevartSoftware