How can I see the command string when using MySqlCommand parameters?

Question

Having code that looks like:

MySqlCommand cmd = new MySqlCommand(
    "SELECT * FROM DB_name_here WHERE some_field =@some_value;"
);

cmd.Parameters.AddWithValue("@some_value", some_string_here);

Can I get it back as a simple string for debug purposes, that says:

SELECT * FROM DB_name_here WHERE some_field =some_string_here;

The obvious cmd.ToString() failed me promptly, returning a MySql.Data.MySqlClient.MySqlCommand.
The cmd.CommandText will return the string with the parameter (@some_value in my case).

Any suggestions?

See this question Times ago I have used the code and it worked perfectly — Tinwor
– Tinwor, Commented Nov 25, 2013 at 23:35

Community · Accepted Answer · 2017-05-23 12:02:03Z

2

According to this answer it cannot be done directly.

From the answer:

At no point in time a complete SQL string is generated.

(For workarounds see the other answers there. especially https://stackoverflow.com/a/265261/939213.)

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered Nov 25, 2013 at 23:32

ispiro

28k41 gold badges168 silver badges332 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Noctis Over a year ago

Just when you expect something to be simple and straight forward ... meh ... good answer in the links provided. Cheers for that.

Sudhakar Tillapudi · Accepted Answer · 2013-11-25 23:53:56Z

2

You can use CommandText property of MySqlCommand object to get the actual command string . for parameters you can iterate over Parameters and replace with replace the Parameters Parameter Value

Solution:

String commandtext = cmd.CommandText;
foreach (SqlParameter p in cmd.Parameters)
commandtext = commandtext.Replace(p.ParameterName, p.Value.ToString());

edited Nov 25, 2013 at 23:53

answered Nov 25, 2013 at 23:25

Sudhakar Tillapudi

26.3k5 gold badges43 silver badges70 bronze badges

2 Comments

Noctis Over a year ago

:) . You saved me pointing out the bug in your previous version (where you set commandtext = "" . Nice catch. This works ok enough, but like the answer that ispiro pointed out, will leave you with strings not quoted. Cheers for the help never the less :)

Frank Over a year ago

@Sudhakar Tillapudi, This does not work in Ubuntu 16.04 with cmd.Parameters.AddWithValue("@some_value", some_string_here); Thank you.

Collectives™ on Stack Overflow

How can I see the command string when using MySqlCommand parameters?

2 Answers 2

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related