public void SetAvailibility(DeviceInfo device, bool availible)
{
var db = _sharedDb ?? new SQLiteConnection(_dbName).OpenAndReturn();
using(SQLiteCommand availUpdate = new SQLiteCommand(db))
{
availUpdate.CommandText = string.Format("UPDATE DeviceInfo SET Availible = {0} WHERE UniqueId = '{1}'", availible ? 1 : 0, device.UniqueId);
availUpdate.ExecuteNonQuery();
}
if (_sharedDb == null)
{
db.Close();
GC.Collect();
}
}