title: Ignoring accents while searching the database using Entity Framework
body: <p>I have a database table that contains names with accented characters. Like <code>ä</code> and so on.</p>
  
  <p>I need to get all records using EF4 from a table that contains some substring <em>regardless of accents</em>.</p>
  
  <p>So the following code:</p>
  
  <pre><code>myEntities.Items.Where(i =&gt; i.Name.Contains("a")); 
  </code></pre>
  
  <p>should return all items with a name containing <code>a</code>, but also all items containing <code>ä</code>, <code>â</code> and so on. Is this possible?</p>