Database first approach

Question

C# and SQL connection

Cynthia Sathuragiri · Answer

You start with an existing SQL Database (tables, views, relationships). Then, in C#, you generate Entity Framework models (classes) from that database. After that, you can query and update the database using C# LINQ instead of writing SQL manually. You can have the below as reference https://learn.microsoft.com/en-us/ef/core/managing-schemas/scaffolding https://www.entityframeworktutorial.net/efcore/create-model-for-existing-database-in-ef-core.aspx

Jayraj Chhaya · Answer

The Database First approach in Entity Framework (EF) is a method where the database schema is created first, and then the application code is generated based on that existing schema. This approach is particularly useful when working with an existing database or when the database schema is finalized before the application code is developed. In this approach, developers use tools like the Entity Data Model Wizard in Visual Studio to generate model classes (such as DbContext and entity classes) from the existing database. These generated classes serve as a bridge between the application and the database, allowing developers to interact with the database using strongly typed objects. One of the key advantages of the Database First approach is that it allows developers to work with a pre-existing database, which can be beneficial in scenarios where the database schema is already defined or when integrating with legacy systems. For a detailed, step-by-step guide on implementing the Database First approach in Entity Framework, you can refer to this article on C# Corner: Database First Approach in Entity Framework https://www.c-sharpcorner.com/UploadFile/26b237/database-first-approach-in-entity-framework347/

Database first approach

Answers (2)