private void InsertValue() { // retrieving to key var key = db.NewsKeys.Single(x => x.NewsKeyID.Equals(HiddenSubmitID.Value)); // applying changes to value table var value = new NewsValue() { NewsKeyID = key.NewsKeyID, BodyText = TextEditorNews.Value, HeaderText = tbNewsTitleEditor.Text, CultureCode = LanguageList.SelectedValue, CreateDate = DateTime.Today }; key.NewsValues.Add(value); db.SubmitChanges(); }
/// <summary> /// Insert a new news item in both NewsKey and NewsValue tables /// </summary> private void InsertKeyAndValue() { NewsKey key = new NewsKey { NewsDate = NewsCalender.SelectedDate, TopNewsIndicator = cbTopNews.Checked, }; NewsValue value = new NewsValue { BodyText = TextEditorNews.Value, CreateDate = DateTime.Today, CultureCode = BRITISH_CULTURE, // always english for new items HeaderText = tbNewsTitleEditor.Text }; key.NewsValues.Add(value); db.NewsKeys.InsertOnSubmit(key); db.SubmitChanges(); }