DatabaseTarget Class

public class DatabaseTarget : Target, 
	IInstallable

Public Class DatabaseTarget
	Inherits Target
	Implements IInstallable

Dim instance As DatabaseTarget

type DatabaseTarget =  
    class
        inherit Target
        interface IInstallable
    end

 1<?xml version="1.0" ?>
 2<nlog xmlns="http://www.nlog-project.org/schemas/NLog.xsd"
 3      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 4      autoReload="true">
 5    <targets>
 6        <target name="database" xsi:type="Database">
 7
 8            <dbProvider>mssql</dbProvider>
 9
10            <!-- database connection parameters -->
11            <!-- alternatively you could provide a single 'connectionstring' parameter -->
12
13            <dbHost>.</dbHost> 
14            <dbDatabase>NLogDatabase</dbDatabase>
15            <dbUsername>nloguser</dbUsername>
16            <dbPassword>nlogpassword</dbPassword>
17
18            <commandText>
19                insert into LogTable(time_stamp,level,logger,message) values(@time_stamp, @level, @logger, @message);
20            </commandText>
21
22            <parameter name="@time_stamp" layout="${date}" />
23            <parameter name="@level" layout="${level}" />
24            <parameter name="@logger" layout="${logger}" />
25            <parameter name="@message" layout="${message}" />
26        </target>
27    </targets>
28
29    <rules>
30        <logger name="*" minlevel="Debug" writeTo="database" />
31    </rules>
32</nlog>

 1<?xml version="1.0" ?>
 2<nlog xmlns="http://www.nlog-project.org/schemas/NLog.xsd"
 3      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
 4
 5    <!-- configuration contributed by David Maly -->
 6
 7    <targets>
 8        <target name="database" xsi:type="Database" keepConnection="false"
 9                dbProvider="System.Data.OracleClient.OracleConnection,System.Data.OracleClient, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
10                connectionString="Data Source=MYORACLEDB;User Id=DBO;Password=MYPASSWORD;Integrated Security=no;"
11                commandText="insert into LOGTABLE( TIME_STAMP,LOGLEVEL,LOGGER,CALLSITE,MESSAGE) values( :TIME_STAMP,:LOGLEVEL,:LOGGER,:CALLSITE,:MESSAGE)">
12            <parameter name="TIME_STAMP" layout="${longdate}" />
13            <parameter name="LOGLEVEL" layout="${level:uppercase=true}" />
14            <parameter name="LOGGER" layout="${logger}" />
15            <parameter name="CALLSITE" layout="${callsite:filename=true}" />
16            <parameter name="MESSAGE" layout="${message}" />
17        </target>
18    </targets>
19
20    <rules>
21        <logger name="*" minlevel="Debug" writeTo="database" />
22    </rules>
23</nlog>

 1<?xml version="1.0" ?>
 2<nlog xmlns="http://www.nlog-project.org/schemas/NLog.xsd"
 3      xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
 4
 5    <!-- configuration contributed by David Maly -->
 6
 7    <targets>
 8        <target name="database" xsi:type="Database" keepConnection="false" dbProvider="oledb"
 9            connectionString="Provider=msdaora;Data Source=MYORACLEDB;User Id=DBO;Password=MYPASSWORD;"
10            commandText="insert into LOGTABLE( TIME_STAMP,LOGLEVEL,LOGGER,CALLSITE,MESSAGE) values(?,?,?,?,?)">
11            <parameter name="TIME_STAMP" layout="${longdate}" />
12            <parameter name="LOGLEVEL" layout="${level:uppercase=true}" />
13            <parameter name="LOGGER" layout="${logger}" />
14            <parameter name="CALLSITE" layout="${callsite:filename=true}" />
15            <parameter name="MESSAGE" layout="${message}" />
16        </target>
17    </targets>
18
19    <rules>
20        <logger name="*" minlevel="Debug" writeTo="database" />
21    </rules>
22</nlog>

 1using NLog;
 2using NLog.Targets;
 3
 4class Example
 5{
 6    static void Main(string[] args)
 7    {
 8        DatabaseTarget target = new DatabaseTarget();
 9        DatabaseParameterInfo param;
10
11        target.DBProvider = "mssql";
12        target.DBHost = ".";
13        target.DBUserName = "nloguser";
14        target.DBPassword = "pass";
15        target.DBDatabase = "databasename";
16        target.CommandText = "insert into LogTable(time_stamp,level,logger,message) values(@time_stamp, @level, @logger, @message);";
17
18        param = new DatabaseParameterInfo();
19        param.Name = "@time_stamp";
20        param.Layout = "${date}";
21        target.Parameters.Add(param);
22
23        param = new DatabaseParameterInfo();
24        param.Name = "@level";
25        param.Layout = "${level}";
26        target.Parameters.Add(param);
27
28        param = new DatabaseParameterInfo();
29        param.Name = "@logger";
30        param.Layout = "${logger}";
31        target.Parameters.Add(param);
32
33        param = new DatabaseParameterInfo();
34        param.Name = "@message";
35        param.Layout = "${message}";
36        target.Parameters.Add(param);
37
38        NLog.Config.SimpleConfigurator.ConfigureForTargetLogging(target, LogLevel.Debug);
39
40        Logger logger = LogManager.GetLogger("Example");
41        logger.Debug("log message");
42    }
43}