insert query in Linq to sql

See more:

C#

SQL

LINQ

Hi all,

I was using the insert query when I faced a problem , I want to insert the foreign key , for example :

I want to insert the employee's ID in the job table where the employee's name is "XYZ" in the employees table,

I tried to select from the employees table the ID where the name is "XYZ" then insert it in the job table.

Is this a right way or what can I do else?

Thanks in advance.
:)