public override bool TestConnection(out string error)
{
ADODB.Connection TestConn = null;
try
{
error = "";
TestConn = GetConnection();
if (TestConn != null)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
error = e.Message;
return(false);
}
finally
{
ConnectionHealth.Status connStatus = new ConnectionHealth.Status(TestConn);
if (!connStatus.IsClosed())
{
TestConn.Close();
TestConn = null;
}
}
}
public override void Close()
{
ConnectionHealth.Status status = new ConnectionHealth.Status(m_pConnection);
if (!status.IsClosed())
{
RollbackTran();
m_pConnection.Close();
}
m_pConnection = null;
}
// IConnection Implementation
public override void Ensure()
{
ConnectionHealth.Status status = new ConnectionHealth.Status(m_pConnection);
if (status.IsClosed())
{
m_bInTransaction = false;
m_pConnection = null;
m_pConnection = GetConnection();
}
// TODO: potentially reaffirm connection?
}
