public void DeleteResult(Result result) { using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); string query = string.Format("delete from Result where ResultId = {0}", result.ResultId); _core.ExecuteStoreCommand(query); _core.SaveChanges(); } }
public void DeleteScores(EntityCollection<Score> scores) { using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); foreach (var score in scores) { string query = string.Format("delete from Score where ScoreId = {0}", score.ScoreId); _core.ExecuteStoreCommand(query); } _core.SaveChanges(); } }
public Series DeleteAllSeriesClasses(Series series) { foreach (var seriesClass in series.SeriesClasses) { using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); string query = string.Format("delete from SeriesClass where SeriesClassId = {0}", seriesClass.SeriesClassId); _core.ExecuteStoreCommand(query); } } return series; }
public Series UpdateSeries(Series series, IList<SeriesClass> newClasses) { using (var connection = new EntityConnection("name=CoreContainer")) { _core = new CoreContainer(connection); _core.Series.Attach(_core.Series.Include("SeriesClasses").Single(s => s.SeriesId == series.SeriesId)); _core.Series.ApplyCurrentValues(series); if (series.SeriesClasses != null && series.SeriesClasses.Count > 0) { foreach (var oldClass in series.SeriesClasses) { string query = string.Format("delete from SeriesClass where SeriesClassId = {0}", oldClass.SeriesClassId); _core.ExecuteStoreCommand(query); } } var saveSeries = _core.Series.Single(s => s.SeriesId == series.SeriesId); foreach (var selectedClass in newClasses) { saveSeries.SeriesClasses.Add(new SeriesClass{ClassId = selectedClass.ClassId, SeriesId = selectedClass.SeriesId}); } _core.SaveChanges(); } return series; }