ASP.NET Core Blazor Server Application: Creating Prompt Based Chart Generator for Northwind Database
In this article we will implement a NorthwindReporter, an ASP.NET Core 10 Blazor Server application that lets an end user type a natural-language reporting request (for example, “Regionwise sales” or “Top 5 products by revenue” ), pick a chart type, and get back: A Chart.js visualization rendered in the browser canvas. The raw rows of the result in an HTML data table . The actual SQL the LLM produced, so it is transparent. The reporting engine uses a local Ollama install with the llama3.2 model to translate the English prompt into a single read-only SELECT , a safety validator to make sure that is all it is, and a repository that runs it against a SQL Server “Northwind” database. Workflow Diagram The picture below summarizes how a request flows through the components. Four numbered arrows mark the main hops of one Generate click — each is explained right after the picture. The four numbered steps in the diagram ...
