使用Nlog将自定义对象写入sql server数据库表

<nlog>
  <targets>
    <target name="database" xsi:type="Database" connectionStringName="YourConnectionStringName">
      <commandText>
        INSERT INTO YourTableName (Column1, Column2, ...) VALUES (@Param1, @Param2, ...)
      </commandText>
      <parameter name="@Param1" layout="${event-properties:item=Property1}" />
      <parameter name="@Param2" layout="${event-properties:item=Property2}" />
      ...
    </target>
  </targets>
  <rules>
    <logger name="YourLoggerName" minlevel="Info" writeTo="database" />
  </rules>
</nlog>

using NLog;

public class CustomObject
{
    public string Property1 { get; set; }
    public int Property2 { get; set; }
    // 其他属性...
}

public class MyClass
{
    private static readonly Logger logger = LogManager.GetLogger("YourLoggerName");

    public void WriteCustomObjectToDatabase()
    {
        CustomObject obj = new CustomObject
        {
            Property1 = "Value1",
            Property2 = 123
            // 设置其他属性...
        };

        logger.Info(obj);
    }
}