jeudi 19 février 2015

Get SQLite to work with VS2013 Data Model Designer

I have followed very closely this great tutorial about how to connect SQLite with Visual Studio 2013, but when I get to the Entity Data Model Wizard part of the tutorial, I can't see my SQLite connection or the SQLite provider, there are only options for the SQL Server.


I have followed the tutorial very closely, I even tried to install the SQL Server Compact/SQLite Toolbox, to compile the project to x86, to install the Entity Framework Visual Studio tools, and still nothing happens.


My packages.config looks like:



<?xml version="1.0" encoding="utf-8"?>
<packages>
<package id="CommonServiceLocator" version="1.2" targetFramework="net45" />
<package id="EntityFramework" version="6.1.2" targetFramework="net45" />
<package id="NodaTime" version="1.3.0" targetFramework="net45" />
<package id="Prism" version="5.0.0" targetFramework="net45" />
<package id="Prism.Composition" version="5.0.0" targetFramework="net45" />
<package id="Prism.Interactivity" version="5.0.0" targetFramework="net45" />
<package id="Prism.Mvvm" version="1.0.0" targetFramework="net45" />
<package id="Prism.PubSubEvents" version="1.0.0" targetFramework="net45" />
<package id="System.Data.SQLite.Core" version="1.0.94.0" targetFramework="net45" />
<package id="System.Data.SQLite.EF6" version="1.0.94.0" targetFramework="net45" />
</packages>


any advices on this?


Aucun commentaire:

Enregistrer un commentaire