title: Using .Net Entity Data Model with SQLite
body: <p>I'm attempting to convert a c# application currently running on SQL Server 2014 LocalDB over to SQLite, which appears to do the same job but is much lighter. I spent the whole day reading about it and installing various components.</p>
  
  <p>The problem is that I can't find a way to either migrate my Entity Framework 6 database schema. Nor can I successfully create a new database schema from the SQLite database. Does the Visual Studio 2013 data model designer work with SQLite? How can I get my entity objects created and working properly?</p>
  
  <p>** I'm not looking to create the database tables with a code-first model. I got my database structure already. I'm only looking to query the database with LINQ.</p>
  
  <p>I installed the SQLite package from (the one that provides design-time support for Visual Studio 2013)
  <a href="https://system.data.sqlite.org/" rel="nofollow">https://system.data.sqlite.org/</a></p>
  
  <p>I installed System.Data.SQLite (x86/x64) into my project from NuGet
  <a href="http://www.nuget.org/packages/System.Data.SQLite/" rel="nofollow">http://www.nuget.org/packages/System.Data.SQLite/</a></p>
  
  <p>I followed these instructions
  <a href="http://vijayt.com/Post/Using-SQLite-database-in-NET-with-LINQ-to-SQL-" rel="nofollow">http://vijayt.com/Post/Using-SQLite-database-in-NET-with-LINQ-to-SQL-</a></p>
  
  <p>If I go in Server Explorer, I'm able to add the SQLite connection. When I add a new item to the project "ADO.NET Entity Data Model", and then select "EF Designer from database", and then "New Connection", the only options it offers are SQL Server and SQL Server Database File. If the SQLite connection is in App.Config, it appears in the list and I can use it, but it doesn't work properly.</p>
  
  <p>So... what do I do from here?</p>