I have a situation where I need to log all the SQL statements generated by LLBLGen. The database is Oracle. For political reasons, profiling of the database is not an option. How can I get access to the sql string generated by LLBLGen. I am aware of the diagnostic switches that can be put in the config file, but those only show sql statement in the output window during debugging, whereas I want to log the sqls somwhere.

Hello,

Use this:

<?xml version="1.0"?>
<configuration>

    <appSettings>
        <add key="Main.ConnectionString" value="data source=PCNAME;initial catalog=DBTest;User ID=Userid;Password=pwd;persist security info=False;packet size=4096"/>
    </appSettings>

    <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="ORMGeneral" value="0" />
            <add name="ORMStateManagement" value="0" />
            <add name="ORMPersistenceExecution" value="3" />
        </switches>

        <trace autoflush="true" indentsize="2">
            <listeners>
                <add name="textWriterListener" type="System.Diagnostics.TextWriterTraceListener" initializeData="C:\textWriterListener.log" />
            </listeners>
        </trace>
    </system.diagnostics>
    
</configuration>

Regards

Use below

     <switches>
            <add name="SqlServerDQE" value="0" />
            <add name="AccessDQE" value="0" />
            <add name="OracleDQE" value="4" />
            <add name="FirebirdDQE" value="0" />
            <add name="MySqlDQE" value="0" />
            <add name="DB2DQE" value="0" />
            <add name="PostgeSqlDQE" value="0" />
            <add name="ORMGeneral" value="0" />
            <add name="ORMStateManagement" value="0" />
            <add name="ORMPersistenceExecution" value="4" />
        </switches>