Application hangs on SqlCeConnection.Dispose()

Hi,

I'm having the problem that my application hangs on SqlCeConnection.Dispose() when I'm closing the app.

public class DatabaseManager : IDisposable
{
private DbConnection connection = null;

// Singleton
private DatabaseManager()
{
this.CreateConnection();
}

~DatabaseManager()
{
this.Dispose();
}

public void Dispose()
{
if (this.connection != null)
{
this.connection.Dispose();
}
}
// ...
}

This only happens when I'm calling Application.Exit(); and Dispose is called through the destructor of the DatabaseManager class. When I'm disposing the connection during normal work the call works as intended. BTW I'm using SQL Server Mobile 3.0.5214.0 on a PPC 2003 AKU2 (Symbol PPT8846 industrial device).

Thanks for support,
Klaus

Your implementation is incorrect. There's some special handling involved if called from finalizer:

// Dispose(bool disposing) executes in two distinct scenarios.
// If disposing equals true, the method has been called directly
// or indirectly by a user's code. Managed and unmanaged resources
// can be disposed.
// If disposing equals false, the method has been called by the
// runtime from inside the finalizer and you should not reference
// other objects. Only unmanaged resources can be disposed.
private void Dispose(bool disposing)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemIDisposableClassDisposeTopic.asp

Generally you don't need finalizer in this class as you don’t have any native resources.