C# using visual Studio

Create a data model that includes the Employee table in the Employee.mdf database provided. Extend the entity class with a FullName property that returns the concatenation of first and last name.

Use LINQ method syntax to:

Show the set of distinct department codes from the Employee table

Show the employee names and department codes of employees with phone numbers in the $618$ area code in alphabetical order. Display a message if none exist.

Show the employee names and department codes of employees in the SL department.

Show the number of SL employees before and after each of the following changes:

Permanently move employee Thomas Smiley to department MK$.$

Add yourself as an employee to department SL$.$ Note: The only required field in the Employee table is the primary key, id$,$ which is not an identify column and not automatically assigned. Use $\text{'}$A$0062\text{'}($or higher$).$

Remove your employee record from the table.