public string GetValidToken(long GuestID, string lang) { //var token = new ObjectParameter("ReturnToken", typeof(string)); using (var db = new InnermetrixDBEntities()) { DateTime cutOffDateTime = DateTime.Now.Subtract(TimeSpan.FromHours(1)); var data = db.Tokens.Where( r => (r.IsUsed ?? false) == false && ((r.IsLocked ?? false) == false || ((r.IsLocked ?? false) == true && r.DateLocked > cutOffDateTime)) && (r.IsArchived ?? false == false )) .First(); data.GuestId = GuestID; data.IsLocked = true; data.DateLocked = DateTime.Now; data.Lang = lang; db.SaveChanges(); return(data.Token1.ToString()); } }