Setting up SQLite and EF6

Here is something that is more difficult than it should be.

My answer on StackOverflow:

http://stackoverflow.com/questions/29129796/no-entity-framework-provider-found-for-ef-6-and-sqlite-1-0-96-0

My environment:

VS2013 Pro

Entity Framework 6: version 6.1.3

Sqlite .net library: System.Data.SQLite versions: 1.093 - 1.095

Do not use Nuget Manager to download 

Useful sqlite system queries

List tables and indexes in SQlite database:

SELECT * FROM sqlite_master


List columns for a table:

pragma table_info()