// Insert new person to existing course
public static void InsertPerson()
{
using (EFM2MEntities context = new EFM2MEntities())
{
Person person = new Person()
{
FirstName = "Ji",
LastName = "Zhou"
};
person.Course.Add(context.Course.FirstOrDefault());
context.AddToPerson(person);
try
{
Console.WriteLine("Inserting Person {0} {1} .",
person.FirstName,
person.LastName);
context.SaveChanges();
Query();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
// 插入新的person到现存的course
public static void InsertPerson()
{
using (EFM2MEntities context = new EFM2MEntities())
{
Person person = new Person()
{
FirstName = "Ji",
LastName = "Zhou"
};
person.Course.Add(context.Course.FirstOrDefault());
context.AddToPerson(person);
try
{
Console.WriteLine("Inserting Person {0} {1} .",
person.FirstName,
person.LastName);
context.SaveChanges();
Query();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
// Get all the persons with their courses
public static void Query()
{
using (EFM2MEntities context = new EFM2MEntities())
{
var query = from p in context.Person.Include("Course")
select p;
Console.WriteLine("Persons with their Course");
foreach (Person p in query)
{
Console.WriteLine("{0}: {1} {2}", p.PersonID,
p.FirstName, p.LastName);
foreach (Course c in p.Course)
{
Console.WriteLine(" {0}", c.Title);
}
}
Console.WriteLine();
}
}
// 插入新的person包括新的course
public static void InsertPersonWithCourse()
{
using (EFM2MEntities context = new EFM2MEntities())
{
Person person = new Person()
{
FirstName = "Yichun",
LastName = "Feng"
};
Course course = new Course()
{
CourseID = 2208,
Title = "UML"
};
person.Course.Add(course);
context.AddToPerson(person);
try
{
Console.WriteLine("Inserting Person {0} {1} with course "
+ "{2}.", person.FirstName, person.LastName,
course.Title);
context.SaveChanges();
Query();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
// Insert new person with new course
public static void InsertPersonWithCourse()
{
using (EFM2MEntities context = new EFM2MEntities())
{
Person person = new Person()
{
FirstName = "Yichun",
LastName = "Feng"
};
Course course = new Course()
{
CourseID = 2208,
Title = "UML"
};
person.Course.Add(course);
context.AddToPerson(person);
try
{
Console.WriteLine("Inserting Person {0} {1} with course "
+ "{2}.", person.FirstName, person.LastName,
course.Title);
context.SaveChanges();
Query();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
// Update one existing person
public static void UpdatePerson()
{
using (EFM2MEntities context = new EFM2MEntities())
{
Person person = new Person();
person.PersonID = 34;
context.AttachTo("Person", person);
person.FirstName = "Monica";
Course course = new Course()
{
CourseID = 2209,
Title = "Operating System"
};
person.Course.Add(course);
try
{
Console.WriteLine(
"Modifying Person 34's last to {0} and add course {1}"
+ " to it", person.LastName, course.Title);
context.SaveChanges();
Query();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
// 更新一个现存的person
public static void UpdatePerson()
{
using (EFM2MEntities context = new EFM2MEntities())
{
Person person = new Person();
person.PersonID = 34;
context.AttachTo("Person", person);
person.FirstName = "Monica";
Course course = new Course()
{
CourseID = 2209,
Title = "Operating System"
};
person.Course.Add(course);
try
{
Console.WriteLine(
"Modifying Person 34's last to {0} and add course {1}"
+ " to it", person.LastName, course.Title);
context.SaveChanges();
Query();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
// 获取所有的persons和他们的courses
public static void Query()
{
using (EFM2MEntities context = new EFM2MEntities())
{
var query = from p in context.Person.Include("Course")
select p;
Console.WriteLine("Persons with their Course");
foreach (Person p in query)
{
Console.WriteLine("{0}: {1} {2}", p.PersonID,
p.FirstName, p.LastName);
foreach (Course c in p.Course)
{
Console.WriteLine(" {0}", c.Title);
}
}
Console.WriteLine();
}
}