How to get the SQL actually executed by a parameterized query in .Net (VB or C#)?

Question

Is there a straight forward way to view the SQL command text actually executed against the underlying database by a DbCommand object (i.e. after the parameters have been processed into a statement)?

Here the detail: I'm using VB.Net 3.5 and have a factory object (DbProviderFactory) and a connection (System.Data.IDbConnection). I am using the factory to create a new command object using the DbProviderFactory.CreateCommand() method and then assigning a parametrized query to the CommandText property of the command. Later on I create and associate some parameters with the query (created using the DbProviderFactory).

This is great, but I want to get a look at the actual SQL statement generated by the command object. I am currently testing this against a SQLite database, but wondered if there were a general approach which would work.

Thomas Levesque · Accepted Answer · 2010-03-23 20:34:02Z

1

The actual SQL executed by the server is exactly what you wrote. The parameters are sent separately from the command itself, so they're actually never replaced with their value in the SQL command.

answered Mar 23, 2010 at 20:34

Thomas Levesque

294k73 gold badges639 silver badges769 bronze badges

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

1 Comment

AJ. Over a year ago

Thanks Thomas - I guess I didn't understand the way this works. So the database API is used to do the binding behind the scenes.

Collectives™ on Stack Overflow

How to get the SQL actually executed by a parameterized query in .Net (VB or C#)?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related