Access Table columns

Radzen Studio Blazor Server
1

I am building a Dashboard in my application and just wanted to know if there is a different way to access a tables columns other that how I am doing it. Currently I am invoking a data source, then set a property to a query like this... ${result.Where(o=> o.DealSaleTp=="New").Sum(o=> o.Count)}

If I am using a SQL View that only has one row with the correct data that I want to access directly, how do I access the table in a similar way to add and edit crud pages ie. ${tablexxx.columnyyy}?

Just curious as the queries are really bogging down the load time.

2

Hi @daveg1466,

Radzen generates two types of methods for data access: get a collection or get a single item. It is up to you how you will manipulate the collection to get desired item and for sure the easiest way is Linq and to make sure that your expressions are executed in-memory you can use ToList() before any Where(), OrderBy(), etc.

3

:+1: thanks for the help