public string FindConnectionIdOnUsername(string username) { HubConnectionMap hbc = db.HubConnectionMap.Where(hc => hc.UserName == username) .FirstOrDefault(); return(hbc?.ConnectionId); }
public void AddOrUpdateHubConnection(HubConnectionMap hubConnectionMap) { HubConnectionMap hcp = db.HubConnectionMap.Where(hc => hc.UserName == hubConnectionMap.UserName) .FirstOrDefault(); if (hcp == null) { db.HubConnectionMap.Add(hubConnectionMap); } else { hcp.ConnectionId = hubConnectionMap.ConnectionId; db.Entry(hcp).State = EntityState.Modified; } db.SaveChanges(); }