How to enable Database Logging

Owned by Roman Villandry
Last updated: Apr 24, 2018
1 min read

Within the configuration file of CardExchange® Visitor is a commented out section as shown in green 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.

The default location for the configuration file of CardExchange® Visitor is below:

C:\Program Files (x86)\CardExchange Solutions\CardExchange Visitor\VisitorExchange.exe.config