public IEnumerable <Workout> GetAllWorkouts() { using (var con = WorkoutDatabase.GetConnection()) { return(con.Query <Workout>("SELECT w.Id, w.Distance, wt.Name WorkoutType FROM Workouts w LEFT JOIN WorkoutTypes wt ON w.TypeId = wt.Id")); } }
public void Insert(double distance, int typeId) { using (var con = WorkoutDatabase.GetConnection()) { con.Execute("INSERT INTO Workouts (Distance, TypeId) VALUES (@Distance, @TypeId)", new { Distance = distance, TypeId = typeId }); } }
public IEnumerable <WorkoutType> GetWorkoutTypes() { using (var con = WorkoutDatabase.GetConnection()) { return(con.Query <WorkoutType>("SELECT Id, Name FROM WorkoutTypes")); } }