Enterprise Library v2.0 : log to database

Last week-end I've been playing with the Logging Application Block of the Enterprise Library v2.0 to setup logging to a database ...

How to setup logging to a database with EntLib v2.0?

1. Create logging database with tables and stored procedures
   Script can be found in [Install Folder]\Microsoft Enterprise Library January 2006\src\Logging\TraceListeners\Database\Scripts.
2. Create new configuration file with the Enterprise Library Configuration Tool.
3. Add Data Access Application Block and set connectionString to logging database.
4. Add Logging Application Block and add a Database Trace Listener to the Trace Listeners.
5. Set DatabaseInstanceName and formatter on created Database Trace Listener.
6. Add reference to the created Database Trace Listener in the general category.
7. Add references Microsoft.Practices.EnterpriseLibrary.Logging and Microsoft.Practices.EnterpriseLibrary.Logging.Database to your project.
8. Write some code to log to the database.

            try

            {

                throw new Exception("My Special Exception");

            }

            catch (Exception ex)

            {

                //Logging

                LogEntry logEntry = new LogEntry();

                logEntry.Message = ex.ToString();

                logEntry.Title = ex.Message;

                logEntry.Priority = 1;

                logEntry.Severity = System.Diagnostics.TraceEventType.Error;

 

                Logger.Write(logEntry);

            }

Don't forget the reference in your project to Microsoft.Practices.EnterpriseLibrary.Logging.Database. Otherwise you will end up with the Invalid TraceListenerData type in configuration error.