I want to debug a very complicated sql query, i am using parameterized style, to easier for me to debug, i want to print out the FULL query before the query has been executed which we can super easy done this in classic ASP by just using :
But how about in .NET, i want a simple & faster way like the classic ASP has. Anyway, is it possible to print it out with FULL(+Parameter values) in .NET? Sometimes i have to debug it thru FTP file. SO i cant use VisualStudio to do breakPoint.
string userName = "MyName";
string cmdString = "Select user_id from users where user_name='" + userName + "'";
I want to print out the result as: Select user_id from users where user_name='MyName';