Creating an ArcGauge with data from MSSQL

Radzen Studio Blazor Server
1

Hi,

I've just started using radzen wich looks exactly what I need.

I wonder. How can I create a query inside radzen and use the result to drive a ArcGauge?

SELECT TOP 1 myField FROM mydb order by Timestamp DESC

2

Hi @OlaB,

Radzen is using EF to execute queries. Here is an article how to execute custom query:
https://www.radzen.com/documentation/blazor/invoke-method/#perform-custom-database-query

From the DbContext you can use also raw queries:

3

Thank you for your response.

I see, I hoped that it would be possible to pack such query into a StoresProcedure or view and use it directly in the Radzen GUI....

4

You can execute stored procedure even easier directly since it will be listed as method if you include it during data source infer.