Show/Hide Toolbars

CardExchange® Gateway

Navigation: CardExchange® Assist

CardExchange® Visitor Database Logging

Scroll Prev Top Next More

 

Within the configuration file is a commented out section as shown below:

 

    <entityFramework>

        <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />

        <providers>

            <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />

            <provider invariantName="System.Data.SQLite.EF6" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />

            <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6" />

        </providers>

        <!--<interceptors>

            <interceptor type="System.Data.Entity.Infrastructure.Interception.DatabaseLogger, EntityFramework">

                <parameters>

                    <parameter value="C:\Users\Public\Documents\VisitorExchange\VisitorExchange.log"/>

                </parameters>

            </interceptor>

        </interceptors>-->

    </entityFramework>

 

Uncommenting this section will cause all database queries to be logged to the specified file. CardExchange® Visitor produces a lot of SQL queries so database logging is disabled by default, but if there are any issues you can enable logging to help identify the problem.