private void button1_Click(object sender, RoutedEventArgs e) { // test for SGDD and it's fragment DBEngine _dbEngine = App.EngineInstance.GetDBEngine; Table_SGDD t1 = new Table_SGDD(){ ID ="1", Version = 23}; Table_SGDD_Fragment f1 = new Table_SGDD_Fragment() { FragmentID = "f1", SGDD_ID = "1" }; Table_SGDD_Fragment f2 = new Table_SGDD_Fragment() { FragmentID = "f2", SGDD_ID = "1" }; try { _dbEngine.CmtvDBContext.SGDD_items.InsertOnSubmit(t1); _dbEngine.CmtvDBContext.SGDD_Fragment_items.InsertOnSubmit(f1); _dbEngine.CmtvDBContext.SGDD_Fragment_items.InsertOnSubmit(f2); _dbEngine.CmtvDBContext.SubmitChanges(); } catch (Exception e1) { } var sgdd = (from c in _dbEngine.CmtvDBContext.SGDD_items select c).First(); var v2 = from c in _dbEngine.CmtvDBContext.SGDD_Fragment_items where c.SGDD.ID == sgdd.ID select c; //foreach (var v in v2) { _dbEngine.CmtvDBContext.SGDD_Fragment_items.DeleteAllOnSubmit(v2); } _dbEngine.CmtvDBContext.SGDD_items.DeleteOnSubmit(sgdd); _dbEngine.CmtvDBContext.SubmitChanges(); //v.FirstOrDefault() //SaveContentData(new Table_Content() { ServiceID = "4", ID = "C2", ContentName = "朝闻天下", ContentClass = "Video", StartTime = DateTime.Now, EndTime = DateTime.Now }); //SaveContentData(new Table_Content() { ServiceID = "1", ID = "C3", ContentName = "生活早参考", ContentClass = "Video", StartTime = DateTime.Now, EndTime = DateTime.Now }); //SaveContentData(new Table_Content() { ServiceID = "4", ID = "C4", ContentName = "焦点访谈:用事实说话", ContentClass = "Video", StartTime = DateTime.Now, EndTime = DateTime.Now }); //SaveContentData(new Table_Content() { ServiceID = "1", ID = "C5", ContentName = "国际艺苑", ContentClass = "Video", StartTime = DateTime.Now.AddHours(-2), EndTime = DateTime.Now }); //SaveContentData(new Table_Content() { ServiceID = "2", ID = "C6", ContentName = "焦点访谈:", ContentClass = "Video", StartTime = DateTime.Now.AddMinutes(33), EndTime = DateTime.Now.AddHours(5) }); //SaveContentData(new Table_Content() { ServiceID = "2", ID = "C7", ContentName = "说话", ContentClass = "Video", StartTime = DateTime.Now, EndTime = DateTime.Now.AddHours(1) }); //SaveContentData(new Table_Content() { ServiceID = "3", ID = "C8", ContentName = "睛彩天下", ContentClass = "Video", StartTime = DateTime.Now, EndTime = DateTime.Now.AddMinutes(13) }); }
private void Remove(Table_SGDD_Fragment a) { a.SGDD = null; }
private void Add(Table_SGDD_Fragment a) { a.SGDD = this; }