public List<T> GetValidRecords<T>(Entities context) where T: class, IGetListOfTables { try { return context.Set<T>().Where(x => x.Valid == 1).ToList(); } catch (Exception ex) { throw new Exception(ex.Message); } }
[TestMethod] public void GetValidRecords() { var data = new List<tableName> { new tableName() {Valid= 1}, new tableName() {Valid= 1} }.AsQueryable(); var mockSet = new Mock<DbSet<tableName>>(); mockSet.As<IQueryable<tableName>>().Setup(m => m.Provider).Returns(data.Provider); mockSet.As<IQueryable<tableName>>().Setup(m => m.Expression).Returns(data.Expression); mockSet.As<IQueryable<tableName>>().Setup(m => m.ElementType).Returns(data.ElementType); mockSet.As<IQueryable<tableName>>().Setup(m => m.GetEnumerator()).Returns(data.GetEnumerator()); var mockContext = new Mock<ALMONEntitiesNew>(); mockContext.Setup(x => x.tableName).Returns(mockSet.Object); var database = new Database(); var numberOfRecords = database.GetValidRecords<tableName>(mockContext.Object); Assert.AreEqual(2, numberOfRecords.Count, "Wrong number of valid records."); }
new Entities()
GetValidRecords
context
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)