Seeing the SQL while debugging - TypedListDAO

Posts   
 
    
JMitchell avatar
JMitchell
User
Posts: 128
Joined: 01-Sep-2006
# Posted on: 09-Jul-2007 17:47:55   

Sorry if this is a silly question, I've searched and seem to have come up with people saying what the resulting SQL is from a dynamic list. How can I see the SQL that results from my code? I have: Dim CustomerDynamicList As New SoTaas.DaoClasses.TypedListDAO() CustomerDynamicList.GetMultiAsDataTable(fields, results, 0, sorter, filter, relations, False, groupBy, Nothing, 0, 0)

I can see the SQL of the individual elements and I can see the table using the datasets visualizer on results.

Is there any way to see the SQL query that has come from my code?

JMitchell avatar
JMitchell
User
Posts: 128
Joined: 01-Sep-2006
# Posted on: 09-Jul-2007 18:01:18   

Never mind, I found it. I added: SD.LLBLGen.Pro.ORMSupportClasses.DynamicQueryEngineBase.Switch.Level = TraceLevel.Verbose to the code and looked in the "Immediate Window" in VS2005.