How to access my views with OData in my Blazor App

Radzen Blazor Studio
1

I created an OData Service using RadzenBlazor Web Assembly App (ODataService). I hosted my api in azure and then proceeded to create a Radzen Blazor Web App (BlazorApp) to use my ODataService as it's data source. Most of my tables will appear in the BlazorApp but I notice that the views from the SQLServer are not visible in the BlazorApp yet they appear in the ODataService. They appear in the Odata Service Metadata as Function Imports. How do I make these function imports available in my BlazorApp?

2

You can create new page, drag & deop a DataGrid component and bind it to desired function that returns data.

3

When I add my OData service to the application in displays the Entities and Functions (views and stored procedures) but it only allows me to bind to the entities. How would I bind to the functions?

4
1 Like
5

Ok, so i have generate crud pages to access the entities in my service. When the app builds it cannot display any data but if I do an export to excel or .csv from the page it will export the data. This is a development data base with test data so there is no authentication involved. Any suggestions? I notice the generated call to the OData service has $filter=true and the pages display an unable to load data message

6

Can you check with the browser developer tools what the response from the OData services is? The request probably fails.

This shouldn't happen. Is the $filter set somewhere in the generated code?