In this lesson, you learned all about modifying data in a database. You will be using the same chinook database that you used in the previous assignment. However, you will create methods to insert, update, and delete rows from the Customer and Invoice tables.

Create a console application that prompts a user to insert a new record with the following:

FirstName

LastName

Country

Email

You need to create insert, update, and delete methods to modify the data in the Invoice and Customer tables. However, your console application only allows users to insert a new record into the Customer table of the chinook database.

Your methods should insert and update data to the following columns:

Customer Table:

CustomerId $($int$)$

FirstName $($string$)$

LastName $($string$)$

Country $($string$)$

Email $($string$)$

Invoice Table:

InvoiceId $($int$)$

CustomerId $($int$)$

InvoiceDate $($datetime$)$

Total $($decimal$)$

You do not need to insert values to the CustomerId or InvoiceId columns because the database generates an ID for the tables.

Please provide inserts, updates and deletes