Linq tracing

Posts   
 
    
mohamed avatar
mohamed
User
Posts: 136
Joined: 10-Mar-2008
# Posted on: 23-Nov-2009 16:23:18   

Is there any way to get T-SQL query that mapped to link query, on output window for runtime

i used these configurations but cann't show SQL query


<system.diagnostics>
    <switches>
      <add name="SqlServerDQE" value="4" />
      <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="4" />
    </switches>
  </system.diagnostics>

VS 2008 SQL 2008 adapter mode

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 23-Nov-2009 17:28:52   

Try this:

<add name="ORMPersistenceExecution" value="4" />
<add name="LinqExpressionHandler" value="3" />

linq expression handler tracing should never be 4, as that's just dumping all visited mehtods

mohamed avatar
mohamed
User
Posts: 136
Joined: 10-Mar-2008
# Posted on: 23-Nov-2009 18:15:00   

thanks Walaa simple_smile