.net framework data provider for sqlite missing in visual studio 2019

Question

0.00/5 (No votes)

See more:

Is there any SQLite DDEX provider package available for Visual studio 2019?

I've tried to add ADO.NET Entity Data Model item to my WPF project, it was not listing SQLite data provider in the "Choose Data Source" dialog box to create a data connection

What I have tried:

I've created a WPF project in .NET framework version 4.7.2 and I've installed a NuGet package for System.Data.Sqlite v1.0.113.1 that includes following packages

XML

<packages>
  <package id="EntityFramework" version="6.3.0" targetFramework="net472" />
  <package id="System.Data.SQLite" version="1.0.113.1" targetFramework="net472" />
  <package id="System.Data.SQLite.Core" version="1.0.113.1" targetFramework="net472" />
  <package id="System.Data.SQLite.EF6" version="1.0.113.0" targetFramework="net472" />
  <package id="System.Data.SQLite.Linq" version="1.0.113.0" targetFramework="net472" />
</packages>

Here is my App.Config file:

XML

<configuration>
  <configSections>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.7.2" />
  </startup>
  <entityFramework>
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
      <provider invariantName="System.Data.SQLite.EF6" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />
    </providers>
  </entityFramework>
  <system.data>
    <DbProviderFactories>
      <remove invariant="System.Data.SQLite.EF6" />
      <add name="SQLite Data Provider (Entity Framework 6)" invariant="System.Data.SQLite.EF6" description=".NET Framework Data Provider for SQLite (Entity Framework 6)" type="System.Data.SQLite.EF6.SQLiteProviderFactory, System.Data.SQLite.EF6" />
    <remove invariant="System.Data.SQLite" /><add name="SQLite Data Provider" invariant="System.Data.SQLite" description=".NET Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite" /></DbProviderFactories>
  </system.data>
</configuration>

Posted 18-Jul-20 19:55pm

rameshk553

Updated 19-Jul-20 0:39am

Add a Solution

2 solutions

Solution 1

System.Data.SQLite: Home[^]

Posted 18-Jul-20 22:25pm

Richard MacCutchan

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Accepted Answer · 2020-07-19T00:39:00

Solution 2

Hi,

It looks like you have used Nuget packages. They are for your application and not to provide a provider. As far I am aware (did a quick Google too), believe there is no official DDEX provider package for VS 2019. Seems you can try the following though: EF6 workflow with SQLite DDEX provider · ErikEJ/SqlCeToolbox Wiki · GitHub[^]

Hope it helps!

Posted 19-Jul-20 0:39am

Sandeep Mewara

Comments

rameshk553 19-Jul-20 8:30am

Thanks Sandeep, it worked for me!

Sandeep Mewara 19-Jul-20 9:11am

Great to know.

rameshk553 19-Jul-20 10:13am

Done 😊

Member 15044677 14-Feb-21 0:59am

Thanks a lot, but three is no option for "Add Entity Data Model (EDMX) to current Project". I install this tool box but I don’t know how to interact (query, insert and update,....) in C# windows forms (.net framework). Is there any video for training more.