log4net issue while using stored procedure
<p>I am trying do logging using stored procedure. I created a stored procedure which will insert a row in to the table</p>

<pre><code>CREATE PROCEDURE [dbo].[usp_insert_log]
(
    @log_date datetime,
    @log_level varchar(10),
    @log_message nvarchar(max)
)
AS
BEGIN
    INSERT INTO [dbo].[Log] ([log_date], [log_level], [log_message])
    VALUES (@log_date, @log_level, @log_message)
END
</code></pre>

<p>In my config file </p>

<pre><code>&lt;appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender"&gt;
    &lt;bufferSize value="1" /&gt;
    &lt;connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /&gt;
    &lt;connectionStringName  value="AnalyticsLogging" /&gt;
    &lt;commandText value="usp_insert_log" /&gt;
    &lt;parameter&gt;
        &lt;parameterName value="@log_date" /&gt;
        &lt;dbType value="DateTime" /&gt;
        &lt;layout type="log4net.Layout.RawTimeStampLayout"&gt;
            &lt;conversionPattern value="%date" /&gt;
        &lt;/layout&gt;
    &lt;/parameter&gt;
&lt;/appender&gt; 
</code></pre>

<p>I am getting the following error</p>

<blockquote>
  <p>log4net:ERROR [AdoNetAppender] ErrorCode: GenericFailure. Exception while writing to database<br>
  System.Data.SqlClient.SqlException (0x80131904): Procedure or function 'usp_insert_log' expects parameter '@log_date', which was not supplied.</p>
</blockquote>

<p>Is there anything I am missing?</p>