public void CoursesWithSingleInstructorShouldBeBulkInserted()
{
using (var db = new SchoolContext())
{
var instructors = GetInstructors().ToArray();
var courses = GetCourses().ToArray();
courses[0].Instructors.Add(instructors[0]);
courses[1].Instructors.Add(instructors[0]);
courses[2].Instructors.Add(instructors[0]);
courses[3].Instructors.Add(instructors[1]);
courses[4].Instructors.Add(instructors[1]);
var request = new BulkInsertRequest <Course>
{
Entities = courses.ToList(),
Recursive = true,
AllowNotNullSelfReferences = false
};
db.BulkInsertAll(request);
var dbInstructors = db.Instructors
.Include(i => i.Courses)
.ToArray();
var dbCourses = db.Courses.ToArray();
Assert.AreEqual(2, dbInstructors.Length);
Assert.AreEqual(5, dbInstructors.SelectMany(i => i.Courses).Count());
Assert.AreEqual(3, dbInstructors[0].Courses.Count);
Assert.AreEqual(2, dbInstructors[1].Courses.Count);
Assert.AreSame(dbCourses[0].Instructors.Single(), dbCourses[1].Instructors.Single());
Assert.AreSame(dbCourses[0].Instructors.Single(), dbCourses[2].Instructors.Single());
Assert.AreSame(dbCourses[3].Instructors.Single(), dbCourses[4].Instructors.Single());
}
}
public void InstructorsWithMulitpleCoursesShouldBeBulkInserted()
{
using (var db = new SchoolContext())
{
var instructors = GetInstructors().ToArray();
var courses = GetCourses().ToArray();
instructors[0].Courses.Add(courses[0]);
instructors[0].Courses.Add(courses[1]);
instructors[0].Courses.Add(courses[2]);
instructors[1].Courses.Add(courses[3]);
instructors[1].Courses.Add(courses[4]);
var request = new BulkInsertRequest <Instructor>
{
Entities = instructors.ToList(),
EnableRecursiveInsert = EnableRecursiveInsert.Yes,
AllowNotNullSelfReferences = AllowNotNullSelfReferences.No
};
db.BulkInsertAll(request);
var dbInstructors = db.Instructors
.Include(i => i.Courses)
.ToArray();
var dbCourses = db.Courses.ToArray();
Assert.AreEqual(2, dbInstructors.Length);
Assert.AreEqual(5, dbInstructors.SelectMany(i => i.Courses).Count());
Assert.AreEqual(3, dbInstructors[0].Courses.Count);
Assert.AreEqual(2, dbInstructors[1].Courses.Count);
Assert.AreSame(dbCourses[0].Instructors.Single(), dbCourses[1].Instructors.Single());
Assert.AreSame(dbCourses[0].Instructors.Single(), dbCourses[2].Instructors.Single());
Assert.AreSame(dbCourses[3].Instructors.Single(), dbCourses[4].Instructors.Single());
}
}
public void StackOverflowTest()
{
using (var db = new SchoolContext())
{
var i1 = new Instructor
{
FirstName = "Mickey",
LastName = "Mouse",
HireDate = new DateTime(1928, 5, 15),
OfficeAssignment = new OfficeAssignment {
Location = "Room 1A"
}
};
db.Instructors.Add(i1);
db.SaveChanges();
var d1 = new Department
{
Name = "Computer Science",
Budget = 10000000,
};
var c1 = new Course
{
Credits = 4,
Title = "Foundations of Data Science",
Department = d1
};
db.Courses.Add(c1);
db.SaveChanges();
i1.Courses.Add(c1);
db.SaveChanges();
Assert.AreEqual(1, db.Instructors.SelectMany(i => i.Courses).Distinct().Count());
var instructor = db.Instructors
.Include(i => i.Courses.Select(c => c.Department))
.Include(i => i.OfficeAssignment)
.Single();
instructor.InstructorID = 0;
instructor.OfficeAssignment.InstructorID = 0;
var request = new BulkInsertRequest <Instructor>
{
Entities = new[] { instructor }.ToList(),
EnableRecursiveInsert = EnableRecursiveInsert.Yes,
AllowNotNullSelfReferences = AllowNotNullSelfReferences.No
};
db.BulkInsertAll(request);
Assert.AreEqual(2, db.Instructors.SelectMany(i => i.Courses).Count());
}
}