public int SetSetting(int userId, string key, string value) { using (var db = new LogistoDb()) { int id = db.UserSettings.Where(w => w.UserId == userId && w.Key == key).Select(s => s.ID).FirstOrDefault(); if (id > 0) { var setting = db.UserSettings.First(w => w.ID == id); setting.Value = value; db.Update(setting); return(id); } else { var setting = new UserSetting { UserId = userId, Key = key, Value = value }; return(Convert.ToInt32(db.InsertWithIdentity(setting))); } } }