title: specifying the foreign key to the table programmatically by using fluentapi
body: <p>hi is there any possibility to assign a foriegnkey to table using entity ....</p>
  
  <p>pls see this question for clarification..    <a href="https://stackoverflow.com/questions/7119764/how-do-add-a-single-entry-for-two-tables-using-linq-to-entities">how do add a single entry for two tables using linq to entities</a></p>
  
  <p>let me explain clearly.....</p>
  
  <pre><code>      i have a product table    product_id
                                  product_name 
                                  product_description
                                  category_id
  
  
                                  category table
                                  category_id
                                  category_name 
  </code></pre>
  
  <p>unfortunately it is not posssible to specify the category_id as a foreign key at the time of creating table the entity table it self taken the category_id as a column not as a foreign key </p>
  
  <p>so.. i want to specify this one as foreign key so.. is it possible to specify as a foreign key by programmatically 
   can any one have sample code for specifying foreignkey using fluent api</p>