.net core web API repository

Rohan

4y1.1k.NET

Please help me how to create a .net core web API repository pattern with DB first approach(CURD Operation). I'm new in repository pattern and I have create table .

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh4y ago
Accepted answer
See, EF Core doesn't support Database First approach. It just supports Code First.
But, as we may have existing database so it provides us the way to reverse engineer means to create model from DB and then go with code first means run migration command.

step 1. Scaffold
Scaffold-DbContext "Server=.\SQLExpress;Database=SchoolDB;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models
step 2. Forget about database.
step 3. Modify model, add model, delete any model property and run add-migration and update-database command.
The point is you just have code first. You won't get any EDMX file or designer. So once model is generated from DB by scaffold, you don't need to touch database, you will just work on models.
+2
Rohan4y ago
Sachin Singh do you mean EF Core doesn't support DBFirst approach.
+1
Rohan4y ago
I have check this ASP.NET Core Web API with EF Core DB-First Approach - Code Maze (code-maze.com)
But I'm not understand . Please any help me send simple curd operation
+1
Rijwan Ansari4y ago
You can use same project as Db first approach.

You need to run a command.
Scaffold-DbContext "Server=.\SQLExpress;Database=SchoolDB;Trusted_Connection=True;" Microsoft.EntityFrameworkCore.SqlServer -OutputDir Models
sample
Scaffold-DbContext [-Connection] [-Provider] [-OutputDir] [-Context] [-Schemas>] [-Tables>]
                    [-DataAnnotations] [-Force] [-Project] [-StartupProject] [<CommonParameters>]
reference:
https://www.entityframeworktutorial.net/efcore/create-model-for-existing-database-in-ef-core.aspx
+2
Rijwan Ansari4y ago
Yes code first approach
+2
Satya Karki4y ago
https://www.c-sharpcorner.com/article/creating-web-api-with-repository-pattern-and-dependency-injection/
+2
Rohan4y ago
Rizwan Ansari Your project is based on the code first approach. I want to DbFirstApproach
+1
Rijwan Ansari4y ago
Hi You can check my sample project

https://github.com/rijwanansari/CleanArchitectRepo
+2