0

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>
Ali Yıldızöz
  • 199
  • 1
  • 10

0 Answers0