public void Create_DataBase() { try { // 连接数据库引擎 using (ContactDataContext aDataContext1 = new ContactDataContext(ConnectionString)) { if (!aDataContext1.DatabaseExists()) { aDataContext1.CreateDatabase(); MessageBox.Show("数据库已经创建!"); } else { //MessageBox.Show("数据库已经存在!"); } } ContactDataContext aDataContext = new ContactDataContext(ConnectionString); DataContext = new ContactDataContext(ConnectionString); aDataContext.SubmitChanges(); } catch (Exception msg) { MessageBox.Show(msg.Message); } }
public void Dele_Data() { ContactDataContext aDataContext = new ContactDataContext(ConnectionString); Contact aExistContact = (from r in aDataContext.Contact where r.Id == Id select r).FirstOrDefault(); if (aExistContact != null) { aDataContext.Contact.DeleteOnSubmit(aExistContact); aDataContext.SubmitChanges(); Contacts = aDataContext.Contact; } Update(); }
public void Save_To_Database() { if (Name != null) { Create_DataBase(); Contact aNewContact = new Contact { Name = Name, Mobile = Mobile, Memo = Memo }; ContactDataContext aDataContext = new ContactDataContext(ConnectionString); aDataContext.Contact.InsertOnSubmit(aNewContact); aDataContext.SubmitChanges(); Contacts = aDataContext.Contact; } Update(); }
public void Update() { ContactDataContext aDataContext = new ContactDataContext(ConnectionString); aDataContext.SubmitChanges(); }