JoachimL

return movieRepository.GetAll().Select(Mapper.Map<MoviePresentationModel>);

JoachimL

return movieRepository.GetAll().Project<Movie>().To<MoviePresentationModel>();

JoachimL

namespace WebApi.OData.Repositories
{
    public class MovieRepository
    {
        static Context context = new Context();

        internal IQueryable<Domain.Movie> GetAll()
        {
            return context.Movies;
        }

JoachimL

namespace WebApi.OData.Services
{
    public class MovieService
    {
        private readonly MovieRepository movieRepository;

        public MovieService(MovieRepository movieRepository)
        {
            this.movieRepository = movieRepository;
        }

JoachimL

namespace WebApi.OData.Models
{
    public class MoviePresentationModel
    {
        public int Id { get; set; }
        public string Title { get; set; }
        public int YearOfRelease { get; set; }
     }
}

JoachimL

namespace WebApi.OData.Domain
{
    public class Movie
    {
        public virtual int Id { get; set; }
        public virtual string Title { get; set; }
        public virtual DateTime Released { get; set; }
        public virtual ICollection<Person> Directors { get; set; }
        public virtual ICollection<Person> Actors { get; set; }
        public virtual ICollection<UserRating> Ratings { get; set; }

JoachimL

namespace WebApi.OData
{
    public class DomainToModelMappingProfile : Profile
    {
        public DomainToModelMappingProfile()
        {
            Mapper.CreateMap<Movie, MoviePresentationModel>()
                .ForMember(m => m.YearOfRelease, x => x.MapFrom(y => y.Released.Year))
                .ForMember(m => m.AverageRating, x => x.MapFrom(y => y.Ratings.Average(r => r.Rating)))
                .ForMember(m => m.Actors, x => x.MapFrom(y => y.Actors.Select(a => a.Name)));

JoachimL

namespace WebApi.OData
{
    public class DomainToModelMappingProfile : Profile
    {
        public DomainToModelMappingProfile()
        {
            Mapper.CreateMap<Movie, MoviePresentationModel>()
                .ForMember(m => m.YearOfRelease, x => x.MapFrom(y => y.Released.Year))
                .ForMember(m => m.AverageRating, x => x.MapFrom(y => y.Ratings.Average(r => r.Rating)))
                .ForMember(m => m.Actors, x => x.MapFrom(y => y.Actors.Select(a => a.Name)));

JoachimL

foreach(var relatedPage in SlowPageRelationRepository.GetPagesRelatedTo(this.PageId, "en"")
{
  // ...
}

JoachimL

    public static class SlowPageRelationRepository
    {
        private static readonly SlowPageDatabaseHandler PageDatabaseHandler = new SlowPageDatabaseHandler();

        public static ICollection<Page> GetPagesRelatedTo(int page, string language)
        {
            return PageDatabaseHandler.GetRelatedPages(page, language);
        }

        public static CategorizedPageCollection GetCategorizedPagesRelatedTo(int page, string language)