public User SelectByUsernameAndPassword(string username, string password) { return(PerformQuery(() => { return AsyncConnection.Table <User>() .Where(x => x.Username.ToLower().Equals(username.ToLower()) && x.Password.Equals(password)) .FirstOrDefaultAsync(); })); }
/// <summary> /// Select the Accelerometer-records between 2 DateTime-objects. /// </summary> /// <param name="start">The start DateTime.</param> /// <param name="end">The end DateTime.</param> /// <returns>A collection of Accelerometer-records.</returns> public IEnumerable <Accelerometer> SelectBetweenDates(DateTime start, DateTime end) { return(PerformQuery(() => { return AsyncConnection.Table <Accelerometer>() .Where(x => x.DateTime >= start && x.DateTime <= end) .ToListAsync(); })); }