Fixed SQL log message format

Athari · Athari · commit fb89e8daec31 · 2013-04-07T23:38:34.000+04:00
diff --git a/Simple.Data.Ado/TraceHelper.cs b/Simple.Data.Ado/TraceHelper.cs
@@ -21,11 +21,11 @@ public static void WriteTrace (this IDbCommand command)
                 sb.AppendFormat("SQL command (CommandType={0}):{1}  {2}", command.CommandType, EOL, command.CommandText);
                 if (command.Parameters.Count > 0)
                 {
-                    sb.AppendFormat("Parameters:{0}", EOL);
+                    sb.AppendFormat("{0}Parameters:", EOL);
                     foreach (var parameter in command.Parameters.OfType<DbParameter>())
                     {
                         object strValue = parameter.Value is string ? string.Format("\"{0}\"", parameter.Value) : parameter.Value;
-                        sb.AppendFormat("  {0} ({1}) = {2}{3}", parameter.ParameterName, parameter.DbType, strValue, EOL);
+                        sb.AppendFormat("{0}  {1} ({2}) = {3}", EOL, parameter.ParameterName, parameter.DbType, strValue);
                     }
                 }
                 SimpleDataTraceSources.TraceSource.TraceEvent(TraceEventType.Information, SimpleDataTraceSources.SqlMessageId, sb.ToString());

Original file line number	Diff line number	Diff line change
`@@ -21,11 +21,11 @@ public static void WriteTrace (this IDbCommand command)`
`21`	`21`	`sb.AppendFormat("SQL command (CommandType={0}):{1} {2}", command.CommandType, EOL, command.CommandText);`
`22`	`22`	`if (command.Parameters.Count > 0)`
`23`	`23`	`{`
`24`		`- sb.AppendFormat("Parameters:{0}", EOL);`
	`24`	`+ sb.AppendFormat("{0}Parameters:", EOL);`
`25`	`25`	`foreach (var parameter in command.Parameters.OfType<DbParameter>())`
`26`	`26`	`{`
`27`	`27`	`object strValue = parameter.Value is string ? string.Format("\"{0}\"", parameter.Value) : parameter.Value;`
`28`		`- sb.AppendFormat(" {0} ({1}) = {2}{3}", parameter.ParameterName, parameter.DbType, strValue, EOL);`
	`28`	`+ sb.AppendFormat("{0} {1} ({2}) = {3}", EOL, parameter.ParameterName, parameter.DbType, strValue);`
`29`	`29`	`}`
`30`	`30`	`}`
`31`	`31`	`SimpleDataTraceSources.TraceSource.TraceEvent(TraceEventType.Information, SimpleDataTraceSources.SqlMessageId, sb.ToString());`