// @nuget: EntityFramework

// @nuget: Z.EntityFramework.Extensions

using System;

using System.Data.Entity;

using System.Linq;

using System.Collections.Generic;

​

public class Program

{

    public static void Main()

    {

        // BulkInsert: INSERT all entities in the database.

        using (var context = new EntityContext())

        {

            context.BulkInsert(Data());

        }

​

        // Query data

        using (var context = new EntityContext())

        {

            context.Database.Log = Console.Write;

            var customers = context.Customers.FirstOrDefault(x => x.Name == "Customer_3").Name;

        }

        // Query data

        using (var context = new EntityContext())

        {

            context.Database.Log = Console.Write;

            var customers = context.Customers.Where(x => x.Name == "Customer_3").Select(x => x.Name).First();

        }

    }

​

    public static List<Customer> Data()

    {

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

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

        {

            list.Add(new Customer()

            {Name = "Customer_" + i});

        }

​

        return list;

    }

​

    public class EntityContext : DbContext

    {

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

        {

        }

​

        public DbSet<Customer> Customers

        {

            get;

            set;

        }

    }

​

    public class Customer

    {

        public int CustomerID

        {

            get;

            set;

        }

​

        public string Name

        {

            get;

            set;

        }

    }

}