Connecting to PostgreSQL DB

Environment

Product

Progress® Telerik® Reporting

Description

This KB article lists the required steps for configuring the SqlDataSource component to connect to a PostgreSQL database with the Npgsql data provider.

Setting up the Npgsql Data Provider in the .NET Standalone Report Designer

1. Create a new .NET 8 Console Application project.
2. Install the Npgsql NuGet package to it and build the project.
3. Navigate to the bin/Debug/net8.0 subdirectory of the project, and copy all assemblies there except for the assembly with the name of the project.
4. Paste the assemblies in the .NET Standalone Report Designer installation directory e.g. C:\Program Files (x86)\Progress\Telerik Reporting 2024 Q4\Report Designer\.NET.
5. Start the .NET Standalone Report Designer from the same directory and add a new SqlDataSource component which should trigger the SqlDataSource Wizard. The Npgsql data provider should now be listed among the rest of the data providers when building a new connection.

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

MSI Installation - Npgsql 3.2.7

1. Install Npgsql version 3.2.7 by using the .MSI file. Note that the SqlDataSource component will list and work with any ADO.NET provider that is correctly registered on the device;
2. Add SQL Data Source -> Build new data connection -> select Npgsql Data Provider;

3. Add the Connection string in the field. For example:

   Server=127.0.0.1;Port=5432;Database=myDataBase;User Id=myUsername;Password=myPassword;

4. Click Next -> fill in the Select Statement or use the Query Builder -> Finish.

Manual Configuration

1. Create a new .NET Framework 4.6.2 Console Application project.
2. Install the Npgsql 8.0.4 NuGet package to it and build the project. package;
3. Navigate to the bin/Debug subdirectory of the project, and copy all assemblies there except for the assembly with the name of the project.
4. Paste the assemblies in the .NET Framework Standalone Report Designer installation directory e.g. C:\Program Files (x86)\Progress\Telerik Reporting 2024 Q4\Report Designer.
5. Open the App.config file of the application and copy the binding redirects;

6. Open the configuration file of the Standalone designer (Telerik.ReportDesigner.exe.config) and add the binding redirects:

   <?xml version="1.0" encoding="utf-8"?>
   <configuration>
       <configSections>
           <section
                   name="Telerik.Reporting"
                   type="Telerik.Reporting.Configuration.ReportingConfigurationSection, Telerik.Reporting"
                   allowLocation="true"
                   allowDefinition="Everywhere"/>
       </configSections>
   
       <runtime>
           <dependentAssembly>
               <assemblyIdentity name="Npgsql" culture="neutral" publicKeyToken="5d8b90d52f46fda7"/>
               <bindingRedirect oldVersion="0.0.0.0-8.0.4.0" newVersion="8.0.4.0" />
           </dependentAssembly>
           <dependentAssembly>
               <assemblyIdentity name="Microsoft.Bcl.AsyncInterfaces" publicKeyToken="cc7b13ffcd2ddd51" culture="neutral" />
               <bindingRedirect oldVersion="0.0.0.0-8.0.0.0" newVersion="8.0.0.0" />
           </dependentAssembly>
           <dependentAssembly>
               <assemblyIdentity name="System.Numerics.Vectors" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
               <bindingRedirect oldVersion="0.0.0.0-4.1.4.0" newVersion="4.1.4.0" />
           </dependentAssembly>
           <dependentAssembly>
               <assemblyIdentity name="System.Runtime.CompilerServices.Unsafe" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
               <bindingRedirect oldVersion="0.0.0.0-6.0.0.0" newVersion="6.0.0.0" />
           </dependentAssembly>
           <dependentAssembly>
               <assemblyIdentity name="System.Buffers" publicKeyToken="cc7b13ffcd2ddd51" culture="neutral" />
               <bindingRedirect oldVersion="0.0.0.0-4.0.3.0" newVersion="4.0.3.0" />
           </dependentAssembly>
           <dependentAssembly>
               <assemblyIdentity name="System.Threading.Tasks.Extensions" publicKeyToken="cc7b13ffcd2ddd51" culture="neutral" />
               <bindingRedirect oldVersion="0.0.0.0-4.2.0.1" newVersion="4.2.0.1" />
           </dependentAssembly>
           <dependentAssembly>
               <assemblyIdentity name="System.ValueTuple" publicKeyToken="cc7b13ffcd2ddd51" culture="neutral" />
               <bindingRedirect oldVersion="0.0.0.0-4.0.3.0" newVersion="4.0.3.0" />
           </dependentAssembly>
           </assemblyBinding>
       </runtime>
   
       <system.data>
           <DbProviderFactories>
               <add name="Npgsql Data Provider"
                   invariant="Npgsql"
                   description=".NET Framework Data Provider for Postgresql Server"
                   type="Npgsql.NpgsqlFactory, Npgsql, Version=8.0.4.0, Culture=neutral, PublicKeyToken=5d8b90d52f46fda7" />
           </DbProviderFactories>
       </system.data>
   <configuration>
   

Setting up the Npgsql Data Provider in .NET Applications

The Npgsql data provider is automatically registered in the Telerik.Reporting.Processing.Data.DbProviderFactories. To use this data provider, it should be enough to install the Npgsql 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":{
        "postgres":{
            "connectionString":"Server=127.0.0.1;Port=5432;Database=myDataBase;User Id=myUsername;Password=myPassword;",
            "providerName":"Npgsql"
        }
    }
}

See Also

• PostgreSQL connection strings
• Connecting to PostgreSQL DB