Overview

The System.Data.SQLite is an ADO.NET provider for SQLite. SQLite is not directly comparable to client/server SQL database engines such as MySQL, Oracle, PostgreSQL, or SQL Server and instead focuses on providing local data storage for individual applications and devices.

Setting up the System.Data.Sqlite Data Provider in the .NET Standalone Report Designer

1. Download the SQLite Binaries built for .NET Standard 2.0 or .NET Standard 2.1 from the System.Data.Sqlite Downloads page.
2. Unpackage the zip with the binaries and copy the System.Data.Sqlite.dll file to the .NET Standalone Report Designer installation directory e.g. C:\Program Files (x86)\Progress\Telerik Reporting 2024 Q4\Report Designer\.NET.
3. Download SQLite binaries built for .NET Framework.4.X from the System.Data.Sqlite page, for example sqlite-netFx40-binary-x64-2010-1.0.117.0.zip.
4. Unpackage the archive and copy the SQLite.Interop.dll assembly to the .NET Standalone Report Designer installation directory e.g. C:\Program Files (x86)\Progress\Telerik Reporting 2024 Q4\Report Designer\.NET.
5. Restart the designer if you have previously opened it.
6. Add a new SqlDataSource and you should see that the Sqlite Data Provider is in the dropdown.

Setting up the System.Data.Sqlite Data Provider in the .NET Framework Standalone Report Designer

1. Download the SQLite installer for .NET Framework 4.6 from the System.Data.Sqlite Downloads page.

2. Copy the System.Data.Sqlite.dll and SQLite.Interop.dll assemblies from the System.Data.Sqlite installation directory to the directory with the .NET Framework Standalone Report Designer - C:\Program Files (x86)\Progress\Telerik Reporting 2024 Q4\Report Designer\.

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

3. Add the DbProvider Factory declaration to the appropriate Standalone 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 configuration 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.117.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
       </DbProviderFactories>
   </system.data>
   

Setting up the System.Data.Sqlite Data Provider in .NET Applications

The System.Data.Sqlite data provider is automatically registered in the Telerik.Reporting.Processing.Data.DbProviderFactories. To use this data provider, it should be enough to install the System.Data.SQLite NuGet package to the project.

If the SqlDataSource component uses a shared connection where it is retrieved from the configuration file of the project(e.g. appsettings.json), the provider name must be specified in the connection. For example:

{
    "ConnectionStrings":{
        "sqlite":{
            "connectionString":"Data Source=c:\mydb.db;Version=3;",
            "providerName":"System.Data.Sqlite"
        }
    }
}

See Also

• How to configure SQLite ADO.NET Provider for Standalone Report Designer
• Integrating SQLite Databases with Telerik Web Report Designer
• SQLite connection strings