Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > Generated code> how to review sql that was generated by llblgen?
 

Pages: 1
Generated code
how to review sql that was generated by llblgen?
Page:1/1 

  Print all messages in this thread  
Poster Message
nevernet
User



Location:

Joined on:
01-Feb-2010 13:21:09
Posted:
67 posts
# Posted on: 26-Feb-2010 09:30:23.  
Code:
xxxCollection atc = new xxxCollection();
atc.GetMulti(filter);


i used filter for filting results in collection
but i want to see sql. because the results is wrong.

Thank you.
Dev Environment as below:
.Net 3.5, LLBLGen Pro 2.6, SQLServer 2008, IIS7
 
Top
Walaa
Support Team



Location:

Joined on:
21-Aug-2005 16:03:48
Posted:
13710 posts
# Posted on: 26-Feb-2010 10:49:16.  
Please check: Dynamic Query Engine tracing

  Top
nevernet
User



Location:

Joined on:
01-Feb-2010 13:21:09
Posted:
67 posts
# Posted on: 26-Feb-2010 11:28:56.  
where i can see sql ?

Quote:
Verbose level tracing
When for a DQE the trace switch is turned on to level 4 (verbose level), the following information is provided, besides the information provided at the info level:

    * Generated Sql Query messages for the methods:
     CreateInsertDQ, CreateDeleteDQ (and overloads), CreateUpdateDQ (and overloads), CreateSelectDQ (and overloads), CreateRowCountDQ. The Generated Sql Query contains the full SQL query and a listing of all parameters and their values.



my step:

1. add to web.config.
Code:
<system.diagnostics>
    <switches>
        <add name="SqlServerDQE" value="3" />
        <add name="AccessDQE" value="4" />
        <add name="OracleDQE" value="4" />
        <add name="FirebirdDQE" value="4" />
        <add name="MySqlDQE" value="4" />
        <add name="DB2DQE" value="4" />
        <add name="PostgeSqlDQE" value="4" />
        <add name="SybaseAsaDQE" value="4" />
        <add name="SybaseAseDQE" value="4" />
        <add name="ORMGeneral" value="0" />
        <add name="ORMStateManagement" value="0" />
        <add name="ORMPersistenceExecution" value="3" />
        <add name="LinqExpressionHandler" value="3" />
    </switches>
</system.diagnostics>


2.
the SD.LLBLGen.Pro.DebugVisualizers.dll was copied
the ORMSupportClasses dll and the DQE dll are copyied.
to my folder : C:\documents and settings\your user name\My Documents\Visual Studio 2008\Visualizers\

(actually ,the visualizers is working now.
as described in manual :
Quote:
EntityCollection (Selfservicing/adapter)
Simple form with a DataGrid set to readonly/AllowNavigation set to false (to avoid lazy loading) for SelfServicing entity collections and with AllowNavigation set to true for Adapter, which displays the collection using normal databinding. The form also shows a textbox with the type the collection is set for, which is typically the type the factory produces.

)

but i didn't found where i can see my sql.

Thank you
Dev Environment as below:
.Net 3.5, LLBLGen Pro 2.6, SQLServer 2008, IIS7
 
Top
nevernet
User



Location:

Joined on:
01-Feb-2010 13:21:09
Posted:
67 posts
# Posted on: 26-Feb-2010 11:36:13.  
ah ,sorry

i found the output in the visual 2008 "output" window

great
thanks for your article


Dev Environment as below:
.Net 3.5, LLBLGen Pro 2.6, SQLServer 2008, IIS7
 
Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.