public static void DeleteSegmentsByRunnerRaceRecordId(long runnerRaceRecordId) { using (var db = new CCEntities()) { db.ExecuteStoreCommand(@" DELETE FROM RunnerRaceRecordSegment WHERE RunnerRaceRecordId = @runnerRaceRecordId", new SqlParameter("runnerRaceRecordId", runnerRaceRecordId)); } }
public static void DeleteWithId(long raceId) { using (var db = new CCEntities()) { var runnerRaceRecordIds = db.RunnerRaceRecords.Where(rr => rr.RaceId == raceId) .Select(rr => rr.RunnerRaceRecordId); if (runnerRaceRecordIds.Count() > 0) { db.ExecuteStoreCommand(@" DELETE FROM RunnerRaceRecordSegment WHERE RunnerRaceRecordId IN(" + string.Join(",", runnerRaceRecordIds) + ");"); } db.ExecuteStoreCommand(@" DELETE FROM RunnerRaceRecord WHERE RaceId = @raceId; DELETE FROM Race WHERE RaceId = @raceId;", new SqlParameter("raceId", raceId)); } }
public static void UnEnrollRunners(IEnumerable<long> unenrolledRunnerIds) { if (unenrolledRunnerIds.Count() > 0) { using (var db = new CCEntities()) { var ids = string.Join(",", unenrolledRunnerIds); db.ExecuteStoreCommand(@" DELETE FROM RunnerRaceRecordSegment WHERE RunnerRaceRecordId IN(" + ids + @"); DELETE FROM RunnerRaceRecord WHERE RunnerRaceRecordId IN(" + ids + @");"); } } }