Hello,
I need to create list and detail based on MSSQL view.
List works fine but I cannot find my getViewById for detail page.
I checked generated C# code and there is generated two actions for view, first for IEnumerable and then SingleResult. This looks fine.
But I cannot find this method getViewById in list of actions in dialog "Invoke data source method" in dropdown with action for Load page.
I know, that primary key applies to table. But how can i get single row of this view.
Actually entity framework generated this code but i cannot access it from radzen gui:
[HttpGet("{OrderID}")]
public SingleResult GetVwProductionOrderPrint(int key)
{
var items = this.context.VwProductionOrderPrints.AsNoTracking().Where(i=>i.OrderID == key);
this.OnVwProductionOrderPrintsGet(ref items);
return SingleResult.Create(items);
}
Dear Radzen team,
it is possible to retrieve single line of SQL view?
I need to have List and Detail page based on SQL Views.
I have no other options then to use SQL views, because iยดm working with several databases provided with different vendors. I cannot have one "Radzen friendly" model.