private void LogMessageCount(MomentumDiscordDbContext dbContext, DiscordMessage message) { var user = dbContext.DailyMessageCount .SingleOrDefault(x => x.UserId == message.Author.Id && x.ChannelId == message.Channel.Id && x.Date == message.CreationTimestamp.UtcDateTime.Date); if (user != null) { // If they have a message count for that day, just increment user.MessageCount++; } else { // No data for the current state, make a new message count var newUser = new DailyMessageCount { ChannelId = message.Channel.Id, Date = message.CreationTimestamp.UtcDateTime.Date, UserId = message.Author.Id, MessageCount = 1 }; dbContext.Add(newUser); } dbContext.SaveChanges(); }