DEV Community

andreasneuman
andreasneuman

Posted on

Creating a .NET Core Application Using Entity Framework Core with dotConnect for Oracle

This tutorial shows how to create a .NET Core Application using Entity Framework Core for an Oracle database. It uses dotConnect for Oracle, a high-performance ADO.NET provider from Devart. The tutorial demonstrates Database-First approach to create an Entity Framework Core model and generate the corresponding code.

Entity Framework Core implements Database-First approach via the Scaffold-DbContext command of Package Manager Console. This command allows quick generation of a DbContext and entity type classes for a specified database, but it doesn't provide much options for customization.

In this tutorial, we will show Database-First approach using our dedicated ORM designer and code generation tool - Entity Developer. It supports Database-First, Model-First, or mixed developer approaches and allows you to quickly generate a model from a database, tweak it visually, automatically apply model changes to a database, if necessary, and generate code. Entity Developer seamlessly integrates into Visual Studio, allows testing the model with LINQ Queries at design-time, supports integration with Visual Studio refactoring and provides its own Model Refactoring feature.

Note: You can find a similar tutorial, using the Scaffold-DbContext command to generate code here.

This tutorial shows how to create a simple console application, powered by Entity Framework Core and using Database-First approach. It uses the tables, we have created in the Creating Database Objects and Inserting Data Into Tables tutorials.

Read the full tutorial at https://www.devart.com/dotconnect/oracle/articles/efcore-database-first-net-core-entity-developer.html

Top comments (1)

Collapse
 
didin1453fatih profile image
Didin 👨‍💻

You can try dbdesigner.id to create Entity Relationship Diagram 😎😎😎.
This can help you to collaborate with your team on web and cut off your step in generate SQL Create database.
I write this article to explain more about this devtool dev.to/didin1453fatih/database-des...

Alt Text