public void GetAllMyBooks() { var data = new List <MyBook> { new MyBook { Id = 1, BookId = 1, UserId = 1 }, new MyBook { Id = 2, BookId = 2, UserId = 2 }, new MyBook { Id = 3, BookId = 3, UserId = 3 }, }.AsQueryable(); var mockSet = new Mock <DbSet <MyBook> >(); mockSet.As <IQueryable <MyBook> >().Setup(m => m.Provider).Returns(data.Provider); mockSet.As <IQueryable <MyBook> >().Setup(m => m.Expression).Returns(data.Expression); mockSet.As <IQueryable <MyBook> >().Setup(m => m.ElementType).Returns(data.ElementType); mockSet.As <IQueryable <MyBook> >().Setup(m => m.GetEnumerator()).Returns(data.GetEnumerator()); var mockContext = new Mock <BookContext>(); mockContext.Setup(m => m.MyBooks).Returns(mockSet.Object); var myBookId = 1; var service = new MyBookService(mockContext.Object); var bookFound = service.GetById(myBookId); var excpectedResult = data.Where(mb => mb.Id == myBookId).FirstOrDefault(); Assert.AreEqual(excpectedResult.UserId, bookFound.UserId); }