- Use .NET Core 3.0+
- Do one task at a time. Run tests, many tests!
- Follow GIT best practices you learned to push your code.
- This exercise depends on SQL: Doctor Who exercise.
- Create a DB named
DoctorWhoCore(using SSMS). - Create a console application project named
DoctorWho. - Create a library project named
DoctorWho.Dband reference it fromDoctorWhoproject. - Create
DoctorWhoCoreDbContextand add it toDoctorWho.Db - Create the data models for Doctor Who tables with all necessary keys, relationships, constraints and navigations. These models should exist in
DoctorWho.Db - Write migrations to create the previous tables. Migrations should exist in
DoctorWho.Db. - Seed the tables with at least 5 records in each.
- Write migrations to create the
functions,sprocsandviewsfrom previous exercise. - Write methods in EF in the console app to execute the
functions,sprocsandviewsfrom previous exercise. - Write
Create/Update/Deletemethods for companions, enemies, doctors, authors, and episodes. - Write methods to:
AddEnemyToEpisode: Add an enemy to an episode.AddCompanionToEpisode: Add a companion to an episode.GetAllDoctors: Get all available doctors.GetEnemyById: Get an enemy by ID.GetCompanionById: Get a companion by ID.
- Create a repository class for each entity and call it:
{EntityName}Repository.cs, and move related methods from the previous requirements to the right repository. These repositories should exist inRepositoriesfolderDoctorWho.Db
React
Typescript
Django
Laravel
Facebook
Microsoft
Google
Alibaba
D3
Tencent