.net core web API repository

Question

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 .

Sachin Singh · 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.

Rijwan Ansari · Answer

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

Rijwan Ansari · Answer

Yes code first approach

Satya Karki · Answer

https://www.c-sharpcorner.com/article/creating-web-api-with-repository-pattern-and-dependency-injection/

Rijwan Ansari · Answer

Hi You can check my sample project https://github.com/rijwanansari/CleanArchitectRepo

Rohan · Answer

Rizwan Ansari Your project is based on the code first approach. I want to DbFirstApproach

Rohan · Answer

Sachin Singh do you mean EF Core doesn't support DBFirst approach.

Rohan · Answer

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