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); } }