LibraryDemo

Demo

https://demo.kale-ryan.top/library/

Click Admin above to enter the management interface, administrator ID 1, password 123

Library management system based on ASP.NET

Use a B/S application based on ASP.NET Core, the database is MySQL, the programming language is C#, and the SDK is .NET 6. The overall MVC architecture is adopted, and the development platform uses JetBrains' Rider.

In terms of connecting the server to the database, I chose Microsoft's Entity Framework Core library as the ORM. Using this library, you can use C#'s Linq syntax to perform database operations, which will be converted into SQL statements when connecting to the database.

When stratifying projects, I roughly divide the projects into:

Entities: Entity classes that map database tables.

Dal: database operation layer

Controllers: Controllers. It is used to process Web requests and is used as the business logic layer (Bll). Because this project does not have too complex business logic processing, it is not extracted as a separate layer (such as Service).

Views: views. It is used for graphical interface display and is a .cshtml format file of HTML+CSS+C#.

Models: This Model layer is mainly used for Controllers to interact with Views.

Main structure tree of project files:

 └───Library.Web
    ├───Controllers
    ├───Dal
    ├───Entities
    ├───Migrations
    ├───Models
    │   └───EnumModels
    ├───Views
    │   ├───Account
    │   ├───Admin
    │   ├───Home
    │   └───Shared
    └───wwwroot

wwwroot stores the static resource files required by the Web page, mainly Bootstrap and jQuery libraries.

Picture display