// @nuget: Z.EntityFramework.Classic

// @nuget: AutoMapper -Version 6.2.2

​

using System;

using System.Linq;

using System.Data.Entity;

using AutoMapper;

using System.Collections.Generic;

using System.Linq;

​

public class Program

{

    public static void Main()

    {

        var mapper = (new MapperConfiguration(cfg => {

            cfg.CreateMap<B,A>()

                .ForMember(dest => dest.Id, opt => opt.Ignore());

        })).CreateMapper();

        using (var context = new EntityContext())

        {

            context.A.Add(new A() { Id = 1, Name ="Customer_A"});

            context.SaveChanges();  

        }

​

        using (var context = new EntityContext())

        {

            var result = context.A.ToList();

            FiddleHelper.WriteTable("PreMap", result);          

            var b = new List<B> { new B { Name = "t" } };

            result = result

                .Zip(b, (r,b2) => mapper.Map<B,A>(b2,r) )

                .ToList();

​

            FiddleHelper.WriteTable("Post Map", result);            

            var result2 = context.A.ToList();

            FiddleHelper.WriteTable("Context Result2", result2);            

        }

    }

​

    public class EntityContext : DbContext

    {

        public EntityContext() : base(FiddleHelper.GetConnectionStringSqlServer()){ }

        public DbSet<A> A { get; set; }

    }

    public class A

    {

        public int Id { get; set; }

        public string Name { get; set; }

    }

    public class B

    {

        public string Name { get; set; }

    }

}