public NorthwindPublisherRepository()
        {
            _context = new NorthwindContext();

            Mapper.CreateMap<Supplier, Publisher>()
                .ForMember(p => p.CompanyName, m => m.MapFrom(s => s.CompanyName))
                .ForMember(p => p.HomePage, m => m.MapFrom(s => s.HomePage))
                .ForMember(p => p.PublisherId, m => m.MapFrom(s => KeyEncoder.Encode(s.SupplierID, DbTypes.Northwind)))
                .ForMember(p => p.Description, m => m.MapFrom(s => String.Format("Address: {0}", s.Address)));
        }
        public NorthwindGameRepository()
        {
            _context = new NorthwindContext();

            Mapper.CreateMap<Product, Game>()
              .ForMember(g => g.GameId, m => m.MapFrom(p => KeyEncoder.Encode(p.ProductID, DbTypes.Northwind)))
              .ForMember(g => g.Key, m => m.MapFrom(p => p.ProductID.ToString()))
              .ForMember(g => g.Name, m => m.MapFrom(p => p.ProductName))
              .ForMember(g => g.Price, m => m.MapFrom(p => p.UnitPrice))
              .ForMember(g => g.UnitsInStock, m => m.MapFrom(p => p.UnitsInStock))
              .ForMember(g => g.PublisherId, m => m.MapFrom(p => p.SupplierID))
              .ForMember(g => g.Genres, m => m.MapFrom(p => new List<Genre> { new Genre() { GenreId = KeyEncoder.Encode(p.CategoryID.Value, DbTypes.Northwind), Name = p.Category.CategoryName } }))
              .ForMember(g => g.PlatformTypes, m => m.MapFrom(p => new List<PlatformType>()))
              .ForMember(g => g.Comments, m => m.MapFrom(p => new List<Comment>()))
              .ForMember(g => g.Publisher, m => m.MapFrom(p => new Publisher() { PublisherId = KeyEncoder.Encode(p.SupplierID.Value, DbTypes.Northwind) }));
        }