I'm currently connecting to the database using the following method:

MyType myObject;
using (var db = new Database("MyConnectionString"))
{
    myObject= db.SingleById<MyType>(1234);
}

return myObject;

All the examples are shown like this, including those used for the NPoco fork of PetaPoco examples. This is generally accepted as being the best practice approach. It certainly looks neat and tidy - more so than the other approach:

var db = new Database("MyConnectionString");
var myObject= db.SingleById<MyType>(1234);  
db.Dispose();

return myObject;

However, according to Microsoft, this is bad. Why? Because if your code throws an exception before the closing bracket, the Dispose() method is not called (since this is the place where any remaining connections are closed) and I was wondering if someone could clarify what the best practice way is of using PetaPoco to ensure correct handling of the database connection? If for example I wrapped the above two examples in try - catch - finally blocks, with the second one I could at least dispose of the database for sure by manually calling the Dispose(). Thanks in advance!