.NET6 Razor Pages CRUD Operations With Entity Framework Core

In this article, we will do a small demo of the AspNetCore 6 Razor Pages CRUD operation.

Create A .NET6 Razor Pages Application:

• Here 'AddRazorPages' service is registered.

• The 'UseExceptionHandler()' loads a generic exception page for the production environment.
• The 'UseHsts()' adds the Strict-Transport-Security header.
• The 'UseHttpsRedirection', HTTP request redirect to HTTPS.
• The 'UseStaticFiles', load static files like CSS, JS, Images, etc.
• The 'UseRouting' middleware is where the routing decisions are made.
• The 'UseAuthorization()' protect against unauthorized or unauthenticated users.
• The 'MapRazorPages()' enables endpoint routing for the Razor Pages.

SQL Query To Create A Sample Table:

CREATE TABLE [dbo].[Cake] (
    [Id]          INT             IDENTITY (1, 1) NOT NULL,
    [Name]        VARCHAR (MAX)   NULL,
    [Price]       DECIMAL (18, 2) NULL,
    [Description] VARCHAR (MAX)   NULL
);

Entity Framework Core:

Install Entity Framework Core NuGet:

Setup Entity Framework Core DatabaseContext:

1. namespace Dot6.Razor.Crud.Demo.Data.Entities;
2. public class Cake
3. public int Id { get; set; }
4. public string Name { get; set; }
5. public decimal Price { get; set; }
6. public string Description { get; set; }

To manage or control all the table classes we have to create DatabaseContext class. So let's create our context class like 'MyWorldDbContext.cs' in the 'Data' folder.

1. using Dot6.Razor.Crud.Demo.Data.Entities;
2. using Microsoft.EntityFrameworkCore;
3. namespace Dot6.Razor.Crud.Demo.Data;
4. public class MyWorldDbContext : DbContext
5. public MyWorldDbContext(DbContextOptions<MyWorldDbContext> options) : base(options)
6. public DbSet<Cake> Cake { get; set; }

• (Line: 6) The 'Microsoft.EntityFrameworkCore.DbContext' needs to be inherited by our 'MyWorldDbContext' to act as a Database context class.
• (Line: 8) The 'Microsoft.EntityFrameworkCore.DbContextOptions' is instance of options that we are going to register in 'Program.cs' like 'ConnectionString', 'DatabaseProvider', etc.
• (Line: 12) All our table classes must be registered inside of our Database context class with 'DbSet<T>' so that the entity framework core can communicate with the tables of the database.

"ConnectionStrings":{
    "MyWorldDbConnection":"your_connection"
}

Register the Database Context service in the 'Program.cs' file for dependency injection.

1. builder.Services.AddDbContext<MyWorldDbContext>(options =>
2. options.UseSqlServer(builder.Configuration.GetConnectionString("MyWorldDbConnection"));

Read Operation:

1. using Dot6.Razor.Crud.Demo.Data;
2. using Dot6.Razor.Crud.Demo.Data.Entities;
3. using Microsoft.AspNetCore.Mvc;
4. using Microsoft.AspNetCore.Mvc.RazorPages;
5. using Microsoft.EntityFrameworkCore;
6. namespace Dot6.Razor.Crud.Demo.Pages.Cakes;
7. public class IndexModel : PageModel
8. private readonly MyWorldDbContext _myWorldDbContext;
9. public IndexModel(MyWorldDbContext myWorldDbContext)
10. _myWorldDbContext = myWorldDbContext;
11. public List<Cake> AllCakes = new List<Cake>();
12. public async Task<IActionResult> OnGetAsync()
13. AllCakes = await _myWorldDbContext.Cake.ToListAsync();
14. return Page();

• (Line: 8) To make our c# class as Razor Page model it needs to inherit the 'Microsoft.AspNetCore.Mvc.RazorPages.PageModel'.
• (Line: 11) Injecting Database context into our Razor Page model.
• (Line: 16) Declared a variable of a type that is collection 'Cake' to hold the data from the database and then bind the data to the UI.
• (Line: 18-22) The default method executed for the razor page HTTP Get request is 'OnGet' or 'OnGetAsync'. It is always ideal to have one method for each HTTP verbs like 'GET', 'POST'. There is an option to customize the name of the HTTP GET request method then it should be like 'OnGet{YourCustomName}' or 'OnGet{YourCustomName}Async', but if we customize the method name then we have to specify the custom name as value to the query parameter 'handler'. So don't give the custom name unless it is required. Inside of Our 'OnGetAsync' method we have implemented our logic to fetch the data from the database.

Pages/Cakes/Index.cshtml:

1. @page "/cake/home"
2. @using Dot6.Razor.Crud.Demo.Data.Entities
3. @model Dot6.Razor.Crud.Demo.Pages.Cakes.IndexModel
4. <div class="container">
5. <div class="row">
6. @foreach (var item in Model.AllCakes)
7. <div class="col-md-3 m-3">
8. <div class="card" style="width: 18rem;">
9. <div class="card-body">
10. <h5 class="card-title">@item.Name</h5>
11. <h6 class="card-subtitle mb-2 text-muted">@item.Price $</h6>
12. <p class="card-text">@item.Description</p>
13. </div>
14. </div>
15. </div>
16. </div>
17. </div>

• (Line: 1) Using the '@page' directive we can define route to our Razor Page.
• (Line: 3) Define the model which is the class name of the 'Index.cshtml.cs' file.
• (Line: 7-18) Loop the data to bind to UI.

Now run the application and then navigate to route "/cake/home".

Create Operation:

1. namespace Dot6.Razor.Crud.Demo.Vms;
2. public class CakeVm
3. public int Id { get; set; }
4. public string Name { get; set; }
5. public decimal Price { get; set; }
6. public string Description { get; set; }

1. using Dot6.Razor.Crud.Demo.Data;
2. using Dot6.Razor.Crud.Demo.Data.Entities;
3. using Dot6.Razor.Crud.Demo.Vms;
4. using Microsoft.AspNetCore.Mvc;
5. using Microsoft.AspNetCore.Mvc.RazorPages;
6. namespace Dot6.Razor.Crud.Demo.Pages.Cakes;
7. public class CreateModel : PageModel
8. private readonly MyWorldDbContext _myWorldDbContext;
9. public CreateModel(MyWorldDbContext myWorldDbContext)
10. _myWorldDbContext = myWorldDbContext;
11. [BindProperty]
12. public CakeVm CakeVm { get; set; }
13. public IActionResult OnGet()
14. return Page();
15. public async Task<IActionResult> OnPostAsync()
16. var entry = _myWorldDbContext.Add(new Cake());
17. entry.CurrentValues.SetValues(CakeVm);
18. await _myWorldDbContext.SaveChangesAsync();
19. return Redirect("home");

• (Line: 17) The 'CakeVm' will be used to store the form data. By decorating the property with the 'BindProperty' attribute we are enhancing capability like storing the form data onto it directly without any explicit mapping.
• (Line: 18-21) The 'OnGet()' method loads the create a form to us.
• (Line: 23-29) The 'OnPostAsync' method gets invoked for the post request.
• (Line: 25) Attaching the empty 'Cake' instance to Database Context, now that state is 'Added' means read to save to database.
• (Line: 26) Updating the value of 'Cake' instance which is added to Database Context at Line:25. So this approach we no need to map the properties explicitly between the 'Cake' and 'CakeVm' objects.
• (Line: 27)Saving changes to the database by calling the 'SaveChangeAsync()' method.
• (Line: 28) Redirecting back to the '/cake/home' page.

Pages/Cakes/Create.cshml:

1. @page "/cake/create"
2. @model Dot6.Razor.Crud.Demo.Pages.Cakes.CreateModel
3. <div class="container">
4. <div class="row ">
5. <div class="col-md-6 offset-md-3">
6. <form method="POST">
7. <legend>Create A New Cake</legend>
8. <div class="mb-3">
9. <label for="txtName" class="form-label">Name</label>
10. <input asp-for="CakeVm.Name" type="text" class="form-control" id="txtName" />
11. </div>
12. <div class="mb-3">
13. <label for="txtCost" class="form-label">Cost</label>
14. <input asp-for="CakeVm.Price" type="text" class="form-control" id="txtCost" />
15. </div>
16. <div class="mb-3">
17. <label for="txtDescription" class="form-label">Cost</label>
18. <textarea asp-for="CakeVm.Description" type="text" class="form-control"
19. id="txtDescription"></textarea>
20. </div>
21. <button type="submit" class="btn btn-primary">Submit</button>
22. </form>
23. </div>
24. </div>
25. </div>

• (Line: 1) Defined Razor Page route.
• (Line: 2) Register the Model.
• (Line: 4-28) Rendering a form to create a new record. Here each input HTML field is bound with our object that is 'CakeVm' with help of the 'asp-for' tag helper. So any data entered to the form and on submitting the form then the form data values directly stored into the 'CakeVm'(because it is decorated with 'BindProperty' attribute).

Let's add a button in the 'Index.csthml' so on the click it navigates us to our create page.

1. <!-- Code hidden for display purspose -->
2. <div class="container">
3. <div class="row">
4. <div class="col-md-4 offset-md-4">
5. <a asp-page="./create" class="btn btn-primary">Create New Cake</a>
6. </div>
7. </div>
8. <div class="row">
9. @foreach (var item in Model.AllCakes)
10. </div>
11. </div>

step1:step2:
step3:

Update Operation:

1. using Dot6.Razor.Crud.Demo.Data;
2. using Dot6.Razor.Crud.Demo.Data.Entities;
3. using Dot6.Razor.Crud.Demo.Vms;
4. using Microsoft.AspNetCore.Mvc;
5. using Microsoft.AspNetCore.Mvc.RazorPages;
6. using Microsoft.EntityFrameworkCore;
7. namespace Dot6.Razor.Crud.Demo.Pages.Cakes;
8. public class EditModel : PageModel
9. private MyWorldDbContext _myWorldDbContext;
10. public EditModel(MyWorldDbContext myWorldDbContext)
11. _myWorldDbContext = myWorldDbContext;
12. [BindProperty]
13. public CakeVm? CakeVm { get; set; }
14. public async Task<IActionResult> OnGetAsync(int id)
15. CakeVm = await _myWorldDbContext.Cake
16. .Where(_ => _.Id == id)
17. .Select(_ =>
18. new CakeVm
19. Description = _.Description,
20. Id = _.Id,
21. Name = _.Name,
22. Price = _.Price
23. }).FirstOrDefaultAsync();
24. if (CakeVm == null)
25. return NotFound();
26. return Page();
27. public async Task<IActionResult> OnPostAsync(int id)
28. var cakeToUpdate = await _myWorldDbContext.Cake.FindAsync(id);
29. if (cakeToUpdate == null)
30. return NotFound();
31. if (await TryUpdateModelAsync<Cake>(
32. cakeToUpdate,
33. "CakeVm",
34. c => c.Name, c => c.Description, c => c.Price
35. await _myWorldDbContext.SaveChangesAsync();
36. return Redirect("home");
37. return Page();

• (Line: 18-19) The 'CakeVm' property captures form data on page post, which is possible because of attributes 'BindProperty'.
• (Line: 21-39) The 'OnGetAsync()' to load the form with data that needs to be updated.
• (Line: 23-32) Fetch the record by 'id'(query parameter) and assign the data to our 'CakeVm' property.
• (Line: 41-61) The 'OnPostAsync()' gets invoked for the Post request.
• (Line: 43) Fetch the data from the database that needs to be updated.
• (Line: 50-58) The 'TryUpdateModelAsync()' method helps to copy the data from the 'CakeVm' to 'cakeToUpdate'(variable of type Cake). Only specified props will be copied to the destination object. On invoking the 'SaveChangesAsyn()' updates the data to the database.

Pages/Cakes/Edit.cshtml:

1. @page "/cake/edit"
2. @model Dot6.Razor.Crud.Demo.Pages.Cakes.EditModel
3. <div class="container">
4. <div class="row ">
5. <div class="col-md-6 offset-md-3">
6. <form method="POST">
7. <legend>Update A New Cake</legend>
8. <div class="mb-3">
9. <label for="txtName" class="form-label">Name</label>
10. <input asp-for="CakeVm.Name" type="text" class="form-control" id="txtName" />
11. </div>
12. <div class="mb-3">
13. <label for="txtCost" class="form-label">Cost</label>
14. <input asp-for="CakeVm.Price" type="text" class="form-control" id="txtCost" />
15. </div>
16. <div class="mb-3">
17. <label for="txtDescription" class="form-label">Cost</label>
18. <textarea asp-for="CakeVm.Description" type="text" class="form-control"
19. id="txtDescription"></textarea>
20. </div>
21. <button type="submit" class="btn btn-primary">Submit</button>
22. </form>
23. </div>
24. </div>
25. </div>

• (Line: 1) Defined route for our Razor Page.
• (Line: 2) Defined the Model for our Razor Page.
• (Line: 4-28)  Render the edit form. Each field binding is enabled by the 'asp-for' razor tag.

In 'Index.cshtml' add the 'Edit' button to our records.

1. <!-- code hidden for display purpose -->
2. <div class="card" style="width: 18rem;">
3. <div class="card-body">
4. <h5 class="card-title">@item.Name</h5>
5. <h6 class="card-subtitle mb-2 text-muted">@item.Price $</h6>
6. <p class="card-text">@item.Description</p>
7. <a asp-page="./edit" asp-route-id="@item.Id" class="btn btn-primary">Edit</a>
8. </div>
9. </div>

• (Line: 7) Added anchor tag as 'Edit' button, the route defined at 'asp-page' helper tag, and then query parameter defined at 'asp-route-id' tag helper.

Delete Operation:

1. using Dot6.Razor.Crud.Demo.Data;
2. using Dot6.Razor.Crud.Demo.Vms;
3. using Microsoft.AspNetCore.Mvc;
4. using Microsoft.AspNetCore.Mvc.RazorPages;
5. using Microsoft.EntityFrameworkCore;
6. namespace Dot6.Razor.Crud.Demo.Pages.Cakes;
7. public class DeleteModel : PageModel
8. private readonly MyWorldDbContext _myWorldDbContext;
9. public DeleteModel(MyWorldDbContext myWorldDbContext)
10. _myWorldDbContext = myWorldDbContext;
11. public string ErrorMessage { get; set; }
12. public CakeVm? CakeVm { get; set; }
13. public async Task<IActionResult> OnGetAsync(int id, bool? saveChangesError)
14. CakeVm = await _myWorldDbContext.Cake
15. .Where(_ => _.Id == id)
16. .Select(_ =>
17. new CakeVm
18. Description = _.Description,
19. Id = _.Id,
20. Name = _.Name,
21. Price = _.Price
22. }).FirstOrDefaultAsync();
23. if (CakeVm == null)
24. return NotFound();
25. if (saveChangesError ?? false)
26. ErrorMessage = $"Error to delete the record id - {id}";
27. return Page();
28. public async Task<IActionResult> OnPostAsync(int id)
29. var recordToDelete = await _myWorldDbContext.Cake.FindAsync(id);
30. if (recordToDelete == null)
31. return Page();
32. _myWorldDbContext.Cake.Remove(recordToDelete);
33. await _myWorldDbContext.SaveChangesAsync();
34. return Redirect("./home");
35. catch
36. return Redirect($"./delete?id={id}&saveChangesError=true");

• (Line: 17) The 'ErrorMessage' property display the delete error message.
• (Line: 18) The 'CakVm' displays the data on the delete confirmation page.
• (Line: 19-41) The 'OnGetAsync' method to loads the data to display for the delete confirmation page.
• (Line: 20-31) Load the record to delete from the database by 'id'.
• (Line: 36-39) Based on the 'saveChangesError' boolean value populating the error message. One thing to remember is 'true' value will be assigned to 'saveChangeError' only from the 'OnPostAsync' method when an error occurs on deleting the record.
• (Line: 43-62) The 'OnPostAsync' method gets invoked on confirm delete post request.
• (Line: 45) Fetching the record from the database by 'id'.
• (Line: 54-55) Deleting the record from the database.
• (Line: 56) After successful delete navigating back to the home page.
• (Line: 60) An error occurs on deleting the record then we will redirect to the same 'Delete' page by assigning the 'saveCahgesError' query parameter value 'true' for displaying the error message.

Now in 'index.cshtml' add the 'Delete' button.

<a asp-page="./delete" asp-route-id="@item.Id" class="btn btn-danger">Delete</a>

Support Me!
Buy Me A Coffee PayPal Me

Wrapping Up:

Refer:

Follow Me: