public void TestAddCategoryToFilm()
{
var mockSet = new Mock <DbSet <Film> >();
var mockContext = new Mock <DVDRentalContext>();
var mockTransaction = new Mock <ITransaction>();
mockContext.Setup(context => context.Films).Returns(mockSet.Object);
mockContext.Setup(context => context.BeginTransaction()).Returns(mockTransaction.Object);
repository = new FilmContext(mockContext.Object);
repository.AddCategoryToFilm(3, 4);
mockContext.Verify(context => context.ExecuteSqlCommand(false, It.IsAny <string>(), "3", "4"));
mockContext.Verify(m => m.SaveChanges(), Times.Once());
mockTransaction.Verify(tran => tran.Commit(), Times.Once());
}
