Stored Procedure - SqlParameter

Radzen Blazor Studio
1

Hello,

After refresh Database the new generated code for executing a Stored Procedure is not the same as in the older version:

this is the old code with ParameterDirection.Input:

          foreach(var _p in @params)
          {
              if(_p.Direction == ParameterDirection.Input && _p.Value == null)
              {
                  _p.Value = DBNull.Value;
              }
          }

this is the new one where ParameterDirection.Input is missing:

 foreach(var _p in @params)
 {
     if((_p.Direction == ParameterDirection.Output || _p.Direction == ParameterDirection.InputOutput) && _p.Value == null)
     {
         _p.Value = DBNull.Value;
     }
 }

it should be:

foreach(var _p in @params)
 {
     if((_p.Direction == ParameterDirection.Output || _p.Direction == ParameterDirection.Input || _p.Direction == ParameterDirection.InputOutput) && _p.Value == null)
     {
         _p.Value = DBNull.Value;
     }
 }

robert

2

Thanks! We will add this to our template. You can remove also _p.Direction == ParameterDirection.Output since this is not needed in this case.