title: Adding index to a table
body: <p>I have a table <code>Person</code>: <code>id, name</code></p>
  
  <p>I often have queries like: </p>
  
  <pre><code>select * from Person where name Like "%abc%".
  </code></pre>
  
  <p>I have 2 questions:</p>
  
  <ol>
  <li>How do I implement this query using code-first 5 (CTP5)</li>
  <li>How do I add an index on the name column to make data retrieval faster based on name like in the query?</li>
  </ol>