Click here to Skip to main content
14,665,452 members
Rate this:
Please Sign up or sign in to vote.
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

<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:
<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
Updated 19-Jul-20 0:39am

Rate this:
Please Sign up or sign in to vote.

Solution 1

   
Rate this:
Please Sign up or sign in to vote.

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!
   
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 😊

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




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100