title: SQLite wrapper 1.0.77 and Entity Framework under .NET 4
body: <p>We are developing a windows application on .NET 4, it uses SQLite database with .NET wrapper <a href="http://sqlite.phxsoftware.com/" rel="nofollow">System.Data.SQLite</a> and Entity Framework. On deployment machine it requires .NET 4 Client Profile.</p>
  
  <p>The latest official release (1.0.66) of SQLite wraper is 2 years old. This version works with .NET 2.0 — 3.5, it's mean that we should force users to install 2 versions of .NET. Also it does not supports foreign keys.</p>
  
  <p>There is also <a href="http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki" rel="nofollow">unofficial release 1.0.77</a> which supports foreign keys, however, support of ORM (.NET Entity Framework) is broken in this version (It raises System.Data.ProviderIncompatibleException).
  I can see three ways to fix this issue:</p>
  
  <ol>
  <li>Abandon the use of this wrapper and look for other options. What would you suggest?</li>
  <li>Abandon the use of Entity Framework. This option is undesirable because it is old-school way and also require us to rewrite a lot and write more code and increate the likelihood of bugs.</li>
  <li>Try to fix an issue with 1.0.77, but I have no idea how long it can take. What would you do in this situation? What other wrappers we should look at?</li>
  </ol>