The OleDbTarget logs to an OLEDB database.  It automatically discards oldest entries after reaching a default of 10,000 log messages.  This behavior can be overridden.  Although rolling is supported, the database table will need to be created manually.

The default table name is tblLog. Here are the column names and types:
LogDate OleDbType.DBTimeStamp
Message OleDbType.VarChar
Additional OleDbType.VarChar   
ElapsedMilliseconds OleDbType.Decimal
LogLevel OleDbType.VarChar, 50
MachineName OleDbType.VarChar, 100
UserName OleDbType.VarChar, 100
ProcessName OleDbType.VarChar, 100
CallingMethod OleDbType.VarChar, 255
LineNumber OleDbType.VarChar, 100

 

It has these properties that can be configured:

• Name - Defaults to OleDbTarget
• LoggingMode - Defines which mode to use for the target; Synchronous, Buffered, or Asynchronous.  The default is Synchronous.
• MessageFormat - What to output in the log.  See the Message Format topic for more information.
• DateFormat - The date format for the %LogTime% variable in the MessageFormat. See the Date Format topic for more information.
• MinimumLevel - The minimum logging level to log a message.
• AssemblyNameFilter - If specified, only log for a specific assembly name.  See the Filtering topic.
• NamespaceFilter - If specified, only log for a specific namespace.  See the Filtering topic.
• ClassNameFilter - If specified, only log for a specific class name.  See the Filtering topic.
• MethodNameFilter - If specified, only log for a specific method name.  See the Filtering topic.
• ThreadNameFilter - If specified, logging will only occur for the thread id or thread name specified. See the Filtering topic.
• UserNameFilter - If specified, logging will only occur for the specific user name.  See the Filtering topic.
• MachineNameFilter - If specified, logging will only occur for the specific machine name.  See the Filtering topic.
• BufferSize -  When a logging target has a Mode of Buffered, this is how often messages are committed.  See the Buffered Logging topic.
• ConnectionString - Get or set the connection string.
• TableName - Get or set the table name.  Defaults to tblLog
• MaxEntries - Discard the oldest entries that are greater than MaxEntries.  Set to zero to disable.

 

//Example runtime configuration, can also use log.config, app.config, or web.config
Log.ResetConfiguration();

OleDbTarget target = new OleDbTarget();
target.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Work\Documents\database.mdb;User Id=admin;Password=;";
target.TableName = "LogTable";
//Set to zero to not discard max entries
target.MaxEntries = 10000;
Log.Config.Targets.Add(target);

Log.Debug("This is a test");