Write a C# program to read the specified Data from a database and display it on the screen and format it to CSV and write it to an output file your firstname_lastname_output.csv

You are required to do your own research to do this project. Questions will be asked based on the work you submit.

You can use Visual Studio if you use Windows.

If you are using Linux, you can use mono develop (linux solution preferred, but not mandatory).

1: Setup a mysql community server on your local resources (local machine or Virtual Machine on Local network etc)

2: Load the database with the employees-db-1.0.6 from (https://launchpad.net/test-db/employees-db-1/1.0.6)

Write the C# program to display the following information of all employees who are females and last name is Peac:

emp_no,

first_name,

last_name,

gender,

dept_name, from_date, to_date (employee's from date and to date in that department)

title, from_date, to_date (employee's Title's from date and to date, how long the employee held the title)

Salary, from_date, to_date (employee's Salary's from date and to date, how long the employee had that salary)

I need help with this. I have to download a sample database on visual studio and write a c# program to read a data from a database. How would i wanna do that?

2: Load the database with the employees-db-1.0.6 from (https://launchpad.net/test-db/employees-db-1/1.0.6)