Dapper exact query being sent to database engine

Question

Looking for a way to get the exact query which is sent to SQL Server after substituting literals / parameters.

Executed code:

result = connection.Query(Of MyList)(query, New With {Key .A = A, Key .B = B, Key .C = C})

I would like to capture (in the code, not at the database server side) exact query where parameters @A, @B and @C are already substituted with its values.

You can log the query as explained [here](https://stackoverflow.com/a/50875558/5779732). It is for Dapper Extensions; but same is applicable for Dapper without change. — Amit Joshi, Sep 18 '20 at 07:01

score 1 · Accepted Answer · answered Sep 17 '20 at 14:58

1

Dapper doesn't provide such a capability. You will have to fork its source code and add this sort of logging yourself.

answered Sep 17 '20 at 14:58

Ian Kemp

28,293
19
112
138

score 1 · Answer 2 · answered Sep 17 '20 at 15:07

1

where parameters @A, @B and @C are already substituted with its values.

Parameters aren't substituted. The query with the parameter markers is the exact query sent to the server. The parameter values are sent separately.

answered Sep 17 '20 at 15:07

David Browne - Microsoft

80,331
6
39
67

Dapper exact query being sent to database engine

2 Answers2