I have used the Enterprise library Blocks (which in different forms have been around since 2005) in quite a few projects. Individually the components are pretty good (not always best of breed) but they are well integrated and when used in the way which they were intended to be used work well.

I have just upgraded a client application to Visual Studio 2015 + .Net 4.5 + Enterprise Library V6 and some of the steps were not immediately obvious so hopefully this saves someone else some time. I have sample code for Azure Cloud Service Web and Worker roles.

For both web and worker roles I added the Azure Diagnostics listener to the listener config section of the enterprise library logging settings.

<loggingConfiguration name="" tracingEnabled="true" defaultCategory="General">
	<listeners>
    <add listenerDataType="Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.SystemDiagnosticsTraceListenerData, Microsoft.Practices.EnterpriseLibrary.Logging, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35&amp;amp;quot;
         type="Microsoft.WindowsAzure.Diagnostics.DiagnosticMonitorTraceListener, Microsoft.WindowsAzure.Diagnostics, Version=2.8.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
         name="AzureDiagnosticTraceListener"/>
   </listeners>
...
</loggingConfiguration>

I then enabled diagnostics on the role and configured the transfer of logs.

Azure Diagnostic Configuration

This replaces the DiagnosticMonitorConfiguration based approach

DiagnosticMonitorConfiguration diagConfig = DiagnosticMonitor.GetDefaultInitialConfiguration();
diagConfig.Logs.ScheduledTransferLogLevelFilter = LogLevel.Verbose;

// Enable scheduled transfer
diagConfig.Directories.ScheduledTransferPeriod = TimeSpan.FromMinutes(1);
diagConfig.Logs.ScheduledTransferPeriod = TimeSpan.FromMinutes(1);

...
DiagnosticMonitor.Start("Microsoft.WindowsAzure.Plugins.Diagnostics.ConnectionString", diagConfig);

For the web role I configured the exception and logging blocks in the Global.asax.cs file

protected void Application_Start()
{
   AreaRegistration.RegisterAllAreas();
   GlobalConfiguration.Configure(WebApiConfig.Register);
   FilterConfig.RegisterGlobalFilters(GlobalFilters.Filters);
   RouteConfig.RegisterRoutes(RouteTable.Routes);
   BundleConfig.RegisterBundles(BundleTable.Bundles);

   // Load the Entlib logging block configuration
   LogWriterFactory logWriterFactory = new LogWriterFactory();
   LogWriter logWriter = logWriterFactory.Create();
   Logger.SetLogWriter(logWriter);

   // Load the Entlib Exception block configuration
   ExceptionPolicyFactory policyFactory = new ExceptionPolicyFactory();
   exManager = policyFactory.CreateManager();
}

For the worker role I configured the exception and logging blocks in the worker role startup

public override bool OnStart()
{
   // Set the maximum number of concurrent connections
   ServicePointManager.DefaultConnectionLimit = 12;
   ...
   LogWriterFactory logWriterFactory = new LogWriterFactory();
   LogWriter logWriter = logWriterFactory.Create();
   Logger.SetLogWriter(logWriter);
   ...
   return result;
}

Then in the webrole webapi2 API controllers you can use embedded SQL or call stored procedures with retries. (This sample code uses the Northwind database and default retry configuration)

public IEnumerable<ProductDto> Get()
{
var products = new List<ProductDto>();

WebApiApplication.exManager.Process(() =>
{
Database db = new DatabaseProviderFactory().Create("NorthwindInstance");

RetryPolicy retry = new RetryPolicy<SqlDatabaseTransientErrorDetectionStrategy>(RetryStrategy.DefaultExponential);

var productAccessor = db.CreateSqlStringAccessor(
"SELECT [ProductID],[ProductName],[QuantityPerUnit],[UnitPrice],[UnitsInStock],[Discontinued] FROM Products",
MapBuilder<ProductDto>
.MapAllProperties()
.Map(p => p.ID).ToColumn("ProductID")
.Map(p => p.Name).ToColumn("ProductName")
.Map(p => p.QuantityPerUnit).ToColumn("QuantityPerUnit")
.Map(p => p.UnitPrice).ToColumn("UnitPrice")
.Map(p => p.UnitsInStock).ToColumn("UnitsInStock")
.Map(p => p.Discontinued).ToColumn("Discontinued")
.Build());
products = retry.ExecuteAction(() =>
{
return productAccessor.Execute().ToList();
});

}, "ProductService");

return products;
}

public ProductDto Get(int id)
{
ProductDto productDto = null;

WebApiApplication.exManager.Process(() =>
{
Database db = new DatabaseProviderFactory().Create("NorthwindInstance");

var productAccessor = db.CreateSqlStringAccessor(
"SELECT [ProductID],[ProductName],[QuantityPerUnit],[UnitPrice],[UnitsInStock],[Discontinued] FROM Products WHERE [ProductID]=@ProductID",
new ProdductGetByProductIdParameterMapper(db),
MapBuilder<ProductDto>
.MapAllProperties()
.Map(p => p.ID).ToColumn("ProductID")
.Map(p => p.Name).ToColumn("ProductName")
.Map(p => p.QuantityPerUnit).ToColumn("QuantityPerUnit")
.Map(p => p.UnitPrice).ToColumn("UnitPrice")
.Map(p => p.UnitsInStock).ToColumn("UnitsInStock")
.Map(p => p.Discontinued).ToColumn("Discontinued")
.Build());

productDto = productAccessor.Execute(id).SingleOrDefault();

}, "ProductService");

return productDto;
}