using System.Collections.Generic;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using Microsoft.EntityFrameworkCore;

​

namespace InsertFromQuery

{

    public class Program

    {

        public static void Main()

        {

            using (var context = new EntityContext())

            {

                context.Database.EnsureCreated();

            }

​

            using (var context = new EntityContext())

            {

                // Insert data to source table

                context.BulkInsert(Data());

                // Now insert to destination table

                context.zcustomersource.InsertFromQuery("zcustomerdest", c => c);

            }

        }

​

        public static List<Customer> Data()

        {

            List<Customer> list = new List<Customer>();

​

            bool isActive = false;

​

            for (int i = 0; i < 3; i++)

            {

                isActive = !isActive;

                list.Add(new Customer() { CustomerID = i,  Name = "Customer_" + i});

            }

​

            return list;

        }

​

        public class EntityContext : DbContext

        {

            public EntityContext()

            {

            }

​

            protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

            {

                optionsBuilder.UseInMemoryDatabase(databaseName: "test");

​

                base.OnConfiguring(optionsBuilder);

            }

​

            public DbSet<Customer> zcustomersource { get; set; }

        }

​

        public class Customer

        {

            [Key]

            [DatabaseGenerated(DatabaseGeneratedOption.None)]

            public int CustomerID { get; set; }

            public string Name { get; set; }

        }

    }

}

​