Application web to make CRUD operations for a books, with Entity framework saving data in SqlServer.
To create a CRUD operations, framework get own flow, first you have to create a model, run migrations, configurate proyect, then create a controoler with actions to link to razor page to show data, and the databinding is passed by .cs page, finally add CRUD, logic.
To make a CRUD operations to manage book's data.
- Create DbContext.
- Create a model.
- Create a migration and run it.
- Create controller.
- Create razor views.
- Use a datatable to show data, it throw an AJAX to get all books.
- It validates two ways (client and server side).
Nuget packages added to proyect:
-
Runtime compilation support for Razor views and Razor Pages in ASP.NET Core MVC.
-
Entity Framework Core is a lightweight and extensible version of the popular Entity Framework data access technology.
-
Microsoft SQL Server database provider for Entity Framework Core.
-
Entity Framework Core Tools for the NuGet Package Manager Console in Visual Studio.
-
Code Generation tool for ASP.NET Core. Contains the dotnet-aspnet-codegenerator command used for generating controllers and views.
-
Created with C# 8, Asp .Net Core 3.1, Entity Framework, Razor pages, SqlServer 2019, HTML, Boostrap and JQuery.
-
Using Visual Studio 2019.
Author: Sinuhé Cortés V.