.NET Development by Eric

Every role in a Windows Azure Service has a default implementation for starting the diagnostics. How to read the diagnostics was not directly clear to me.
By dumping the diagnostic logs to your storage service in set intervals they become available to read with a tool like Cloud Storage Studio, but also with Visual Studio 2010. The logs are dumped into a Azure Table and can be queried.
Below is a small peace of code that dumps the diagnostic logs every 15 seconds:

DiagnosticMonitorConfiguration config = DiagnosticMonitor.GetDefaultInitialConfiguration();
config.Logs.ScheduledTransferPeriod = TimeSpan.FromSeconds(15.0);
DiagnosticMonitor.Start("DiagnosticsConnectionString", config);

The next hurdle in my Windows Azure project was the missing support for Sqlite. I needed to add these lines to the configuration to get it:

<system.data>
 <DbProviderFactories>
  <remove invariant = "System.Data.SQLite" />
  <add name         = "SQLite Data Provider"
       invariant    = "System.Data.SQLite"
       description  = ".Net Framework Data Provider for SQLite"
       type         = "System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.65.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139" />
 </DbProviderFactories>
</system.data>

But what about the type? Azure needs the fullname. I used reflector to get it. http://reflector.red-gate.com/download.aspx 
Note: Azure needs the x64 assembly, so package it for deployment.