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 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 Razor pages.
- Use a datatable to show data, it throw an AJAX to get all books.
- Use a api controller to get and delete books.
- Use Razor sintax in the page, to list books.
- Has a one Razor view to Upsert(Update and Insert).
- 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.
-
Created with C# 8, Asp .Net Core 3.1, Entity Framework, Razor, SqlServer 2019, HTML, Boostrap and JQuery.
-
Using Visual Studio 2019.
Author: Sinuhé Cortés V.