public async Task ReturnCorrectlyQueriedCollection() { var(connection, options) = await CreateUniqueMockDbConnectionForThisTest(); try { using (var context = new FittifyContext(options)) { var entitiesFromContext = await context .MapExerciseWorkout .Where(w => w.OwnerGuid == _ownerGuid) .Where(w => w.ExerciseId == 2 && w.WorkoutId == 2) .Include(i => i.Exercise) .Include(i => i.Workout) .ToListAsync(); var serializedEntitesFromContext = JsonConvert.SerializeObject(entitiesFromContext, new JsonSerializerSettings() { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); var resourceParameters = new MapExerciseWorkoutResourceParameters() { OwnerGuid = _ownerGuid, ExerciseId = 2, WorkoutId = 2 }; var repo = new MapExerciseWorkoutRepository(context); var collection = await repo.GetPagedCollection(resourceParameters); var serializedEntitiesFromRepo = JsonConvert.SerializeObject(collection, new JsonSerializerSettings() { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); Assert.AreEqual(serializedEntitesFromContext, serializedEntitiesFromRepo); } } finally { connection.Close(); } }
public async Task ReturnCorrectQueryByIdResult() { var(connection, options) = await CreateUniqueMockDbConnectionForThisTest(); try { using (var context = new FittifyContext(options)) { var entityFromContext = await context .MapExerciseWorkout .Include(i => i.Exercise) .Include(i => i.Workout) .FirstOrDefaultAsync(w => w.Id == 2); var serializedEntityFromContext = JsonConvert.SerializeObject(entityFromContext, new JsonSerializerSettings() { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); var repo = new MapExerciseWorkoutRepository(context); var entity = await repo.GetById(2); var serializedEntityFromRepo = JsonConvert.SerializeObject(entity, new JsonSerializerSettings() { ReferenceLoopHandling = ReferenceLoopHandling.Ignore }); Assert.AreEqual(serializedEntityFromContext, serializedEntityFromRepo); } } finally { connection.Close(); } }