GetSizeScale() public static method

public static GetSizeScale ( int size, int scale ) : string
size int
scale int
return string
SqlBuilder Class Documentation
Ejemplo n.º 1
0
        public string sp_executesql()
        {
            var pars = this.Parameters.EmptyIfNull();

            var parameterVars   = pars.ToString(p => $"{p.ParameterName} {((SqlParameter)p).SqlDbType.ToString()}{SqlBuilder.GetSizeScale(p.Size.DefaultToNull(), p.Scale.DefaultToNull())}", ", ");
            var parameterValues = pars.ToString(p => Encode(p.Value), ",");

            return($"EXEC sp_executesql N'{this.Sql}', N'{parameterVars}', {parameterValues}");
        }