/// <summary>
/// Use XmlColumn to store the Xml file in the database
/// </summary>
/// <param name="document">the Xml file we need to store in the datase</param>
static void ImportYearCourses(XDocument document)
{
using (MySchoolContext school = new MySchoolContext())
{
// Set the value of Courses property with the Xml document to store the Xml file.
YearCourse yearCourse = new YearCourse {
Year = 2012, Courses = document
};
school.YearCourses.Add(yearCourse);
school.SaveChanges();
}
}
/// <summary>
/// Use LinqToXml to import information in the xml file into the database
/// </summary>
/// <param name="document">the Xml file that we import into the database</param>
static void ImportCourses(XDocument document)
{
using (MySchoolContext school = new MySchoolContext())
{
// Get the Course information from the Xml document
IEnumerable <Course> courses =
from c in document.Descendants("Course")
select new Course
{
CourseID = c.Element("CourseId") == null?
Guid.NewGuid().ToString() : c.Element("CourseId").Value,
Title = c.Element("Title") == null ? null : c.Element("Title").Value,
Credits = c.Element("Credits") == null ? -1 : Int32.Parse(c.Element("Credits").Value),
Department = c.Element("Department") == null ? null : c.Element("Department").Value
};
foreach (Course course in courses)
{
school.Courses.Add(course);
}
school.SaveChanges();
}
}