public static void Open()
{
// must be closed first!
if (IsActive) { return; }
string dbfile = TFDBManager.DatabaseFilename;
if (dbfile == "") return;
_tfdb = new TFDatabase(dbfile);
if (!_tfdb.Settings.DatabaseVersion.Equals(database_verion))
{
UpgradeDatabase();
}
}
public Settings(TFDatabase _tfdb)
{
this._tfdb = _tfdb;
_settings = new Dictionary<string, string>();
OleDbCommand selectCMD = new OleDbCommand("SELECT * FROM Setting", _tfdb.Connection);
selectCMD.CommandTimeout = 30;
OleDbDataAdapter custDA = new OleDbDataAdapter();
custDA.SelectCommand = selectCMD;
_tbl = new DataTable();
custDA.Fill(_tbl);
_settings = _tbl.AsEnumerable()
.ToDictionary(r => r.Field<string>("setting"), r => r.Field<string>("value"));
}
static TFDatabase()
{
_tfdb = null;
}
