public void EditTopics(int id, IEnumerable <int> topics) { var allTopics = _Db.TopicFeatures.Where(tf => tf.FeatureId == id).AsEnumerable(); var deletedTopics = allTopics.Where(tf => !topics.Contains(tf.TopicId)); var addTopics = topics.Where(i => !allTopics.Select(t => t.TopicId).Contains(i)); _Db.TopicFeatures.DeleteAllOnSubmit(deletedTopics); foreach (var topic in addTopics) { var tf = new TopicFeature { FeatureId = id, TopicId = topic }; _Db.TopicFeatures.InsertOnSubmit(tf); } _Db.SubmitChanges(); }
partial void DeleteTopicFeature(TopicFeature instance);
partial void UpdateTopicFeature(TopicFeature instance);
partial void InsertTopicFeature(TopicFeature instance);