public void Insert(TimeTravelLog timeTravelLog)
 {
     using (IDbConnection dbConnection = Connection)
     {
         dbConnection.Open();
         dbConnection.Execute(
             "insert into timetravellog(TravelToYear, TravelDate, TimeTravelerId) "
             + "values(@TravelToYear, @TravelDate, @TimeTravelerId);"
             , new {
             TravelToYear   = timeTravelLog.TravelToYear,
             TravelDate     = timeTravelLog.TravelDate,
             TimeTravelerId = timeTravelLog.TimeTravelerId
         }
             , commandType: CommandType.Text);
     }
 }
 public void Update(TimeTravelLog timeTravelLog)
 {
     using (IDbConnection dbConnection = Connection)
     {
         dbConnection.Open();
         dbConnection.Execute(
             "update timetravellog "
             + "set TravelToYear = @TravelToYear, TravelDate = @TravelDate, TimeTravelerId = @TimeTravelerId "
             + "where TimeTravelLogId = @TimeTravelLogId;"
             , new {
             TimeTravelLogId = timeTravelLog.TimeTravelLogId,
             TravelToYear    = timeTravelLog.TravelToYear,
             TravelDate      = timeTravelLog.TravelDate,
             TimeTravelerId  = timeTravelLog.TimeTravelerId
         }
             , commandType: CommandType.Text);
     }
 }