This is a simple MVC sample which shows how to set up a basic Enterprise Library Semantic Logging (SLAB) application which logs to the database.

Create a simple MVC project

Get the Semantic Logging from nuget:

These nuget packages adds just 4 new assemblies as shown (No Unity):

Install the scripts to your database:
Scripts can be found here ..\packages\EnterpriseLibrary.SemanticLogging.Database.1.0.1304.0\scripts

Step 1 Create an EventSource

using System.Diagnostics.Tracing;

namespace MvcEL6Test.Logger
{
    [EventSource(Name = "BasicLogger")]
    public class BasicLogger : EventSource
    {
        public static readonly BasicLogger Log = new BasicLogger();

        [Event(1, Message = "{0}", Level = EventLevel.Critical)]
        public void Critical(string message)
        {
            if (IsEnabled()) WriteEvent(1, message);
        }

        [Event(2, Message = "{0}", Level = EventLevel.Error)]
        public void Error(string message)
        {
            if (IsEnabled()) WriteEvent(2, message);
        }

        [Event(3, Message = "{0}", Level = EventLevel.Warning)]
        public void Warning(string message)
        {
            if (IsEnabled()) WriteEvent(3, message);
        }
       
    }
}

Step 2 Use the logger in code

using System.Web.Mvc;
using MvcEL6Test.Logger;

namespace MvcEL6Test.Controllers
{
    public class HomeController : Controller
    {
        //
        // GET: /Home/
        public ActionResult Index()
        {
            BasicLogger.Log.Critical("Hello World Critical");
            BasicLogger.Log.Error("Hello World Error");
            BasicLogger.Log.Warning("Hello World Warning");
            return View();
        }

    }
}

Step 3 Consume the logger or add a sink
In Global.asax.cs

using System.Diagnostics.Tracing;
using System.Web.Http;
using System.Web.Mvc;
using System.Web.Optimization;
using System.Web.Routing;
using Microsoft.Practices.EnterpriseLibrary.SemanticLogging;
using MvcEL6Test.Logger;

namespace MvcEL6Test
{
    // Note: For instructions on enabling IIS6 or IIS7 classic mode, 
    // visit http://go.microsoft.com/?LinkId=9394801

    public class MvcApplication : System.Web.HttpApplication
    {
        protected void Application_Start()
        {
            AreaRegistration.RegisterAllAreas();

            WebApiConfig.Register(GlobalConfiguration.Configuration);
            FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
            RouteConfig.RegisterRoutes(RouteTable.Routes);
            BundleConfig.RegisterBundles(BundleTable.Bundles);

            var sqlListener = SqlDatabaseLog.CreateListener("HomeController", "Data Source=.;Initial Catalog=Logging;Integrated Security=True");
            sqlListener.EnableEvents(BasicLogger.Log, EventLevel.Error);

        }
    }
}

Now your finished, your logs can be viewed in the database:

Note: Our warning log was not logged due the the sink configuration in the global.asax

Here’s how it work:

Source code:
https://github.com/damienbod/MVCEL6DbLogging.git

Enterprise Library 6, Semantic Logging, Part 2, OUT-OF-PROCESS
Enterprise Library 6, Semantic Logging, Part 3, Getting into the details
Enterprise Library 6, Semantic Logging, Part 4 advantages, customising

Links:

http://www.codeproject.com/Articles/602077/InstrumentationpluswithplusSemanticplusLoggingplus

http://entlib.codeplex.com/wikipage?title=Entlib6CTPReleaseNotes

http://blogs.msdn.com/b/agile/archive/2013/02/07/embracing-semantic-logging.aspx

http://channel9.msdn.com/posts/Introducing-Semantic-Logging

http://msdn.microsoft.com/en-us/magazine/cc163437.aspx

http://channel9.msdn.com/Series/PerfView-Tutorial/PerfView-Tutorial-8-Generating-Your-Own-Events-with-EventSources

http://blogs.msdn.com/b/vancem/archive/2012/07/09/logging-your-own-etw-events-in-c-system-diagnostics-tracing-eventsource.aspx