ATM C# Project

This is a console-based application simulating an ATM's' menu options. With this project, I had 3 main goals:

• Create my first C# program and familiarize myself with the syntax
• Introduce myself to MySQL and the interactions between a program and an external database (locally hosted)
• Attempt to properly implement and familiarize myself with the SOLID principles

Latest Exe Release

ATM.exe

Dependencies

This project utilizes some additional projects and librarys:

• Autofac
• Dapper
• MySQL.data
• Database Access Library

MySQL Setup

This project will utilize a locally hosted MySQL database.

To setup the MySQL database:

• Intsall MySQL
• Run installer and install by selection using developers install option
• Reference Video

My Default Credentials for this project

• MySQL root
• pass: SQLpass

My Default MySQL Account:

MySQL user account:

• user: DBAdmin
• pass: admin

Continuing Installation:

hit next/accept defaults everywhere else

Initialization:

GUI: Database -> Connect to database -> Select stored connection -> Local instance MySQL router password -> store in vault -> MySQL root pass

Table Setup

We will create the following table: tbluseraccount

And initialize some user data:

We are now ready to use the ATM!