Explore ASP.NET Core by delving into MVC design, JSON web APIs, repository patterns, and adding authentication. Gain insights to confidently develop full-stack or backend applications.

asp.tar.gz

ASP.NET

MVC in ASP.NET Core - Models in ASP.NET

MVC in ASP.NET Core - Models in ASP.NET-copy

This course is for you if you’re looking to start your journey in either full-stack MVC or backend development with ASP.NET Core.

In the first half of the course, you’ll learn about the Model-View-Controller design pattern and how you can use it to organize and develop your web application. You’ll then dive into JSON web APIs which allow communication between your back-end ASP.NET application and front-end web/mobile application.

In the latter half, you’ll learn about the repository pattern, how relationships work, and how to add authentication and authorization to your application.

By the end of this course, you will have the confidence to develop your own applications in ASP.NET Core.

Developing Applications with ASP.NET Core

## Configuring database context

### Install EF Core SQL Server

To install EntityFramework Core SQL Server, go to the package manager. To access the package manager, click on **Tools** > **NuGet Package Manager** > **Package Manager Console**. At the bottom, a console would appear. Type in the following command in the console.
```C#
Install-Package Microsoft.EntityFrameworkCore.SqlServer
```
### Create a database context class

Create a folder `Data`. Inside that folder, create a context class. The name of this class will depend on the application. For example, if you create a contacts application called "People", your context class will be called `PeopleContext.cs`.

This class inherits from the `DbContext` class. 

### Register model class

The model class that you created needs to be defined here so that Entity Framework can pick it up and map it to a database. To register a model class, type the following line into the context class:

```C#
public DbSet<Person> People { get; set; }
```
If more model classes are created in the future, they too need to be added to the list.

### Add constructor

A constructor also needs to be added. Parameter `options` of type `DbContextOptions<PeopleContext>` will be passed to it.

### Code

The code should look something like this:


# Configuring database context

## Install EF Core SQL Server

To install EntityFramework Core SQL Server, go to the package manager. To access the package manager, click on **Tools** > **NuGet Package Manager** > **Package Manager Console**. At the bottom, a console would appear. Type in the following command in the console.
```C#
Install-Package Microsoft.EntityFrameworkCore.SqlServer
```
## Create a database context class

Create a folder `Data`. Inside that folder, create a context class. The name of this class will depend on the application. For example, if you create a contacts application called "People", your context class will be called `PeopleContext.cs`.

This class inherits from the `DbContext` class. 

## Register model class

The model class that you created needs to be defined here so that Entity Framework can pick it up and map it to a database. To register a model class, type the following line into the context class:

```C#
public DbSet<Person> People { get; set; }
```
If more model classes are created in the future, they too need to be added to the list.

## Add constructor

A constructor also needs to be added. Parameter `options` of type `DbContextOptions<PeopleContext>` will be passed to it.

## Code

The code should look something like this:


Learn to configure a database with your application for development purposes.

Introduction

Getting Started

MVC in ASP.NET Core

JSON Web APIs in ASP.NET Core

Working with Repositories

Relationships

Authentication and Authorization

Appendix

Conclusion

Database Configuration

Configuring database context

Install EF Core SQL Server