title: Entity Framework 4, inserting with foreign key value not ID
body: <p>This is pretty basic question I am sure but it's baffling me now :S</p>
  
  <p>I have 2 tables, Students and Courses with a foreign key constraint, Many Students to 1 Course.</p>
  
  <p>I store in my Students table a CourseId_FK reference, so when I am creating a Student how would I be able to do something like this?</p>
  
  <pre><code>Students student = new Students();
  student.Name = Bob;
  student.Course.CourseName = "Geography";
  db.SaveChanges();
  </code></pre>
  
  <p>Right now, the above doesn't work and I have to resolve to</p>
  
  <pre><code>student.CourseId = 22;
  </code></pre>
  
  <p>Can anyone help me pls?</p>
  
  <p>Thanks</p>
  
  <p>David</p>