Employee - Designation has a 1 - many relationship.
So Employee table will have a DesignationID as a foreign key (basic RDBMS concepts).
Now you can get Employee's details along with Designation details using a simple
JOIN[
^].
Once you have formulated the query, write it using LINQ. And if you don't LINQ, spend some time learning it (or use a
converter[
^] :D )