I want to introduce you in a library that I usually used to read excel file in C#. It’s called ExcelDataReader, it’s lightweight library for reading excel files. I will not discuss more about it, you can just to the github repository to the details about it. Create a new Windows Forms Project. Then add […]
Library Management using ASP.Net MVC (Part 6) Borrowing and returning a book
In this part we will be finishing up the functionality to assign a book to a customer and returning the book. Now let’s update our View for Create and Edit page of BorrowHistory. Copy and paste this for your BorrowHistory create view. Then this code for your BorrowHistory Edit view. Then change you BorrowHistories Controller […]
Library Management using ASP.Net MVC (Part 5) Eager Loading and Projection
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 […]
Library Management using ASP.Net MVC (Part 4) Entity Framework Relationship and Navigation Properties
In this article we will start looking at the relationship of the customer and book model and how we can keep track on 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 […]
Library Management using ASP.Net MVC (Part 3) Adding the Customers
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 […]
Library Management using ASP.Net MVC (Part 2) Request Lifecycle
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 […]
Library Management using ASP.Net MVC (Part 1) Books CRUD Function
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 […]