2

I have installed the System.Data.SQLite.Core package with NuGet as described in the System.Data.SQLite at FAQ: (5) Is there a NuGet package?.

How can I enable the design-time support in Visual Studio 2013?

enter image description here

James Allman
  • 40,573
  • 11
  • 57
  • 70

2 Answers2

5

Apparently, at least as of version 1.0.93, the NuGet packages do not provide the designer components.

Only the bundle available on the System.Data.SQLite Download Page installs the necessary components:

sqlite-netFx451-setup-bundle-x86-2013-1.0.93.0.exe

This setup package features the mixed-mode assembly and will install all the necessary runtime components and dependencies for the x86 version of the System.Data.SQLite 1.0.93.0 (3.8.5) package. The Visual C++ 2013 Update 2 runtime for x86 is included. The .NET Framework 4.5.1 is required. This is the only setup package that is capable of installing the design-time components for Visual Studio 2013.

Setup

And now the option is available when adding a connection:

sqlite

James Allman
  • 40,573
  • 11
  • 57
  • 70
2

I don't know if you got it to work, but for me your steps were only half the story. A lot of additional fiddling around was required to generate an EDMX. Posted the steps here: Database first create entity framework 6.1.1 model using system.data.sqlite 1.0.93

Hope it helps.

Community
  • 1
  • 1
TomL
  • 392
  • 1
  • 7