CREATE TABLE [Chapter1].[Customer]

(

[CustomerId] [int] NOT NULL IDENTITY(1, 1),

[Name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,

[Email] [varchar] (1024) COLLATE Chinese_PRC_CI_AS NOT NULL,

[Phone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL

) ON [PRIMARY]

GO

ALTER TABLE [Chapter1].[Customer] ADD CONSTRAINT [PK_Customer_10] PRIMARY KEY CLUSTERED  ([CustomerId]) ON [PRIMARY]

GO

namespace Ex01

{

    using System;

    using System.Collections.Generic;

    public partial class Customer

    {

        public int CustomerId { get; set; }

        public string Name { get; set; }

        public string Email { get; set; }

        public string Phone { get; set; }

    }

}

namespace Ex01

{

    using System;

    using System.Data.Entity;

    using System.Data.Entity.Infrastructure;

    public partial class EFRecipesEntities : DbContext

    {

        public EFRecipesEntities()

            : base("name=EFRecipesEntities")

        {

        }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)

        {

            throw new UnintentionalCodeFirstException();

        }

        public virtual DbSet<Customer> Customers { get; set; }

    }

}