public async Task SaveUserLog(string ip, string searchWord, string connString) { using (var db = new AnagramContext(connString)) { var userLogEntity = new UserLogEntity { UserIP = ip, LogDate = DateTime.UtcNow }; userLogEntity.CachedWordEntity = db.CachedWordEntities.First(s => s.SearchWord == searchWord); db.UserLogEntities.Add(userLogEntity); await db.SaveChangesAsync(); } }
public async Task AddToChaced(string searchWord, List <WordEntity> wordEntities, string connString) { using (var db = new AnagramContext(connString)) { var cachedWordEntity = new CachedWordEntity { SearchWord = searchWord, }; foreach (var item in wordEntities) { cachedWordEntity.WordEntities.Add(db.WordEntities.FirstOrDefault(m => m.WordId == item.WordId)); } db.CachedWordEntities.Add(cachedWordEntity); await db.SaveChangesAsync(); } }