build SQL text from SqlCommand

[Giedrius]

Hi,
is it possible to retrieve exact sql text which will be executed from a
prepared SqlCommand or DBCommand?
I need this for logging all activity.

Something like this would be helpfull:

Command.CommandText = "ExecProc"
Command.Paramaters.Add.....

SQL = Command.GetInternalSql 'or Command.GetType.InvokeMember
("GetInternalSql")

 

[David Browne]

Hi,
is it possible to retrieve exact sql text which will be executed from a
prepared SqlCommand or DBCommand?
I need this for logging all activity.

Something like this would be helpfull:

Command.CommandText = "ExecProc"
Command.Paramaters.Add.....

SQL = Command.GetInternalSql 'or Command.GetType.InvokeMember
("GetInternalSql")

You need to dump the CommandText, CommandType, and for each parameter the
ParameterName, Direction Type and Value.

This is what's sent to the server. It's not all munged up into a dynamic
SQL string.

David

 

[Giedrius]

Thanks,
thats how I do it now, but I thought about exact SQL string, without having
to think about command type, parameter types, parameter value formatting and
so on.