WebAPI for CRUD operations of library client app built with C# ASP.NET (.NET Framework 4.8).
This API interacts with library's database via Entity Framework.
Database file is in Database/ folder.
It has 3 tables:
- Users
CREATE TABLE [dbo].[Users] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[FullName] NVARCHAR (50) NOT NULL,
[DateOfBirth] DATE NULL,
[Address] NVARCHAR (255) NULL,
[Email] NVARCHAR (255) NOT NULL,
[Phone] NVARCHAR (20) NULL,
PRIMARY KEY CLUSTERED ([Id] ASC) );
- Books
CREATE TABLE [dbo].[Books] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[Name] NVARCHAR (255) NOT NULL,
[Author] NVARCHAR (255) NOT NULL,
[Description] NVARCHAR (MAX) NULL,
[PrintDate] DATE NULL,
[Quantity] INT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC) );
- UserBooks -
CREATE TABLE [dbo].[UserBooks] (
[UserBookID] INT IDENTITY (1, 1) NOT NULL,
[UserID] INT NOT NULL,
[BookID] INT NOT NULL,
[CheckoutDate] DATE NULL,
[ReturnDate] DATE NULL,
PRIMARY KEY CLUSTERED ([UserBookID] ASC),
FOREIGN KEY ([UserID]) REFERENCES [dbo].[Users] ([Id]),
FOREIGN KEY ([BookID]) REFERENCES [dbo].[Books] ([Id]) );