title: Sqlite with EntityFrameworkCore unique column is case sensitive. Search is also case sensitive
body: <p>I have a property <code>Name</code> in entity <code>UnitType</code> set to Unique for SQLite using EntityFrameworkCore 2.0.</p>
  
  <pre><code>modelBuilder.Entity&lt;UnitType&gt;().HasIndex(t =&gt; t.Name).IsUnique();
  </code></pre>
  
  <p>But it behaves as case sensitive. Means it considers <strong><code>Gram</code></strong> and <strong><code>gram</code></strong> as two different values and does insert them. This is clearly not what to expect after spending much of my time on MS-SQL. </p>
  
  <p>Also, another problem is when filtering data on this column. Even that is case sensitive.</p>
  
  <pre><code>db.Units.Where(w =&gt; w.Name.Contains(SearchText));
  </code></pre>
  
  <p>How to make it case insensitive?</p>