public clsDBUltity(bool blnCreateNew = false)
{
_blnCreateNew = blnCreateNew;
if (!blnCreateNew)
{
_db = clsDBCore.getInstance();
}
else
{
_db = new clsDBCore(ConnectionString);
_db.Open();
}
}
public static void DisposeInstance()
{
if (_dbCore != null)
{
_dbCore.Close();
_dbCore.Dispose();
_dbCore = null;
}
//if (_cnn != null)
//{
// _cnn.Dispose();
// _cnn = null;
//}
}
public static clsDBCore getInstance(string connString = "")
{
if (_dbCore == null)
{
try
{
_dbCore = new clsDBCore(connString);
_dbCore.Open();
}
catch (Exception ex)
{
Console.WriteLine("getInstance: " + ex.Message);
}
}
return(_dbCore);
}
private bool disposedValue = false; // To detect redundant calls
protected virtual void Dispose(bool disposing)
{
if (!disposedValue)
{
if (disposing)
{
// TODO: dispose managed state (managed objects).
if (_db != null)
{
if (_blnCreateNew)
{
_db.Close();
}
_db.Dispose();
_db = null;
}
}
// TODO: free unmanaged resources (unmanaged objects) and override a finalizer below.
// TODO: set large fields to null.
disposedValue = true;
}
}