This application lets the user create an account and login to organize their personal library or virtual reading shelves, letting them add books and authors. Ability to add multiple authors to a book or multiple books to an author is included, in addition to edit and delete functionality.

This project was developed in C# on the .NET Core platform with ASP.NET Core web processing, using MVC pattern libraries, Razor dynamic templating, and a SQL database. Specifically, the app was built using Entity Framework and MySQL to create the schema, and it's hosted on GitHub.

• C#, HTML, CSS
• Razor view on pages
• MVC pattern (with ASP .NET Core 2.2)
• RESTful routing and CRUD
• many-to-many database relationships
• Entity framework migrations
• Identity and authorization
• Asynchronous code
• MySQL Workbench and server
• Bootstrap library
• Behavior driven development (BDD)
• Git version control and GitHub

Download or clone the repository to run this program locally! This program requires .NET Core SDK to run. Here is a free tutorial for installing .NET on Mac or Windows 10.

• Download or clone this repo.
  • To Download ZIP:
    • Select "Download" on the GitHub Repository site
    • Once downloaded, open the ZIP and extract files. The new folder will be created as 'Week-12-Advanced-Databases-and-Authentication-Project'.
  • To Clone:
    • Clone from command line into your Desktop: $ git clone https://github.com/KristaRutz/Week-12-Advanced-Databases-and-Authentication-Project
    • The new directory will be created as 'Desktop/Week-12-Advanced-Databases-and-Authentication-Project'.
• Once you have stored the files locally, execute the following commands.
  • Navigate to the application directory: $ cd Desktop/Week-12-Advanced-Databases-and-Authentication-Project/BookClub
  • $ dotnet restore
  • $ dotnet ef migrations add Initial
  • $ dotnet ef database update
  • $ dotnet build
  • $ dotnet run
• Upon success, the program will begin running in your console.

• .NET Core 2.2
  • Server-side in C#
    • C# Back-end
    • HTML, CSS, and C# front-end
• ASP .NET Core and Razor templating
  • client-side in JavaScript
• SQL database

Build an application with user authentication and a many-to-many relationship. Here are the features to include:

• The application should have user authentication. A user should be able to log in and log out. Only logged in users should have create, update and delete functionality. All users should be able to have read functionality.
• There should be a many-to-many relationship.
• A user should be able to navigate to a splash page that lists all instances of each class. Users should be able to click on an individual instance to see all the instances that belong to it.

Your code will be reviewed for the following objectives:

• Does at least one of your classes have all CRUD methods implemented in your app?
• Are you able to view both sides of the many-many relationship? For a particular instance of a class, are you able to view all of the instances of the other class that are related to it?
• Are users able to register, log in and log out with Identity?
• Is Create, Update and Delete functionality limited to authenticated users?
• Is the project in a polished, portfolio-quality state?
• [o] Was required functionality in place by the 5:00pm Friday deadline?
• Does the project demonstrate all of this week's concepts? If prompted, are you able to discuss your code with an instructor using correct terminology?

• No known bugs

Please contact me if you run into any issues or have questions, ideas or concerns. I can be contacted at [email protected]. Feel free to create a pull request for updates - contributions to the code are encouraged!

Copyright (c) 2020 Krista Rutz

This software is licensed under the MIT license.