public int GetVisitCountForToday() { using (var context = new LitIsEpicContext(_connectionString)) { return(context.Visits.Count(v => v.Date.Date == DateTime.Today)); } }
public IEnumerable <VisitCounts> GetFiveMostFrequentIPs() { using (var context = new LitIsEpicContext(_connectionString)) { return(context.Visits.GroupBy(v => v.IpAddress) .OrderByDescending(v => v.Count()).Take(5).Select(g => new VisitCounts { IpAddress = g.Key, Count = g.Count() }).ToList()); } }
public void AddVisit(string ipAddress) { Visit visit = new Visit { IpAddress = ipAddress, Date = DateTime.Now }; using (var context = new LitIsEpicContext(_connectionString)) { context.Visits.Add(visit); context.SaveChanges(); } }