private void button2_Click(object sender, EventArgs e)
{
using (AdventureWorksEntities context = new AdventureWorksEntities())
{
try
{
DateTime Birthdt = new DateTime(1965, 9, 26);
DateTime Hiredt = new DateTime(2010, 1, 1);
Contact con = new Contact {
Title = "Geek", FirstName = "Scott", LastName = "Klein",
EmailAddress = "*****@*****.**", EmailPromotion = 0, Phone = "555-55-5555",
PasswordHash = "", PasswordSalt = "", rowguid = System.Guid.NewGuid(),
ModifiedDate = DateTime.Now
};
Employee emp = new Employee {
ContactID = 19983, NationalIDNumber = "12345678901",
LoginID = "sklein1", ManagerID = 1, Title = "Geek", BirthDate = Birthdt,
MaritalStatus = "M", Gender = "M", HireDate = Hiredt, SalariedFlag = true,
VacationHours = 80, SickLeaveHours = 40, CurrentFlag = true,
rowguid = System.Guid.NewGuid(), ModifiedDate = DateTime.Now
};
context.Employees.AddObject(emp);
context.Contacts.AddObject(con);
context.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void button3_Click(object sender, EventArgs e)
{
using (AdventureWorksEntities context = new AdventureWorksEntities())
{
try
{
DateTime Birthdt = new DateTime(1965, 9, 26);
DateTime Hiredt = new DateTime(2010, 1, 1);
Employee emp = new Employee {
ContactID = 19983, NationalIDNumber = "12345678902",
LoginID = "sklein2", ManagerID = 1, Title = "Geek", BirthDate = Birthdt,
MaritalStatus = "M", Gender = "M", HireDate = Hiredt, SalariedFlag = true,
VacationHours = 80, SickLeaveHours = 40, CurrentFlag = true,
rowguid = System.Guid.NewGuid(), ModifiedDate = DateTime.Now
};
context.Employees.AddObject(emp);
context.SaveChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
