log4net NonBufferedSmtpAppenderWithSubjectLayout

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
	<configSections>
	    <section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net" />
	</configSections>

	<!-- This section contains the log4net configuration settings -->
	<log4net>
		<!-- Define some output appenders -->		
		<appender name="db" type="log4net.Appender.AdoNetAppender">
			<bufferSize value="100" />
			<connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
			<connectionString value="Integrated Security=SSPI; server=build1-srv; database=log4netDev" />
			<commandText value="INSERT INTO Log ([Date], [TimeStamp], [Property_HostName], [Identity], 
			[UserName], [AppDomain], [Thread], [File], [Location], [Line], [Type], [Level],
			[Logger], [Ndc], [Message], [ExceptionType], [Exception]) VALUES (@log_date, 
			@log_timestamp, @log_property_hostname, @log_identity, @log_username, @log_appdomain,
			@log_thread, @log_file, @log_location, @log_line, @log_type, @log_level, @log_logger, 
			@log_ndc, @log_message, @log_exceptiontype, @log_exception)" />
			<parameter>
				<parameterName value="@log_date" />
				<dbType value="DateTime" />
				<layout type="log4net.Layout.RawTimeStampLayout" />
			</parameter>
			<parameter>
				<parameterName value="@log_timestamp" />
				<dbType value="Int32" />
				<size value="4" />
				<layout type="HHR.log4net.Layout.PatternLayout, HHR.log4net">
					<conversionPattern value="%timestamp" />
				</layout>
			</parameter>	
			<parameter>
				<parameterName value="@log_property_hostname" />
				<dbType value="String" />
				<size value="255" />
				<layout type="HHR.log4net.Layout.PatternLayout, HHR.log4net">
					<conversionPattern value="%property{log4net:HostName}" />
				</layout>
			</parameter>				
			<parameter>
				<parameterName value="@log_identity" />
				<dbType value="String" />
				<size value="255" />
				<layout type="HHR.log4net.Layout.PatternLayout, HHR.log4net">
					<conversionPattern value="%identity" />
				</layout>
			</parameter>
			<parameter>
				<parameterName value="@log_username" />
				<dbType value="String" />
				<size value="255" />
				<layout type="HHR.log4net.Layout.PatternLayout, HHR.log4net">
					<conversionPattern value="%username" />
				</layout>
			</parameter>
			<parameter>
				<parameterName value="@log_appdomain" />
				<dbType value="String" />
				<size value="255" />
				<layout type="HHR.log4net.Layout.PatternLayout, HHR.log4net">
					<conversionPattern value="%appdomain" />
				</layout>
			</parameter>									
			<parameter>
				<parameterName value="@log_thread" />
				<dbType value="String" />
				<size value="255" />
				<layout type="HHR.log4net.Layout.PatternLayout, HHR.log4net">
					<conversionPattern value="%thread" />
				</layout>
			</parameter>
			<parameter>
				<parameterName value="@log_file" />
				<dbType value="String" />
				<size value="255" />
				<layout type="HHR.log4net.Layout.PatternLayout, HHR.log4net">
					<conversionPattern value="%file" />
				</layout>
			</parameter>		
			<parameter>
				<parameterName value="@log_location" />
				<dbType value="String" />
				<size value="255" />
				<layout type="HHR.log4net.Layout.PatternLayout, HHR.log4net">
					<conversionPattern value="%location" />
				</layout>
			</parameter>				
			<parameter>
				<parameterName value="@log_line" />
				<dbType value="Int32" />
				<size value="4" />
				<layout type="HHR.log4net.Layout.PatternLayout, HHR.log4net">
					<conversionPattern value="%line" />
				</layout>
			</parameter>	
			<parameter>
				<parameterName value="@log_type" />
				<dbType value="String" />
				<size value="255" />
				<layout type="HHR.log4net.Layout.PatternLayout, HHR.log4net">
					<conversionPattern value="%type" />
				</layout>
			</parameter>					
			<parameter>
				<parameterName value="@log_level" />
				<dbType value="String" />
				<size value="50" />
				<layout type="HHR.log4net.Layout.PatternLayout, HHR.log4net">
					<conversionPattern value="%level" />
				</layout>
			</parameter>
			<parameter>
				<parameterName value="@log_logger" />
				<dbType value="String" />
				<size value="255" />
				<layout type="HHR.log4net.Layout.PatternLayout, HHR.log4net">
					<conversionPattern value="%logger" />
				</layout>
			</parameter>
			<parameter>
				<parameterName value="@log_ndc" />
				<dbType value="String" />
				<size value="255" />
				<layout type="HHR.log4net.Layout.PatternLayout, HHR.log4net">
					<conversionPattern value="%ndc" />
				</layout>
			</parameter>						
			<parameter>
				<parameterName value="@log_message" />
				<dbType value="String" />
				<size value="4000" />
				<layout type="HHR.log4net.Layout.PatternLayout, HHR.log4net">
					<conversionPattern value="%message" />
				</layout>
			</parameter>
			<parameter>
				<parameterName value="@log_exceptiontype" />
				<dbType value="String" />
				<size value="255" />
				<layout type="HHR.log4net.Layout.PatternLayout, HHR.log4net">
					<conversionPattern value="%exceptType" />
				</layout>
			</parameter>			
			<parameter>
				<parameterName value="@log_exception" />
				<dbType value="String" />
				<size value="2000" />
				<layout type="log4net.Layout.ExceptionLayout" />
			</parameter>
		</appender>
		
		<!-- Setup the root category, add the appenders and set the default priority -->
		<root>
			<!-- levels: DEBUG, INFO, WARN, ERROR, FATAL -->
			<priority value="INFO" />
			<appender-ref ref="db" />
		</root>
	</log4net>	
</configuration>