How to use Store Procedure and set the value?

cllor80 · September 14, 2022, 1:06pm

This is my Store Procedure

In Radzen I use Invoke Data Source method

But i not sure why the property type return me is in IEnumerable

enchev · September 14, 2022, 2:32pm

Radzen uses sys.dm_exec_describe_first_result_set_for_object which will list your procedure as one that returns collection - most probably because of the SELECT statement.

cllor80 · September 14, 2022, 2:35pm

would like you to share on what is the best practice?

As I want to get a random GUID generate from the Store Procedure and set it in a textbox.

enchev · September 14, 2022, 2:36pm

cllor80 · September 14, 2022, 2:38pm

Do you means is prefer to create the custom method, and not go for Store Procedure?

enchev · September 14, 2022, 2:39pm

It's a plain C#, no custom methods, no stored procedures.

mumfie · September 14, 2022, 11:09pm

@cllor80 A database SP will be slower so is there a reason it has to be done at the db level?
As suggested by @enchev you can use c# code.