public void GetAllOccupations_Test() { //Arrange var Occupations = new List <OccupationRating>() { new OccupationRating { OccupationId = 1, RatingId = 5, OccupationName = "Farmer" }, new OccupationRating { OccupationId = 2, RatingId = 5, OccupationName = "MECHANIC" }, new OccupationRating { OccupationId = 3, RatingId = 6, OccupationName = "Cleaner" } }.AsQueryable(); var OccupationMock = new Mock <DbSet <OccupationRating> >(); OccupationMock.As <IQueryable <OccupationRating> >().Setup(m => m.Provider).Returns(Occupations.Provider); OccupationMock.As <IQueryable <OccupationRating> >().Setup(m => m.Expression).Returns(Occupations.Expression); OccupationMock.As <IQueryable <OccupationRating> >().Setup(m => m.ElementType).Returns(Occupations.ElementType); OccupationMock.As <IQueryable <OccupationRating> >().Setup(m => m.GetEnumerator()).Returns(Occupations.GetEnumerator()); objDBContext.Setup(x => x.OccupationRating).Returns(OccupationMock.Object); //Act var objActualOccupations = objService.GetAllOccupations(); //Assert Assert.IsNotNull(objActualOccupations); Assert.AreEqual(Occupations, objActualOccupations.ToList <OccupationRating>()); }