When I create a database connection for a data model, I have the following providers:
.NET Framework Data Provider for Microsoft SQL Server Compact 4.0
.Net Framework Data Provider for MySQL
.Net Framework Data Provider for SqlServer
How would I get the a SQLite provider to show? I see mention of editing EntityDeveloper.exe.config in C:\Program Files\Common Files\Devart\EntityDeveloper, but I'm not sure how to proceed. Where do I provide the path to System.Data.SQLite.dll to make this provider appear in this list?
SQLite Provider
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: SQLite Provider
You need to add the following entry to EntityDeveloper.exe.config file in the configuration section:
Replace 1.0.105.2 here with the actual version of System.Data.SQLite.dll.
In this case System.Data.SQLite provider will be available only in the standalone Entity Developer application. If you want System.Data.SQLite to be available in Visual Studio as well, you need to add this record into the <DbProviderFactories> section of the C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config file.
Code: Select all
<system.data>
<DbProviderFactories>
<add name="SQLite Data Provider without EF6" invariant="System.Data.SQLite" description=".NET Framework Data Provider for SQLite" type="System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.105.2, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
</DbProviderFactories>
</system.data>
In this case System.Data.SQLite provider will be available only in the standalone Entity Developer application. If you want System.Data.SQLite to be available in Visual Studio as well, you need to add this record into the <DbProviderFactories> section of the C:\Windows\Microsoft.NET\Framework\v4.0.30319\Config\machine.config file.
Re: SQLite Provider
Thank you, that worked great! I've elaborated the steps I took to get this working below.
- Downloaded sqlite-netFx46-binary-Win32-2015-1.0.105.2.zip from https://system.data.sqlite.org/index.ht ... loads.wiki
- Extracted files then copied System.Data.SQLite.dll and SQLite.Interop.dll to C:\Program Files (x86)\Devart\EntityDeveloper
- Edited EntityDeveloper.exe.config in C:\Program Files (x86)\Devart\EntityDeveloper using the above entry