public string GetMostPopularIpAddress() { using (var context = new LITIsEpicDataContext(_connectionString)) { return(context.GetFiveMostFrequentIPs().First().IPAddress); } }
public IEnumerable <GetFiveMostFrequentIPsResult> GetFiveMostFrequentIPs() { using (var context = new LITIsEpicDataContext(_connectionString)) { return(context.GetFiveMostFrequentIPs().ToList()); } }
public int GetVisitCountForToday() { using (var context = new LITIsEpicDataContext(_connectionString)) { return(context.Visits.Count(v => v.Date.Date == DateTime.Today)); } }
public void AddVisit(string ipAddress) { Visit visit = new Visit { IPAddress = ipAddress, Date = DateTime.Now }; using (var context = new LITIsEpicDataContext(_connectionString)) { context.Visits.InsertOnSubmit(visit); context.SubmitChanges(); } }