THIS WILL BE WRITTEN IN C# PLEASE INCLUDE DATABASE DUMP AND INFORMATION FROM MYSQL; PLEASE DO NOT NOTEPAD YOUR ANSWER. I CANNOT SEE OR READ WRITING. PLEASE INCLUDE ALL RELEVANT CODE TYPED. PLEASE SHOW DUMPS. THANK YOU

SEE OTHER CHEGG PROBLEM HERE: https://www.chegg.com/homework-help/questions-and-answers/user-class-sql-simply-get-results-c-app-userid-userpw-userencryptedmd5-userid-userpw-kimp--q30618504

OBJECTIVE: Ask the used to enter a username and password, then check if a user exists with the given information. Display "Login Successful" or "Login Failed" based on your query.

Start a new project in Visual Studio called "db_07" and add the MySQL reference.

Prompt the user to enter a username and a password. (2 prompts)

Select against the users table. Use the encrypted password column in your select with the C# MD5 function. Do not select against the "password" column.

If found, display the users information ( userId, firstname, lastname, dob, gender, occupationId )

If not found output the message Login Failed.