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

• • Reply
  pankajmittal...

  Member

  1 Points

  6 Posts

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

  May 24, 2010 08:26 PM|pankajmittaljpmchase.com|LINK

  <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">Hi</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">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.</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">How can I know what SQL query goes to database? </div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">Thanks</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">AJ</div>

  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

  daAB sql query

• • Reply
  Menno van de...

  Contributor

  2010 Points

  385 Posts

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

  May 25, 2010 04:25 AM|Menno van den Heuvel|LINK

  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