In this article I will create a web api using ASP.Net Core 3.1 and instead of using the Entity Framework which I usually do. I will try to use Dapper. We will also use Repository pattern and Unit of Work to manage our data.
Category: ASP MVC
In this part we will be finishing up the functionality to assign a book to a customer and returning the book. Source Code: https://github.com/alexcalingasan/LibraryManagement Now let's update our View for Create and Edit page of BorrowHistory. Copy and paste this for your BorrowHistory create view. Then change your BorrowHistories Edit view code to this. Then … Continue reading Library Management using ASP.Net MVC (Part 6) Borrowing and returning a book
In this part you will learn how to get the data from the related entities using eager loading. We will also use projection to get the data that we need for the frontend. In the index page of our books, we want to see the list of books and if they are still available or … Continue reading Library Management using ASP.Net MVC (Part 5) Eager Loading and Projection
In this article, we will start looking at the relationship between the customer and book model and how we can keep track of customer borrowing history. Before we start coding we should determine first the relationship of the customer and the book. Points to consider The customer can borrow multiple books. The book can be … Continue reading Library Management using ASP.Net MVC (Part 4) Entity Framework Relationship and Navigation Properties
In this article you will learn about Entity Framework code first migration. In the first part we use Entity Framework code first to create the book model. Code first allows us to focus on creating classes for our domain requirements rather than designing a database first then create a classes to match our database. We … Continue reading Library Management using ASP.Net MVC (Part 3) Adding the Customers
It is important to understand the request lifecycle in ASP.Net MVC before we proceed with other tutorials. In this article I will briefly discuss to you how the ASP.Net MVC handles the request. When we make http request in our MVC application it will look for the registered routes in URL Routing Module to determine … Continue reading Library Management using ASP.Net MVC (Part 2) Request Lifecycle
This tutorial is about creating a library management system using asp.net mvc and in this part you will learn how to create a Model for your data, add the needed data annotation and scaffold a basic crud application for your model. Before we start coding we should identify first the user's problem that we are … Continue reading Library Management using ASP.Net MVC (Part 1) Books CRUD Function