I'm trying to log in a .net core project. It logs to the file but not to the database. Where is this problem originating from although my connection string and sql command are correct.
log4net.config
<log4net>
<appender name="JsonFileAppender" type="log4net.Appender.FileAppender">
<file value="C://Log//log.json" />
<layout type="DevFramework.Core.CrossCuttingConcerns.Logging.Log4Net.Layouts.JsonLayout" />
</appender>
<appender name="SqlServerAppender" type="log4net.Appender.AdoNetAppender">
<bufferSize value="1" />
<connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
<connectionString value="Data Source=DESKTOP-3EJVEUQ;Initial Catalog=Northwind;Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False" />
<commandText value="INSERT INTO Logs ([Detail],[Date],[Audit]) VALUES (@logDetail,@log_date,@audit)" />
<parameter>
<parameterName value="@logDetail" />
<dbType value="String" />
<size value="4000" />
<layout type="DevFramework.Core.CrossCuttingConcerns.Logging.Log4Net.Layouts.JsonLayout" />
</parameter>
<parameter>
<parameterName value="@log_date" />
<dbType value="DateTime" />
<layout type="log4net.Layout.PatternLayout" value="%date{dd'-'MM'-'yyyy HH':'mm':'ss'.'fff}" />
</parameter>
<parameter>
<parameterName value="@audit" />
<dbType value="String" />
<size value="50" />
<layout type="log4net.Layout.PatternLayout" value="%level" />
</parameter>
</appender>
<root>
<level value="All" />
<appender-ref ref="JsonFileAppender" />
<appender-ref ref="SqlServerAppender" />
</root>
</log4net>