public static IEnumerable <MapLogData> LoadDataByDate(DateTime from, DateTime to) { string query = "Select um.IdUserMeal, um.idcategory, m.name as MealName from usermeal as um inner join mealunit as mu on um.IDMealUnit=mu.IDMealUnit inner join meal m on mu.idmeal=m.idmeal where um.iduser="******" and um.mealdate BETWEEN ? and ?"; return(db.Query <MapLogData>(query, from, to)); }
public ConnectionInfo() { conn = StorageManager.GetConnection(); isTrialShown = false; }