Added a logging table to the project template database.

2 files changed, 59 insertions, 14 deletions

diff --git a/projecttemplates/WebFormsRelyingParty/Global.asax.cs b/projecttemplates/WebFormsRelyingParty/Global.asax.cs
index cc69f0c..0d99ac9 100644
--- a/projecttemplates/WebFormsRelyingParty/Global.asax.cs
+++ b/projecttemplates/WebFormsRelyingParty/Global.asax.cs
@@ -14,7 +14,7 @@ namespace WebFormsRelyingParty {
 
 	public class Global : System.Web.HttpApplication {
 		/// <summary>
-		/// The logger for this sample to use.
+		/// The logger for this web site to use.
 		/// </summary>
 		private static log4net.ILog logger = log4net.LogManager.GetLogger("WebFormsRelyingParty");
 
@@ -40,7 +40,7 @@ namespace WebFormsRelyingParty {
 		}
 
 		protected void Application_Error(object sender, EventArgs e) {
-			Logger.Error("An unhandled exception occurred in ASP.NET processing: " + Server.GetLastError(), Server.GetLastError());
+			Logger.Error("An unhandled exception occurred in ASP.NET processing for page " + HttpContext.Current.Request.Path, Server.GetLastError());
 		}
 
 		protected void Session_End(object sender, EventArgs e) {
diff --git a/projecttemplates/WebFormsRelyingParty/Web.config b/projecttemplates/WebFormsRelyingParty/Web.config
index 9dcc606..f0b01ff 100644
--- a/projecttemplates/WebFormsRelyingParty/Web.config
+++ b/projecttemplates/WebFormsRelyingParty/Web.config
@@ -59,29 +59,74 @@
 	</dotNetOpenAuth>
 	<!-- log4net is a 3rd party (free) logger library that DotNetOpenAuth will use if present but does not require. -->
 	<log4net>
-		<!--<appender name="RollingFileAppender" type="log4net.Appender.RollingFileAppender">
-			<file value="RelyingParty.log" />
-			<appendToFile value="true" />
-			<rollingStyle value="Size" />
-			<maxSizeRollBackups value="10" />
-			<maximumFileSize value="100KB" />
-			<staticLogFileName value="true" />
-			<layout type="log4net.Layout.PatternLayout">
-				<conversionPattern value="%date (GMT%date{%z}) [%thread] %-5level %logger - %message%newline" />
-			</layout>
-		</appender>-->
+		<appender name="AdoNetAppender" 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="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\WebFormsRelyingParty.mdf;Integrated Security=True;User Instance=True" />
+			<commandText value="INSERT INTO [Log] ([Date],[Thread],[Level],[Logger],[Message],[Exception]) VALUES (@log_date, @thread, @log_level, @logger, @message, @exception)" />
+			<parameter>
+				<parameterName value="@log_date" />
+				<dbType value="DateTime" />
+				<layout type="log4net.Layout.RawTimeStampLayout" />
+			</parameter>
+			<parameter>
+				<parameterName value="@thread" />
+				<dbType value="String" />
+				<size value="255" />
+				<layout type="log4net.Layout.PatternLayout">
+					<conversionPattern value="%thread" />
+				</layout>
+			</parameter>
+			<parameter>
+				<parameterName value="@log_level" />
+				<dbType value="String" />
+				<size value="50" />
+				<layout type="log4net.Layout.PatternLayout">
+					<conversionPattern value="%level" />
+				</layout>
+			</parameter>
+			<parameter>
+				<parameterName value="@logger" />
+				<dbType value="String" />
+				<size value="255" />
+				<layout type="log4net.Layout.PatternLayout">
+					<conversionPattern value="%logger" />
+				</layout>
+			</parameter>
+			<parameter>
+				<parameterName value="@message" />
+				<dbType value="String" />
+				<size value="4000" />
+				<layout type="log4net.Layout.PatternLayout">
+					<conversionPattern value="%message" />
+				</layout>
+			</parameter>
+			<parameter>
+				<parameterName value="@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 level -->
 		<root>
 			<level value="WARN" />
-			<appender-ref ref="RollingFileAppender" />
+			<appender-ref ref="AdoNetAppender" />
 		</root>
 		<!-- Specify the level for some specific categories -->
 		<logger name="DotNetOpenAuth">
 			<level value="WARN" />
 		</logger>
+		<logger name="DotNetOpenAuth.OpenId">
+			<level value="INFO" />
+		</logger>
+		<logger name="DotNetOpenAuth.OAuth">
+			<level value="INFO" />
+		</logger>
 	</log4net>
 	<appSettings />
 	<connectionStrings>
+		<!-- Remember to keep this connection string in sync with the one (if any) that appears in the log4net section. -->
 		<add name="DatabaseEntities" connectionString="metadata=res://*/Model.csdl|res://*/Model.ssdl|res://*/Model.msl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\WebFormsRelyingParty.mdf;Integrated Security=True;User Instance=True;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />
 	</connectionStrings>
 	<system.web>