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

  • Question

  • User1845115564 posted

    Hi
    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 parameters into SQL statement.
    How can I know what SQL query goes to database? 
    Thanks
    AJ

    Hi

    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 parameters into SQL statement.


    How can I know what SQL query goes to database? 


    Thanks

    AJ

    Monday, May 24, 2010 8:26 PM

All replies

  • User560403387 posted

    I use the SQL Server profiler to check which commands get sent to the database. It should come with the SQL Server client tools.

    Menno

    Tuesday, May 25, 2010 4:25 AM