aspnetcore/tutorials/first-mvc-app/adding-model/includes/adding-model5.md
:::moniker range="= aspnetcore-5.0"
In this tutorial, classes are added for managing movies in a database. These classes are the "Model" part of the MVC app.
These model classes are used with Entity Framework Core (EF Core) to work with a database. EF Core is an object-relational mapping (ORM) framework that simplifies the data access code that you have to write.
The model classes created are known as POCO classes, from Plain Old CLR Objects. POCO classes don't have any dependency on EF Core. They only define the properties of the data to be stored in the database.
In this tutorial, model classes are created first, and EF Core creates the database.
Right-click the Models folder > Add > Class. Name the file Movie.cs.
Add a file named Movie.cs to the Models folder.
Control-click the Models folder > Add > New Class > Empty Class. Name the file Movie.cs.
Update the Models/Movie.cs file with the following code:
The Movie class contains an Id field, which is required by the database for the primary key.
The xref:System.ComponentModel.DataAnnotations.DataType attribute on ReleaseDate specifies the type of the data (Date). With this attribute:
DataAnnotations are covered in a later tutorial.
From the Tools menu, select NuGet Package Manager > Package Manager Console (PMC).
<!-- When https://dev.azure.com/devdiv/DevDiv/_workitems/edit/1320544 is fixed, we can remove the following install package instruction for Microsoft.EntityFrameworkCore.Design -->In the PMC, run the following command:
Install-Package Microsoft.EntityFrameworkCore.Design
The preceding commands add:
From the Project menu, select Manage NuGet Packages.
In the Search field in the upper right:
Microsoft.EntityFrameworkCore.SQLite.The Select Projects dialog displays, with the MvcMovie project selected. Select the Ok button.
A License Acceptance dialog displays. Review the licenses, then select the Accept button.
Repeat the above steps to install the following NuGet packages:
Microsoft.VisualStudio.Web.CodeGeneration.DesignMicrosoft.EntityFrameworkCore.SqlServerMicrosoft.EntityFrameworkCore.DesignRun the following .NET CLI command:
dotnet tool install --global dotnet-aspnet-codegenerator
The preceding command adds the aspnet-codegenerator scaffolding tool.
Build the project as a check for compiler errors.
Use the scaffolding tool to produce Create, Read, Update, and Delete (CRUD) pages for the movie model.
In Solution Explorer, right-click the Controllers folder and select Add > New Scaffolded Item.
In the Add Scaffold dialog, select MVC Controller with views, using Entity Framework > Add.
Complete the Add MVC Controller with views, using Entity Framework dialog:
<a name="scaffolding-created"></a>
Scaffolding updates the following:
MvcMovie.csproj project file.Startup.ConfigureServices of the Startup.cs file.appsettings.json file.Open a command window in the project directory. The project directory is the directory that contains the Program.cs, Startup.cs, and .csproj files.
On macOS and Linux, export the scaffold tool path:
export PATH=$HOME/.dotnet/tools:$PATH
Run the following command:
dotnet aspnet-codegenerator controller -name MoviesController -m Movie -dc MvcMovieContext --relativeFolderPath Controllers --useDefaultLayout --referenceScriptLibraries -sqlite
[!INCLUDE explains scaffold generated params]
<a name="sqlite-dev-vsc"></a>
When SQLite is selected, the template generated code is ready for development. The following code shows how to inject xref:Microsoft.AspNetCore.Hosting.IWebHostEnvironment into Startup. IWebHostEnvironment is injected so ConfigureServices can use SQLite in development and SQL Server in production.
<a name="scaffolding-created"></a>
Scaffolding updates the following:
Startup.ConfigureServices of the Startup.cs file.appsettings.json file.Open a command window in the project directory. The project directory is the directory that contains the Program.cs, Startup.cs, and .csproj files.
Export the scaffold tool path:
export PATH=$HOME/.dotnet/tools:$PATH
Run the following command:
dotnet aspnet-codegenerator controller -name MoviesController -m Movie -dc MvcMovieContext --relativeFolderPath Controllers --useDefaultLayout --referenceScriptLibraries -sqlite
[!INCLUDE explains scaffold generated params]
<a name="sqlite-dev-vs-mac"></a>
When SQLite is selected, the template generated code is ready for development. The following code shows how to inject xref:Microsoft.AspNetCore.Hosting.IWebHostEnvironment into Startup. IWebHostEnvironment is injected so ConfigureServices can use SQLite in development and SQL Server in production.
<a name="scaffolding-created"></a>
Scaffolding updates the following:
Startup.ConfigureServices of the Startup.cs file.appsettings.json file.Scaffolding creates the following:
Controllers/MoviesController.csViews/Movies/*.cshtmlData/MvcMovieContext.csThe automatic creation of these files and file updates are known as scaffolding.
The scaffolded pages can't be used yet because the database doesn't exist. Running the app and selecting the Movie App link results in a Cannot open database or no such table: Movie error message.
<a name="migration"></a>
Use the EF Core Migrations feature to create the database. Migrations are a set of tools that create and update a database to match the data model.
From the Tools menu, select NuGet Package Manager > Package Manager Console .
In the Package Manager Console (PMC), enter the following commands:
Add-Migration InitialCreate
Update-Database
Add-Migration InitialCreate: Generates a Migrations/{timestamp}_InitialCreate.cs migration file. The InitialCreate argument is the migration name. Any name can be used, but by convention, a name is selected that describes the migration. Because this is the first migration, the generated class contains code to create the database schema. The database schema is based on the model specified in the MvcMovieContext class.
Update-Database: Updates the database to the latest migration, which the previous command created. This command runs the Up method in the Migrations/{time-stamp}_InitialCreate.cs file, which creates the database.
The Update-Database command generates the following warning:
No type was specified for the decimal column 'Price' on entity type 'Movie'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'.
Ignore the preceding warning, it's fixed in a later tutorial.
[!INCLUDE more information on the PMC tools for EF Core]
[!INCLUDE more information on the CLI for EF Core]
Run the following .NET CLI commands:
dotnet ef migrations add InitialCreate
dotnet ef database update
ef migrations add InitialCreate: Generates an Migrations/{timestamp}_InitialCreate.cs migration file. The InitialCreate argument is the migration name. Any name can be used, but by convention, a name is selected that describes the migration. This is the first migration, so the generated class contains code to create the database schema. The database schema is based on the model specified in the MvcMovieContext class, in the Data/MvcMovieContext.cs file.ef database update: Updates the database to the latest migration, which the previous command created. This command runs the Up method in the Migrations/{time-stamp}_InitialCreate.cs file, which creates the database.<a name="test"></a>
Run the app and select the Movie App link.
If you get an exception similar to the following, you may have missed the migrations step:
SqlException: Cannot open database "MvcMovieContext-1" requested by the login. The login failed.
SqliteException: SQLite Error 1: 'no such table: Movie'.
[!NOTE] You may not be able to enter decimal commas in the
Pricefield. To support jQuery validation for non-English locales that use a comma (",") for a decimal point and for non US-English date formats, the app must be globalized. For globalization instructions, see this GitHub issue.
<a name="dc"></a>
With EF Core, data access is performed using a model. A model is made up of entity classes and a context object that represents a session with the database. The context object allows querying and saving data. The database context is derived from Microsoft.EntityFrameworkCore.DbContext and specifies the entities to include in the data model.
Scaffolding creates the Data/MvcMovieContext.cs database context class:
The preceding code creates a DbSet<Movie> property that represents the movies in the database.
ASP.NET Core is built with dependency injection (DI). Services, such as the database context, must be registered with DI in Startup. Components that require these services are provided via constructor parameters.
In the Controllers/MoviesController.cs file, the constructor uses Dependency Injection to inject the MvcMovieContext database context into the controller. The database context is used in each of the CRUD methods in the controller.
Scaffolding generated the following highlighted code in Startup.ConfigureServices:
The ASP.NET Core configuration system reads the "MvcMovieContext" database connection string.
<a name="cs"></a>
Scaffolding added a connection string to the appsettings.json file:
For local development, the ASP.NET Core configuration system reads the ConnectionString key from the appsettings.json file.
InitialCreate classExamine the Migrations/{timestamp}_InitialCreate.cs migration file:
In the preceding code:
InitialCreate.Up creates the Movie table and configures Id as the primary key.InitialCreate.Down reverts the schema changes made by the Up migration.Open the Controllers/MoviesController.cs file and examine the constructor:
The constructor uses Dependency Injection to inject the database context (MvcMovieContext) into the controller. The database context is used in each of the CRUD methods in the controller.
Test the Create page. Enter and submit data.
Test the Edit, Details, and Delete pages.
<a name="strongly-typed-models-and-the--keyword"></a>
@model directiveEarlier in this tutorial, you saw how a controller can pass data or objects to a view using the ViewData dictionary. The ViewData dictionary is a dynamic object that provides a convenient late-bound way to pass information to a view.
MVC provides the ability to pass strongly typed model objects to a view. This strongly typed approach enables compile time code checking. The scaffolding mechanism passed a strongly typed model in the MoviesController class and views.
Examine the generated Details method in the Controllers/MoviesController.cs file:
The id parameter is generally passed as route data. For example, https://localhost:5001/movies/details/1 sets:
movies controller, the first URL segment.details, the second URL segment.id to 1, the last URL segment.The id can be passed in with a query string, as in the following example:
https://localhost:5001/movies/details?id=1
The id parameter is defined as a nullable type (int?) in cases when the id value isn't provided.
A lambda expression is passed in to the xref:System.Data.Entity.QueryableExtensions.FirstOrDefaultAsync%2A method to select movie entities that match the route data or query string value.
var movie = await _context.Movie
.FirstOrDefaultAsync(m => m.Id == id);
If a movie is found, an instance of the Movie model is passed to the Details view:
return View(movie);
Examine the contents of the Views/Movies/Details.cshtml file:
The @model statement at the top of the view file specifies the type of object that the view expects. When the movie controller was created, the following @model statement was included:
@model MvcMovie.Models.Movie
This @model directive allows access to the movie that the controller passed to the view. The Model object is strongly typed. For example, in the Details.cshtml view, the code passes each movie field to the DisplayNameFor and DisplayFor HTML Helpers with the strongly typed Model object. The Create and Edit methods and views also pass a Movie model object.
Examine the Index.cshtml view and the Index method in the Movies controller. Notice how the code creates a List object when it calls the View method. The code passes this Movies list from the Index action method to the view:
When the movies controller was created, scaffolding included the following @model statement at the top of the Index.cshtml file:
The @model directive allows access to the list of movies that the controller passed to the view by using a Model object that's strongly typed. For example, in the Index.cshtml view, the code loops through the movies with a foreach statement over the strongly typed Model object:
Because the Model object is strongly typed as an IEnumerable<Movie> object, each item in the loop is typed as Movie. Among other benefits, the compiler validates the types used in the code.
[!INCLUDEs]
[!div class="step-by-step"] Previous Adding a View Next Working with SQL
:::moniker-end