C# insert into FK table asp.net
<p>How can I insert into foreign key table in asp.net? I just have a problem with inserting the foreign attribute.. i need to insert into employee table with FK attribute which is the department id. 
I have problem with this query:  </p>

<pre><code>string insCmd = "insert into emp(id, name, phone, email) values (@id, @name, @phone, @email); select identity_scope;"; 
</code></pre>

<p>i didn't get any errors but the insertion does not occur. thanks..</p>
