Blazor

How to bind PostgreSQL to a Pivot Table

A quick start project for connecting a PostgreSQL database to a Syncfusion Pivot Table. This repository includes a Web API Controller (MyWebService) for retrieving data from a PostgreSQL database, as well as a quick start sample in the Blazor platform that displays the retrieved data in a Syncfusion Pivot Table.

Project prerequisites

Before beginning work on the server and client projects, ensure the following software to be installed in the machine.

• Visual Studio 2022
• .NET Core SDK 6.0 or later installed on your machine

How to run this application?

To run this application, clone the how-to-bind-PostgreSQL-database-to-pivot-table repository.

Using the Web API service to connect PostgreSQL database to a Pivot Table

• To connect a PostgreSQL database to a Pivot Table using the Web API Controller (aka, MyWebService), open the MyWebService project in Visual Studio 2022. Simply build and run your project in IIS Express, and it will host and display the URL https://localhost:44378.

• Now open the MyBlazorServerApp project in Visual Studio 2022. Initialize the Pivot Table, map the hosted URL, create a pivot report, and finally, run your project.