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();
}
