IIRF Online > Development > Web Development > ASP.NET Core > .NET 7 Web API & Entity Framework Jumpstart
.NET 7 Web API & Entity Framework Jumpstart by Udemy
Build the back-end of a .NET 7 web application with a Web API, Entity Framework 7 & SQL Server in no time!
Course Highlights
- Build a complete .NET 7 back-end with Web API, Entity Framework Core, SQL Server
- Implement Token Authentication with JSON Web Tokens & Roles
- Utilize all three types of relationships in your database: one-to-one, one-to-many, many-to-many
- Use the HTTP request methods GET, POST, PUT & DELETE
- Implement best practices like a proper structure for your Web API, Dependency Injection, asynchronous calls with async/await and Data-Transfer-Objects (DTOs)
- Use LINQ to filter, sort, map, select and access your entities.
- Seed data with code-first migrations programmatically
Skills you will learn!
Curriculum
6 Topics
Introduction
Tools (Visual Studio Code & .NET SDK)
Create a new Web API
First API Call
Git Repository & .gitignore File
GitHub Repository
19 Topics
Introduction
The Model-View-Controller (MVC) Pattern
New Models
New Controller & GET a New Character
First Steps with Attribute Routing
Routing with Parameters
HTTP Request Methods Explained
Add a New Character with POST
Best Practice: Web API Structure
Character Service
Fix the “Possible ArgumentNullException”
Asynchronous Calls
Proper Service Response with Generics
Data-Transfer-Objects (DTOs)
AutoMapper
Modify a Character with PUT
Modify a Character with AutoMapper
Delete a Character
Summary
12 Topics
Introduction
Object-Relational-Mapping & Code-First Migration Explained
Installing Entity Framework 7
Installing SQL Server Express (with Management Studio)
Implementing the DataContext
ConnectionString & Adding the DbContext
First Migration
GET Implementations
POST Implementations
PUT Implementations
DELETE Implementations
Summary
16 Topics
Introduction
The User Model
First Relationship
Authentication Theory
Authentication Repository Theory
Authentication Repository Implementation
User Registration
“User already exists.”
Authentication Controller
User Login
Token Authentication with JSON Web Tokens
JSON Web Tokens (JWT) implementations
Authentication Middleware & Authorize Attribute
Testing Secured Methods with Swagger
Reading Claims & Receiving the User’s RPG Characters
Summary
11 Topics
Introduction
Proper User-Character Relationship - Get All Characters
Proper User-Character Relationship - Add Character
Proper User-Character Relationship - Delete & Get Single Character
Include Entities with Entity Framework
One-To-One Relationship with Weapons
Add Weapons to RPG Characters
Many-To-Many Relationship with Skills
Data Seeding - Add Skills to the Database
Add Skills to RPG Characters
Summary
7 Topics
Introduction
Prepare to Fight!
Attack with Weapons
Attack with Skills
Start a Fight
Highscore: Sort & Filter Entities
Summary
6 Topics
Introduction
Tools (Visual Studio Code & .NET SDK)
Create a new Web API
First API Call
Git Repository & .gitignore File
GitHub Repository
18 Topics
Introduction
The Model-View-Controller (MVC) Pattern
New Models
New Controller & GET a New Character
First Steps with Attribute Routing
Routing with Parameters
HTTP Methods Explained
Add a New Character with POST
Best Practice: Web API Structure
Character Service
Asynchronous Calls
Proper Service Response with Generics
Data-Transfer-Objects (DTOs)
AutoMapper
Modify a Character with PUT
Modify a Character with Automapper
Delete a Character
Summary
12 Topics
Introduction
Object-Relational-Mapping & Code-First Migration Explained
Installing Entity Framework Core
Installing SQL Server Express (with Management Studio)
Implementing the DataContext
ConnectionString & Adding the DbContext
First Migration
GET Implementations
POST Implementations
PUT Implementations
DELETE Implementations
Summary
15 Topics
Introduction
The User Model
First Relationship
Authentication Theory
Authentication Repository
User Registration
“User already exists.”
Authentication Controller
User Login
Token Authentication with JSON Web Tokens
JSON Web Tokens (JWT) implementations
Authentication Middleware & Authorize Attribute
Testing Secured Methods with Swagger
Reading Claims & Receiving the User’s RPG Characters
Summary
11 Topics
Introduction
Proper User-Character Relationship - Get All Characters
Proper User-Character Relationship - Add Character
Proper User-Character Relationship - Delete & Get Single Character
Include Entities with Entity Framework
One-To-One Relationship with Weapons
Add Weapons to RPG Characters
Many-To-Many Relationship with Skills
Data Seeding - Add Skills to the Database
Add Skills to RPG Characters
Summary
7 Topics
Introduction
Prepare to Fight!
Attack with Weapons
Attack with Skills
Start a Fight
Highscore: Sort & Filter Entities
Summary
6 Topics
Introduction
Tools (Visual Studio Code & .NET SDK)
Create a new Web API
First API Call
Git Repository & .gitignore File
GitHub Repository
17 Topics
Introduction
The Model-View-Controller (MVC) Pattern
New Models
New Controller & GET a New Character
First Steps with Attribute Routing
Routing with Parameters
HTTP Methods Explained
Add a New Character with POST
Best Practice: Web API Structure
Character Service
Asynchronous Calls
Proper Service Response with Generics
Data-Transfer-Objects (DTOs)
AutoMapper
Modify a Character with PUT
Delete a Character
Summary
12 Topics
Introduction
Object-Relational-Mapping & Code-First Migration Explained
Installing Entity Framework Core
Installing SQL Server Express (with Management Studio)
Implementing the DataContext
ConnectionString & Adding the DbContext
First Migration
GET Implementations
POST Implementations
PUT Implementations
DELETE Implementations
Summary
15 Topics
Introduction
The User Model
First Relationship
Authentication Theory
Authentication Repository
User Registration
"User already exists."
Authentication Controller
User Login
Token Authentication with JSON Web Tokens
JSON Web Tokens (JWT) implementations
Authentication Middleware & Authorize Attribute
Test Secured Methods with Swagger
Read Claims & Get the User’s RPG Characters
Summary
11 Topics
Introduction
Proper User-Character Relationship 1/3 - Get All Characters
Proper User-Character Relationship 2/3 - Add Character
Proper User-Character Relationship 3/3 - Delete & Get Single Character
Include Entities with Entity Framework
One-To-One Relationship with Weapons
Add Weapons to RPG Characters
Many-To-Many Relationship with Skills
Data Seeding - Add Skills to the Database
Add Skills to RPG Characters
Summary
7 Topics
Introduction
Prepare to Fight!
Attack with Weapons
Attack with Skills
Start a Fight
Highscore: Sort & Filter Entities
Summary
6 Topics
Introduction
Tools (VS Code Postman .NET Core SDK)
Create a new Web API
First API Call
Git Repository & .gitignore File
GitHub Repository
17 Topics
Introduction
The Model-View-Controller (MVC) Pattern
New Models
New Controller & GET a New Character
First Steps with Attribute Routing
Routing with Parameters
HTTP Methods Explained
Add a New Character with POST
Best Practice: Web API Structure
Character Service
Asynchronous Calls
Proper Service Response with Generics
Data-Transfer-Objects (DTOs)
AutoMapper
Modify a Character with PUT
Delete a Character
Summary
12 Topics
Introduction
Object-Relational-Mapping & Code-First Migration Explained
Installing Entity Framework Core
Installing SQL Server Express (with Management Studio)
Implementing the DataContext
ConnectionString & Adding the DbContext
First Migration
GET Implementations
POST Implementations
PUT Implementations
DELETE Implementations
Summary
15 Topics
Introduction
The User Model
First Relation
Authentication Theory
Authentication Repository
User Registration
“User already exists.”
Authentication Controller
User Login
Token Authentication with JSON Web Tokens
JSON Web Tokens (JWT) preparations
JSON Web Tokens (JWT) implementations
Authorize Attribute
Read Claims & Get the User’s RPG Characters
Summary
8 Topics
Introduction
Proper User-Character Relation
Include Entities with Entity Framework
One-To-One Relation with Weapons
Add Weapons to RPG Characters
Many-To-Many Relation with Skills
Add Skills to RPG Characters
Summary
7 Topics
Introduction
Prepare to Fight!
Attack with Weapons
Attack with Skills
Start a Fight
Highscore: Sort & Filter Entities
Summary
4 Topics
Introduction
New User Property: Role & A New Migration
Extend the JSON Web Token with another Claim
Restrict Controller Access & Change Service Behavior
7 Topics
Introduction
New Package ConnectionString & Configuration
Create the SQLite Database
Use the DB Browser for SQLite
Data Seeding Preparations
Seeding Skills
Seeding Entities with Relations
3 Topics
Why .NET 5
Download the SDK & Update Visual Studio Code
Migrate the Project
.NET 7 Web API & Entity Framework Jumpstart
Related ASP.NET Core Courses
Thank You!
Your review has been submitted successfully.