I am able to log it to file.
but for db having issues
<target name="DatabaseLog" xsi:type="Database" keepConnection="false" useTransactions="true" dbProvider="mssql"
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=C:\temp\aa\app1\App_Data\Db1.mdf;Integrated Security=True;User Instance=True"
commandText="INSERT INTO LogTable(time_stamp, [level], logger, [message]) VALUES (@time_stamp,@level,@logger,@message);" >
<parameter name="@time_stamp" layout="${date}"/>
<parameter name="@level" layout="${level}"/>
<parameter name="@logger" layout="${logger}"/>
<parameter name="@message" layout="${message}"/>
</target>
<rules>
<logger name="*" minlevel="Fatal" writeTo="DatabaseLog" />
Can anyone tell me what I am doing incorrect.