EntityFrameworkCore: https://www.nuget.org/packages/Microsoft.EntityFrameworkCore/6.0.6
EntityFrameworkCore.Design: https://www.nuget.org/packages/Microsoft.EntityFrameworkCore.Design/7.0.0-preview.5.22302.2
EntityFrameworkCore.SqlServer: https://www.nuget.org/packages/Microsoft.EntityFrameworkCore.SqlServer/7.0.0-preview.5.22302.2
AutoMapper(DependencyInjection): https://www.nuget.org/packages/AutoMapper.Extensions.Microsoft.DependencyInjection
JsonPatch: https://www.nuget.org/packages/Microsoft.AspNetCore.JsonPatch/7.0.0-preview.5.22303.8
NewtonsoftJson: https://www.nuget.org/packages/Microsoft.AspNetCore.Mvc.NewtonsoftJson/7.0.0-preview.5.22303.8
Dotnet ef Tool packages: dotnet tool install --global dotnet-ef
-
Model = Classes (objects)
- manages the behavior and data
-
View = Web Page (Razor HTML) or combined with other front-end services (React, Angular, Vue)
- manages the display of data
-
Controller = Connects models, business logic and web pages
- handles page events and navigation between pages
User -(orders)-> Router -(rotes[name, url]-> Controller -(Order List)-> Model -(get)-> Database
Database ---> Model ---> Controller ---> View
prop + 2x TAB: Generate a propoty ctor + 2x TAP: Generate a constructor
| Data Access Object(DAO) | Object Relational Mapper(ORM) |
|---|---|
| Manually create tables | Allow the computer to generate database tables based on classes defined in the application |
| Traditional method of database access | Database is updated using migrations |
| Write your own SQL statements | Entity Framework is Microsoft's ORM |
| Database managers(DBA's) ususally perfer DAOs | Simple for basic applications |
| Provides more visibility on finding problems |
- "Full" Update - need to supply the entire object
- Inefficient (and error prone for large objects)
- Not used so much now, PATCH is the favoured approach
JSON Patch standard specifiedd in RFC 6902
6 Operations: Add / Remove / Replace / Copy / Move / Test