- .NET Core 5.0.1
- ASP.NET Core MVC
- ASP.NET Core Razor Pages
- C#
- Entity Framework Core
- GitHub
- HTML
- MySQL
- MySQL Workbench
- VS Code
This is a C#/.NET machine and engineer tracker app for a factory. It allows the user to input new engineers and machines. The user can view a list of all engineers and machines and add engineers to machines that they service.
- Internet browser
- A code editor such as VSCode to view and edit the code
- .NET or follow along with the Installing .NET instructions to install .NET
- Click on the link to my repository: https://github.com/maryleemarks/Factory.Solution
- Click on the green "Code" button and copy the repository URL
- Open your terminal and use the command
git clone https://github.com/maryleemarks/Factory.Solution
into the directory you would like to clone the repository - Open in text editor to view code and make changes
In order to run the application, please install .NET for your computer to recognize the dotnet
command.
- Download .NET Core SDK (Software Development Kit). Clicking this link will prompt a file download for your particular OS from Microsoft.
- Open the file. Follow the installation steps.
- Confirm the installation is successful by opening your terminal and running the command
dotnet --version
. The response should be something similar to this:5.0.100
. This means it was successfully installed.
MySQL is a type of database software used to create, edit, query, and manage SQL data.
-
For Mac Users please Click Here to download MySQL Installer
-
For Windows Users please Click Here
-
Verify MySQL installation by opening the terminal and entering the command
mysql -uroot -p[THEPASSWORDYOUSELECTED]
-
If you gain access you will see see the MYSQL command line!
- Please Click Here to install the correct version for your machine
- Open MySQL Workbench and select
Local instance 3306 server
. You will need to enter the password you selected
- Navigate to the Factory folder in the command line
- Use the command
dotnet build
to compile
- Navigate to the Factory folder in the command line
- Use the command
dotnet restore
Expand for Database Installation Essentials!
Create a connection string to connect the database to the web application
- Create a file in the root directory called
appsettings.json
- Add the code below:
{
"ConnectionStrings": {
"DefaultConnection": "Server=localhost;Port=3306;database=[YOUR-DATABASE-NAME-HERE];uid=[YOUR-USERNAME-HERE];pwd=[YOUR-PASSWORD-HERE];"
}
}
- Update all the information above in the square brackets. Change the server, port, and uid if necessary.
- Navigate to
Factory
directory in terminal - To create a migration in the root directory of the project, use the command:
dotnet ef migrations add Initial
- Use the command
dotnet ef database update
to update the database migration through Entity Framework Core
- Open MySQL Workbench
- Click on Server > Data Import in the top navigation bar
- Select
Import from Self-Contained File
- Select the
Default Target Schema
or create new schema - Select all Schema Objects you would like to import
- Select
Dump Structure and Data
- Click
Start Import
- To view in browser, navigate to Factory folder in the command line
- Use the command
dotnet run
to execute the compiled code and start a localhost - In browser navigate to http://localhost:5000
- None
MIT
- Mary Marks maryleemarks@gmail.com