create table Poet

(

    PoetId int identity(,) primary key,

    FirstName varchar(),

    MiddleName varchar(),

    LastName varchar()

)

create table Meter

(

    MeterId int identity(,) primary key,

    MeterName varchar()

)

create table Poem

(

    poemId int identity(,) primary key,

    PoetId int,

    MeterId int,

    Title varchar(),

    foreign key(PoetId) references poet(Poetid),

    foreign key(MeterId) references Meter(MeterId)

)

create view vwLibrary

as

select  poet.FirstName,poet.MiddleName,poet.LastName,poem.Title,Meter.MeterName from Meter ,poet,Poem where Meter.MeterId=poem.MeterId and poem.PoetId=poet.PoetId

static void Main(string[] args)

        {

            using (var context = new EF6RecipesEntities())

            {

                var poet = new poet { FirstName = "John", LastName = "Milton" };

                var poem = new Poem { Title = "Paradis Lost" };

                var meter = new Meter { MeterName = "Iambic Pentameter" };

                poem.poet = poet;

                poem.Meter = meter;

                context.Poems.Add(poem);

                poem = new Poem { Title="Paradis Regained" };

                poem.poet = poet;

                poem.Meter = meter;

                context.Poems.Add(poem);

                poet = new poet { FirstName = "Lewis", LastName = "Carroll" };

                poem = new Poem { Title = "The Hunting of the Shark" };

                meter = new Meter { MeterName = "Anapestic Tetrameter" };

                poem.Meter = meter;

                poem.poet = poet;

                context.Poems.Add(poem);

                poet = new poet { FirstName = "Lord", LastName = "Byron" };

                poem = new Poem { Title = "Don Juan" };

                poem.Meter = meter;

                poem.poet = poet;

                context.Poems.Add(poem);

                context.SaveChanges();

                Console.WriteLine("----------------读取Poet----------------");

                var poets = context.poets;

                foreach (var poettemp in poets)

                {

                    Console.WriteLine("{0}{1}", poettemp.FirstName, poettemp.LastName);

                    foreach (var poemtemp in poet.Poems)

                    {

                        Console.WriteLine("\t{0} ({1})", poemtemp.Title, poemtemp.Meter.MeterName);

                    }

                }

                Console.ReadKey();

            }

        }