public static IEnumerable <ClientDto> GetClients() { MapperInitiliazer.InitializeClients(); using (var context = new PawnShopContext()) { var clients = context.Clients //.Where( // c => c.Contracts.Any(con => con.Employee.Office.Name == LoginUser.User.Office.Name)) .ProjectTo <ClientDto>() .ToList(); return(clients); } }