Database table-valued functions in custom methods

Hello everyone

Does Radzen let you work with database table-valued functions? Is there a way to call db functions in ServerMethodsController custom methods?

Hi @luf,

According to this SO answer you have to use raw SQL with Entity Framework Core. This should work as expected in ServerMethodsController in Radzen.

1 Like

Is it possible to call it directly from the EF context?

Like for example...

 var courses = context.GetCourseListByStudentID(1)
                 .ToList<Course>();

No, Radzen doesn't scaffold functions at the moment.