A C# application built with ASP.NET Core, Entity to integrate MySQL databases, and Identity for authentication / authorization
- C#
- HTML
- JavaScript
- CSS
- MySQL
- Entity
- Identity
- Bootstrap
- ASP.NET Core
Learn To React is a C# web application to serve as a tutorial companion to learnhowtoprogram's React course. On the splash page, the user is presented with general information about the course. Once a user registers and logs in, they are able to view their dashboard and access all of the lessons available. Each user is linked to SQL database tables containing boolean values as to whether they have completed lessons in all of the courses. Once the user has marked all of the lessons complete, they are presented with a certificate of completion. By employing Entity and LINQ syntax, user submit inputs trigger boolean state changes that are passed to the respective mySQL database tables through Post requests. This application showcases our team's flexibility in using multiple One-To-One relationships in connecting an ASP.NET core web framework with mySQL databases using Entity, as well as handle authorization/authentication with Identity.
- go to https://dev.mysql.com/downloads/ and install MySQL Community Server and MySQL Workbench for your operating system
- follow the instructions at learnhowtoprogram for proper installation
- clone repository from https://github.com/ryan-spencer1220/React.Solution.git
- navigate to the project directory in your terminal/command line
- navigate to the subdirectory React and enter
dotnet restore
to install project dependencies
- navigate to the subdirectory Factory and create the file
appsettings.json
- add the following code:
{
"ConnectionStrings": {
"DefaultConnection": "Server=localhost;Port=3306;database=[YOUR_DATABASE];uid=[YOUR_USER_ID];pwd=[YOUR_PASSWORD];"
}
}
- replace the applicable sections with your database name, your user ID, and your password
- navigate to the project directory in your terminal/command line
- navigate to the subdirectory React and enter
dotnet ef database update
to create a new local database for the project - the database will take the name specified in your
appsettings.json
file and can be viewed using MySQL
- navigate to the subdirectory React and enter
dotnet run
for a snapshot server ordotnet watch run
for a live updating server for the application - access the server in your browser by entering
localhost:5000
into your navigation bar - click the hyperlinks and submit forms to navigate between the views
- enter
ctrl
+c
for Windows orcommand
+.
for Mac in your terminal/command line to stop the server
- None
MIT License
[email protected] | [email protected] | [email protected] | [email protected] | [email protected] | [email protected]