You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
var firstValueInRange = new SqlParameter("@range_first_value", SqlDbType.Variant)
{
Direction = ParameterDirection.Output
};
var lastValueInRange = new SqlParameter("@range_last_value", SqlDbType.Variant)
{
Direction = ParameterDirection.Output
};
await this.LoadStoredProc("sys.sp_sequence_get_range")
.AddParam("@sequence_name", name)
.AddParam("@range_size", range_size)
.AddParam(firstValueInRange)
.AddParam(lastValueInRange)
.ExecNonQueryAsync();
return new Tuple<int, int>((int)firstValueInRange.Value, (int)lastValueInRange.Value);
but probably it would be nice to find some way how to handle the case in a more elegant way.
convert to expected type when it possible. or allow to use IOutParam < object >
As an example, it's impossible to call systems stored procedure to get range from a sequence:
The text was updated successfully, but these errors were encountered: