public void TestAddBooks()
{
using (var context = new MyDBContext())
{
List <Book> books = OneToManyHelper.CreateBooks(10, 10);
context.Books.AddRange(books);
int result = context.SaveChanges();
Assert.IsTrue(result > 0);
}
}
public void TestAddBookReviewToBooks()
{
using (var context = new MyDBContext())
{
Book firstBook = context.Books.FirstOrDefault();
int reviewCount = firstBook.BookReviews.Count;
BookReview review = OneToManyHelper.CreateBookReview(firstBook);
int result = context.SaveChanges();
Assert.IsTrue(result > 0);
//重新加载图书
Book firstBookFromDB = context.Books.FirstOrDefault();
//书评数加一
Assert.IsTrue(firstBookFromDB.BookReviews.Count == reviewCount + 1);
//应该能找得到新加的书评
BookReview newReview = firstBookFromDB.BookReviews.First(br => br.BookReviewId == review.BookReviewId);
Assert.IsNotNull(newReview);
}
}
public void TestBookReviewMove()
{
using (var context = new MyDBContext())
{
//找到第一本和第二本书，把第一本书的第一条书评移给第二本书
Book firstBook = context.Books.Include("BookReviews").FirstOrDefault();
Book secondBook = context.Books.Include("BookReviews").ToList().ElementAt(1);
if (firstBook != null && firstBook.BookReviews.Count > 0)
{
BookReview bookReview = firstBook.BookReviews.ElementAt(0);
OneToManyHelper.ShowBookReivew(bookReview);
//先从原对象集合中移除
firstBook.BookReviews.Remove(bookReview);
//再追加到新对象的集合中
secondBook.BookReviews.Add(bookReview);
int result = context.SaveChanges();
Assert.IsTrue(result > 0);
//重新提取书评
BookReview reviewFromDB = context.BookReviews.FirstOrDefault(r => r.BookReviewId == bookReview.BookReviewId);
Assert.IsTrue(reviewFromDB.BookId == secondBook.BookId);
OneToManyHelper.ShowBookReivew(reviewFromDB);
}
}
}