When a SQL select command is executed, I always store the full SQL select command that was sent to SQL Server. This is useful for troubleshooting.

It usually goes like this:

            ' If we have some parameters
            While loEnumerator.MoveNext
                loDataParameter = loEnumerator.Current

                    loDataParameterSQLClient = loEnumerator.Current
                    lcValue = loDataParameterSQLClient.Value.ToString

                    ' Based on the type
                    Select Case loDataParameterSQLClient.SqlDbType.ToString

                        ' Integer, Binary
                        Case "Int", "Binary"

                            ' String
                        Case "VarChar"
                            lcValue = "'" + oApp.SQLServerGetValueForInsertionInScript(lcValue) + "'"

                            ' Datetime
                        Case "DateTime"
                            ldDate = loDataParameterSQLClient.Value
                            lcValue = "'" + ldDate.Year.ToString + "-" + _
                             ldDate.Month.ToString.PadLeft(2, "0") + "-" + _
                             ldDate.Day.ToString.PadLeft(2, "0") + " " + _
                             ldDate.Hour.ToString.PadLeft(2, "0") + ":" + _
                             ldDate.Minute.ToString.PadLeft(2, "0") + ":" + _
                             ldDate.Second.ToString.PadLeft(2, "0") + "'"

                            ' String
                        Case "NVarChar"
                            lcValue = "'" + oApp.SQLServerGetValueForInsertionInScript(lcValue) + "'"

And, this may returns something like this:

DECLARE @NoCompany Int
DECLARE @MD5 Binary(16)

SET @NoCompany=339
SET @MD5=System.Byte[]

SELECT CompanyFile.Numero,CompanyFile.Filename FROM CompanyFile (NOLOCK) WHERE CompanyFile.NoCompany=@NoCompany AND CompanyFile.MD5=@MD5

But, as you can see, when this is a Binary type, I do not get something like 0xB3C54EFB6C02017046905007293650B1. There is already a ToString at the top which works ok for an Integer as I do not have to do additional processing. But, for a Binary type, ToString would simply show the type. How can I obtain the 0xB3C54EFB6C02017046905007293650B1 here?