where i can see sql ?
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:
- add to web.config.
<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>
-
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 :
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