使用简介<EntityFramework6.0>

2018-06-17 19:58:55来源:未知 阅读 ()

新老客户大回馈,云服务器低至5折

 

序言

在这一篇中,我们将演示EnitityFramework基本的建模【建模也是EntityFramework最核心的特性】范例,例如实体的分离和继承等。我们开始了演示如何创建一个简单的概念模型的例子,然后让EnitityFramework建立底层数据库。在余下的例子中,我们将告诉你如何从现有的表和数据库关系创建模型。

创建一个简单的Model

1.点击添加新建项,选择Data下的ADO.NET实体模型,并选择空模型。

 2.右键选择新增实体

3.将实体命名为Person,实体集命名为People,添加名为Id,类型为Int32的键属性。

4.添加标量属性

 

 5.添加标量属性FirstName. LastName, MiddleName,PhoneNumber,同时指定键属性Id的数据库生成策略

 6.空白处右键-->属性,修改实体容器名称为EF6RecipesContext,数据库架构名称为article2,这些都是为更好地管理Model做的有意义的动作。

7.右键选择根据模型生成数据库,选择创建新的连接,选择目标数据库

8.在.edmx文件中生成仓储模型,并运行数据库脚本

 它是怎么工作的

using System;

namespace EntityFrameworkDemo
{
    class Program
    {
        static void Main()
        {
            using (var context=new EF6RecipesContext())
            {
                var person = new Person
                {
                    FirstName = "Robert",
                    MiddleName = "Allen",
                    LastName = "Doe",
                    PhoneNumber = "867-5309"
                };
                context.People.Add(person);
                person = new Person
                {
                    FirstName = "John",
                    MiddleName = "K.",
                    LastName = "Smith",
                    PhoneNumber = "824-3031"
                };
                context.People.Add(person);
                person = new Person
                {
                    FirstName = "Billy",
                    MiddleName = "Albert",
                    LastName = "Minor",
                    PhoneNumber = "907-2212"
                };
                context.People.Add(person);
                person = new Person
                {
                    FirstName = "Kathy",
                    MiddleName = "Anne",
                    LastName = "Ryan",
                    PhoneNumber = "722-0038"
                };
                context.People.Add(person);
                context.SaveChanges();
            }
            using (var context=new EF6RecipesContext())
            {
                foreach (var person in context.People)
                {
                    Console.WriteLine("{0} {1} {2}, Phone: {3}",
                            person.FirstName, person.MiddleName,
                            person.LastName, person.PhoneNumber);
                }
            }
            Console.ReadKey();
        }
    }
}

运行效果

 至于使用using的好处,这里就不多说了,因为这也是最基础的。下面是书中的解释片段,不熟悉的同学可以看看

      There are a few nice features of using()statements. First, when the code execution leaves the using() {}block,
the Dispose()method on the context will be called because DbContext implements the IDisposable interface. For
DbContext, the Dispose()method closes any active database connections and properly cleans up any other resources
that need to be released.
     Second, no matter how the code leaves the using(){}block, the Dispose()method is called. Most importantly,
this includes return statements and exceptions that may be thrown within the code block. The using(){}block is kind
of a guarantee that critical resources will be reclaimed properly.
  The best practice here is always to wrap your code in the using(){}block when creating new instances of
DbContext. It’s one more step to help bulletproof your code

 从已存在的数据库中生成模型

问题

现有一个已存在的数据库中的表,假设也有一些视图,已经一些外键约束,你想为这个数据库创建模型

解决方案

你的数据库中的结构可能是这样:

首先我们安装前面的步骤,打开向导,选择由数据库生成,并选择需要操作的表和视图

点击完成后,EntityFramework会推断出Poet和Poem,以及Meter和Poem之间一对多的关系

从模型浏览器中我们可以看出一首诗对应一个作者和一个分类,分别对应Poet和Meter导航属性,如果我们有一个Poem的实体,那么导航属性Poet也会包含一个诗人的实体的集合【因为是一对多的关系】,同理Meter也是如此。因为SQLSERVER不支持在视图上定义关系,因此vwLiberary上市一组空的导航属性

它是怎么工作的

using (var context = new EF6RecipesEntities())
            {
                var poet = new Poet {FirstName = "John", LastName = "Milton"};
                var poem = new Poem {Title = "Paradise Lost"};
                var meter = new Meter {MeterName = "Iambic Pentameter"};
                poem.Meter = meter;
                poem.Poet = poet;
                context.Poems.Add(poem);
                poem = new Poem {Title = "Paradise Regained", Meter = meter, Poet = poet};
                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", Meter = meter, Poet = poet};
                context.Poems.Add(poem);
                context.SaveChanges();
            }
            using (var context = new EF6RecipesEntities())
            {
                var poets = context.Poets;
                foreach (var poet in poets)
                {
                    Console.WriteLine("{0} {1}", poet.FirstName, poet.LastName);
                    foreach (var poem in poet.Poems)
                    {
                        Console.WriteLine("\t{0} ({1})", poem.Title, poem.Meter.MeterName);
                    }
                }

            }
             // using our vwLibrary view
            using (var context = new EF6RecipesEntities())
            {
                var items = context.vwLibraries;
                foreach (var item in items)
                {
                    Console.WriteLine("{0} {1}", item.FirstName, item.LastName);
                    Console.WriteLine("\t{0} ({1})", item.Title, item.MeterName);
                }
            }

 

运行效果

我们使用SQLSERVER profile监视这段代码的执行情况发现,并不是执行完var poets = context.vwLibraries;就立即去数据库中抓取数据,而知在执行foreach的时候才去查询之后将结果存放在内存中对数据进行不经过数据库直接从中读取,总之当前可以认为它是用到的时候才去执行,详细的流程待后续学习在进行总结。

 

标签:

版权申明:本站文章部分自网络,如有侵权,请联系:west999com@outlook.com
特别注意:本站所有转载文章言论不代表本站观点,本站所提供的摄影照片,插画,设计作品,如需使用,请与原作者联系,版权归原作者所有

上一篇:c#高级语言编程(第一部分)

下一篇:[System.Net]模拟Web请求编写简易单词查询客户端