Hi everybody,

I have a method allowing me to record information about parameters passed to SQL command. This is quite helpful when we want to try to re-run the query later using the log file.

Today I've added a TVP to one of my command.

This is what I have in my method so far:

if (parameter.SqlDbType != SqlDbType.Structured)
                            {
                                info.Append($"{parameter.ParameterName} {parameter.SqlDbType.ToString().TrimEnd()}{sizeInfo} = ");
                            }
                            else
                            {
                                info.Append($"{parameter.ParameterName} {parameter.TypeName}");
                            }

I'd like to be able to create the insert statements for that parameter similar to what we have when we look into SQL Profiler. Do you know how can I do that?

Thanks in advance.