How to connect a SQLite database with entity Framework 6 (RPM)

To EF6 Code First mode support SQLite has a few steps:

One, need to install Sqlite-netfx451-setup-bundle-x86-2013-1.0.92.0.exe to let vs add ado with SQLite optional

1) go to Http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki to download the corresponding. NET version of the installation file (* Note the download file name with bundle, This will do plug-in support for VS)

2) Installation

To select all installations

Tick the two check boxes below to support vs

Then the next step ...

This interface will stay for a long time, but do not care about it, not to manually close it, this is registered vs plug-in

When you see this, you can turn on vs for SQLite add

3) Vs Add entity model

You'll see this, and then you can have fun with SQLite.

Second, EF6 support

When the first step is complete, the program can use EF's code frist, but there is also the problem that the program will not be able to find System.Data.Sqlite program support when running on other computers, unless you repeat the first step.

The System.Data.Sqlite package in Nuget solves this problem.

1) Installing the NuGet package

Find SQLite online in the NuGet admin interface, add the first one, and add three more.

At this point, you can use EF6 to access the SQLite database at vs.

How to connect a SQLite database with entity Framework 6 (RPM)