public void Register(DeviceInfo info)
{
var db = _sharedDb ?? new SQLiteConnection(_dbName).OpenAndReturn();
using (SQLiteCommand deviceInfo = new SQLiteCommand(db))
{
deviceInfo.CommandText =
string.Format(
"REPLACE INTO DeviceInfo (MobileOs, DeviceModel, OsVersion, UniqueId, IP, LastSeen, Availible) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', datetime('now'), 1)",
info.MobileOs, info.DeviceModel, info.OsVersion, info.UniqueId, info.IP);
deviceInfo.ExecuteNonQuery();
}
if (_sharedDb == null)
{
db.Close();
GC.Collect();
}
}