New to Telerik Reporting? Download free 30-day trial

How to configure SQLite ADO.NET Provider for Stand-alone Report Designer

Environment

Product Version 12.2.18.1017
Product Progress® Telerik® Reporting

Description

Configuring the SQLite ADO.NET Provider for the Stand-alone Report Designer requires a few steps. If one is missed, the DataSource provider will not work in the Report Designer. Follow the below steps as to get this working.

Solution

Step 1 Download the SQLite installer per your desired version of the .NET Framework from the System.Data.Sqlite Downloads page.

Step 2 Copy the System.Data.Sqlite.dll file from the System.Data.Sqlite installation directory to the Report Designer installation directory.

  • SQLite Installation: C:\Program Files\System.Data.SQLite\2015\bin
  • Telerik Reporting Installation: C:\Program Files (x86)\Progress\Telerik Reporting R2 2019\Report Designer

The Telerik Reporting directory will look like the following:

sqlite install folder

Step 3 Add the DbProvider Factory declaration to the appropriate Stand-alone Report Designer configuration file. Telerik.ReportDesigner.exe.config is for 64-bit (x64) and Telerik.ReportDesigner.x86.exe.config is for 32-bit (x86).

When updating the configruation file, use the version that matches the installed SQLite ADO.NET Provider, i.e., 64-bit (x64) or 32-bit (x86).

<system.data>
        <DbProviderFactories>
                <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, Version=1.0.110.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
        </DbProviderFactories>
</system.data>

Step 4 Install the SQLite/SQLServer Compact Toolbox extension in visual studio. This will give you a similar experience to using Access.

See Also

In this article