开发者

How to know the exact statement fired in Data app block?

开发者 https://www.devze.com 2022-12-31 06:28 出处:网络
We are using \"Enterprise Library Data Access Application Block\" to access SQL Server database. In DataAccess layer, we are calling application block\'s API. Internally it must be resolving the comma

We are using "Enterprise Library Data Access Application Block" to access SQL Server database. In DataAccess layer, we are calling application block's API. Internally it must be resolving the command and param开发者_如何学Pythoneters into SQL statement.

How can I know what SQL query goes to database?

Thanks AJ


One way:

Run profiler on SQL Server, start a trace and add even SQL:Batchstarting. In the trace data look at the TextData column

see image below of what it looks like

How to know the exact statement fired in Data app block?

0

精彩评论

暂无评论...
验证码 换一张
取 消