// @nuget: Z.EntityFramework.Classic

​

using System;

using System.Data.Entity;

using System.Linq;

using System.Collections.Generic;

using System.ComponentModel.DataAnnotations.Schema;

using System.ComponentModel.DataAnnotations;

using System.Data.Entity.Infrastructure.Annotations;

​

public class Program

{

    public static void Main()

    {

        InsertData();

        using (var context = new BookStore())

        {

            FiddleHelper.WriteTable(context.Authors.ToList());

        }

    }

    public static void InsertData()

    {

        using (var context = new BookStore())

        {

            var Authors = new List<Author>

            {

                new Author() {FirstName = "Mark", LastName = "Cuban", Email = "mark.cuban@example.com"},

                new Author() {FirstName = "Andy", LastName = "Holloway", Email = "andy.holloway@example.com"}

            };

            context.Authors.AddRange(Authors);

            context.SaveChanges();

        }

    }

    public class BookStore : DbContext

    {

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

        {

        }

​

        public DbSet<Author> Authors { get; set; }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)

        {

            modelBuilder.Entity<Author>()

                .Property(a => a.Email)

                .HasColumnType("VARCHAR")

                .HasMaxLength(450)

                .HasColumnAnnotation("Index", new IndexAnnotation(new IndexAttribute("Index_Email") { IsUnique = true }));

​

        }

    }

​

    public class Author

    {

        public int AuthorId { get; set; }

        public string FirstName { get; set; }

        public string LastName { get; set; }

        public string Email { get; set; }

    }

}