Devart Forums

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?

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.

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