Is there a way to see view the dyanmic sql generated durning the fetch?

Yes is possible, in fact there are plenty of other debugging information that could be useful, in order to see the sql query generated see the following section in the documentation: ** Using the generated code -> Troubleshooting and debugging -> Dynamic Query Engine Trancing -> Verbose level tracing**

Hi kowboy13,

<?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"/>
        <add key="CatalogNameUsageSetting" value="1"/>
        <add key="CatalogNameToUse" value="DBTest" />       
    </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 listener : uncomment the following lines to write the trace messages to a file -->
        <trace autoflush="true" indentsize="2">
            <listeners>
                <add name="textWriterListener" type="System.Diagnostics.TextWriterTraceListener" initializeData="C:\textWriterListener.log" />
            </listeners>
        </trace>
    </system.diagnostics>
    
</configuration>