Get Parameter Names from non used DynamicParameters

[vbjay]

I am trying to log the command and the parameter names and values.

example:

				DynamicParameters parameters = new DynamicParameters(new
				{
					 DistribCode = distributorCode,
					 YardCode = string.Empty,
					 IncludeInactive = includeInactive

				});
				const string sp = "[brcSP_GetInvnDistributorsAndProductionYards]";
				_brcConnection.WriteDapperSQLLog(sp, parameters);

//____________________ WriteDapperSQLLog below
				StringBuilder logBuilder = new StringBuilder();
				if (Transaction.Current != null)
				{
					 logBuilder.Append("IN TRANSACTION!!!");
				}

				logBuilder.Append($"exec {storedProc}{Environment.NewLine}");
				if (param != null)
				{
					 int index = 0;
					 if (typeof(DynamicParameters) == param.GetType())
					 {
						  DynamicParameters parameters = param as DynamicParameters;
						  foreach (string name in parameters.ParameterNames)
						  {
								dynamic value = parameters.Get<dynamic>(name);
								logBuilder.Append($" @{name} = {value?.ToString() ?? string.Empty}{((index++ == parameters.ParameterNames.Count() - 1) ? string.Empty : ",")}{Environment.NewLine}");
						  }
						  					 }
					 else

ParameterNames is 0 length.