Note On <Programming Entity Framework 2nd Edition> -03

最新推荐文章于 2019-11-07 15:53:39 发布
最新推荐文章于 2019-11-07 15:53:39 发布
阅读量680 收藏
点赞数
分类专栏： C# .NET Framework Reference Books 文章标签： entity framework C#
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zlxadhkust/article/details/43023201
版权
Reference Books 同时被 3 个专栏收录
106 篇文章 1 订阅
订阅专栏
C#
50 篇文章 0 订阅
订阅专栏
.NET Framework
15 篇文章 0 订阅
订阅专栏

Chapter 8:


Install the database BreakAway


To run the .exe successfully, you need to change the name of serve to .\SQLExpress, which is (local) by default.



Create the EDM:







EDMX




The overview of the generated XML is:

<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
  <!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>

    </edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>

    </edmx:ConceptualModels>
    <!-- C-S mapping content -->
    <edmx:Mappings>

    </edmx:Mappings>
  </edmx:Runtime>
  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  <Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
    <Connection>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
      </DesignerInfoPropertySet>
    </Connection>
    <Options>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="ValidateOnBuild" Value="true" />
        <DesignerProperty Name="EnablePluralization" Value="true" />
        <DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
        <DesignerProperty Name="UseLegacyProvider" Value="false" />
        <DesignerProperty Name="CodeGenerationStrategy" Value="None" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams></Diagrams>
  </Designer>
</edmx:Edmx>


Entity


Take Customer table as example.




It's representation in StorageModels is:

<EntityType Name="Customers">
  <Key>
    <PropertyRef Name="ContactID" />
  </Key>
  <Property Name="ContactID" Type="int" Nullable="false" />
  <Property Name="CustomerTypeID" Type="int" Nullable="false" />
  <Property Name="InitialDate" Type="datetime" />
  <Property Name="PrimaryDesintation" Type="int" />
  <Property Name="SecondaryDestination" Type="int" />
  <Property Name="PrimaryActivity" Type="int" />
  <Property Name="SecondaryActivity" Type="int" />
  <Property Name="Notes" Type="varchar(max)" />
  <Property Name="RowVersion" Type="timestamp" StoreGeneratedPattern="Computed" Nullable="false" />
</EntityType>


It's representation in ConceptualModels is:

<EntityType Name="Customer">
  <Key>
    <PropertyRef Name="ContactID" />
  </Key>
  <Property Name="ContactID" Type="Int32" Nullable="false" />
  <Property Name="CustomerTypeID" Type="Int32" Nullable="false" />
  <Property Name="InitialDate" Type="DateTime" Precision="3" />
  <Property Name="PrimaryDesintation" Type="Int32" />
  <Property Name="SecondaryDestination" Type="Int32" />
  <Property Name="PrimaryActivity" Type="Int32" />
  <Property Name="SecondaryActivity" Type="Int32" />
  <Property Name="Notes" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
  <Property Name="RowVersion" Type="Binary" MaxLength="8" FixedLength="true" Nullable="false" annotation:StoreGeneratedPattern="Computed" />
  <NavigationProperty Name="Activity" Relationship="Self.FK_Customers_Activities" FromRole="Customers" ToRole="Activities" />
  <NavigationProperty Name="Activity1" Relationship="Self.FK_Customers_Activities1" FromRole="Customers" ToRole="Activities" />
  <NavigationProperty Name="Contact" Relationship="Self.FK_Customers_Contact" FromRole="Customers" ToRole="Contact" />
  <NavigationProperty Name="CustomerType" Relationship="Self.FK_Customers_CustomerTypes" FromRole="Customers" ToRole="CustomerTypes" />
  <NavigationProperty Name="Location" Relationship="Self.FK_Customers_Locations" FromRole="Customers" ToRole="Locations" />
  <NavigationProperty Name="Location1" Relationship="Self.FK_Customers_Locations1" FromRole="Customers" ToRole="Locations" />
  <NavigationProperty Name="Reservations" Relationship="Self.FK_Reservations_Customers" FromRole="Customers" ToRole="Reservations" />
</EntityType>


This part determines how the diagram looks like in the designer view.


It's representation in Mappings is:

  <EntitySetMapping Name="Customers">
	<EntityTypeMapping TypeName="BreakAwayModel.Customer">
	  <MappingFragment StoreEntitySet="Customers">
		<ScalarProperty Name="ContactID" ColumnName="ContactID" />
		<ScalarProperty Name="CustomerTypeID" ColumnName="CustomerTypeID" />
		<ScalarProperty Name="InitialDate" ColumnName="InitialDate" />
		<ScalarProperty Name="PrimaryDesintation" ColumnName="PrimaryDesintation" />
		<ScalarProperty Name="SecondaryDestination" ColumnName="SecondaryDestination" />
		<ScalarProperty Name="PrimaryActivity" ColumnName="PrimaryActivity" />
		<ScalarProperty Name="SecondaryActivity" ColumnName="SecondaryActivity" />
		<ScalarProperty Name="Notes" ColumnName="Notes" />
		<ScalarProperty Name="RowVersion" ColumnName="RowVersion" />
	  </MappingFragment>
	</EntityTypeMapping>
  </EntitySetMapping>


Relationship


Take the association between Customers & Activities as example.






Association's representation in StorageModels is:

<Association Name="FK_Customers_Activities">
  <End Role="Activities" Type="Self.Activities" Multiplicity="0..1" />
  <End Role="Customers" Type="Self.Customers" Multiplicity="*" />
  <ReferentialConstraint>
    <Principal Role="Activities">
      <PropertyRef Name="ActivityID" />
    </Principal>
    <Dependent Role="Customers">
      <PropertyRef Name="PrimaryActivity" />
    </Dependent>
  </ReferentialConstraint>
</Association>


Association's representation in ConceptualModels is:

<Association Name="FK_Customers_Activities">
  <End Role="Activities" Type="Self.Activity" Multiplicity="0..1" />
  <End Role="Customers" Type="Self.Customer" Multiplicity="*" />
  <ReferentialConstraint>
    <Principal Role="Activities">
      <PropertyRef Name="ActivityID" />
    </Principal>
    <Dependent Role="Customers">
      <PropertyRef Name="PrimaryActivity" />
    </Dependent>
  </ReferentialConstraint>
</Association>


<AssociationSet Name="FK_Customers_Activities" Association="Self.FK_Customers_Activities">
  <End Role="Activities" EntitySet="Activities" />
  <End Role="Customers" EntitySet="Customers" />
</AssociationSet>


Association's representation in Mappings is:


Nothing. However, there is one thing worth noticing, which is if you edit the entity/property name, changing it to another name different than its corresponding database name, you will see its node in this part, like:

<AssociationSetMapping Name="ActivityEquipment" TypeName="BreakAwayModel.ActivityEquipment" StoreEntitySet="ActivityEquipment">
<EndProperty Name="Activities">
  <ScalarProperty Name="ActivityID" ColumnName="ActivityID" />
</EndProperty>
<EndProperty Name="Equipment">
  <ScalarProperty Name="EquipmentID" ColumnName="EquipmentID" />
</EndProperty>
</AssociationSetMapping>
<AssociationSetMapping Name="EventActivities" TypeName="BreakAwayModel.EventActivities" StoreEntitySet="EventActivities">
<EndProperty Name="Activities">
  <ScalarProperty Name="ActivityID" ColumnName="ActivityID" />
</EndProperty>
<EndProperty Name="Events">
  <ScalarProperty Name="TripID" ColumnName="EventID" />
</EndProperty>
</AssociationSetMapping>


You see this because you have updated Equipment entity name and Event entity name.


Navigation and association are always linked to each other:



It's representation in ConceptualModels:

<EntityType Name="Activity">
  ...
  <NavigationProperty Name="Customers" Relationship="Self.FK_Customers_Activities" FromRole="Activities" ToRole="Customers" />
  ...
</EntityType>


<EntityType Name="Customer">
  ...
  <NavigationProperty Name="Activity" Relationship="Self.FK_Customers_Activities" FromRole="Customers" ToRole="Activities" />
  ...
</EntityType>


Now, let's follow the instruction at page 171:

Old property nameNew property name
Customer.PrimaryDestinationCustomer.PrimaryDestinationID


What really happened behind the scene?


In the ConceptualModels part:


before changed

<Schema Namespace="BreakAwayModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
  <EntityType Name="Customer">
    ..
    <Property Name="PrimaryDesintation" Type="Int32" />
    ..
  </EntityType>
  ..
  <Association Name="FK_Customers_Locations">
    ..
    <ReferentialConstraint>
      <Principal Role="Locations">
        <PropertyRef Name="DestinationID" />
      </Principal>
      <Dependent Role="Customers">
        <PropertyRef Name="PrimaryDesintation" />
      </Dependent>
    </ReferentialConstraint>
  </Association>

</Schema>

after changed:

<Schema Namespace="BreakAwayModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
  <EntityType Name="Customer">
    ..
    <Property Name="PrimaryDesintation" Type="Int32" />
    ..
  </EntityType>
  ..
  <Association Name="FK_Customers_Locations">
    ..
    <ReferentialConstraint>
      <Principal Role="Locations">
        <PropertyRef Name="DestinationID" />
      </Principal>
      <Dependent Role="Customers">
        <PropertyRef Name="PrimaryDesintationID" />
      </Dependent>
    </ReferentialConstraint>
  </Association>

</Schema>


In Mapping part:

<Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
..
  <EntityContainerMapping StorageEntityContainer="BreakAwayModelStoreContainer" CdmEntityContainer="BreakAwayEntities">
      <EntitySetMapping Name="Customers">
        <EntityTypeMapping TypeName="BreakAwayModel.Customer">
          <MappingFragment StoreEntitySet="Customers">
            ..
            <ScalarProperty Name="PrimaryDesintation" ColumnName="PrimaryDesintation" />
            ..
          </MappingFragment>
        </EntityTypeMapping>
      </EntitySetMapping>
  </EntityContainerMapping>
..


In Customer.cs:

before:

//------------------------------------------------------------------------------
// <auto-generated>
//     This code was generated from a template.
//
//     Manual changes to this file may cause unexpected behavior in your application.
//     Manual changes to this file will be overwritten if the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------

namespace BreakAwayModel
{
    using System;
    using System.Collections.Generic;
    
    public partial class Customer
    {
        ...
    
        ...
        public Nullable<int> PrimaryDesintation { get; set; }
        ...
    
        ...
    }
}


after:

//------------------------------------------------------------------------------
// <auto-generated>
//     This code was generated from a template.
//
//     Manual changes to this file may cause unexpected behavior in your application.
//     Manual changes to this file will be overwritten if the code is regenerated.
// </auto-generated>
//------------------------------------------------------------------------------

namespace BreakAwayModel
{
    using System;
    using System.Collections.Generic;
    
    public partial class Customer
    {
        ...
    
        ...
        public Nullable<int> PrimaryDesintationID { get; set; }
        ...
    
        ...
    }
}



Updating the navigation property


before:

<Schema Namespace="BreakAwayModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
  <EntityType Name="Customer">
    <Key>
      <PropertyRef Name="ContactID" />
    </Key>
    <Property Name="ContactID" Type="Int32" Nullable="false" />
    ..
    <NavigationProperty Name="Activity" Relationship="Self.FK_Customers_Activities" FromRole="Customers" ToRole="Activities" />
    <NavigationProperty Name="Activity1" Relationship="Self.FK_Customers_Activities1" FromRole="Customers" ToRole="Activities" />
    ..
  </EntityType>
  ..


after:

<Schema Namespace="BreakAwayModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
  <EntityType Name="Customer">
    <Key>
      <PropertyRef Name="ContactID" />
    </Key>
    <Property Name="ContactID" Type="Int32" Nullable="false" />
    ..
    <NavigationProperty Name="PrimaryActivity" Relationship="Self.FK_Customers_Activities" FromRole="Customers" ToRole="Activities" />
    <NavigationProperty Name="SecondaryActivity" Relationship="Self.FK_Customers_Activities1" FromRole="Customers" ToRole="Activities" />
    ..
  </EntityType>
  ..













zlxadhkust
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Programming Entity Framework, 2nd Edition
08-17
Get a thorough introduction to ADO.NET Entity Framework 4 - Microsoft's core framework for modeling and interacting with data in .NET applications. The second edition of this acclaimed guide provides a hands-on tour of the framework latest version in Visual Studio 2010 and .NET Framework 4. Not only will you learn how to use EF4 in a variety of applications, you'll also gain a deep understanding of its architecture and APIs. Written by Julia Lerman, the leading independent authority on the framework, Programming Entity Framework covers it all - from the Entity Data Model and Object Services to WCF Services, MVC Apps, and unit testing. This book highlights important changes for experienced developers familiar with the earlier version.
Programming Entity Framework: Building Data Centric
04-27
英文高清原版，本人资源全部免费，更多资源请查看本人的上传资源 =================================================== 作 者：Julia Lerman 页 数：914页 定 价:567.00 内 容 简 介：Get a thorough introduction to ADO.NET Entity Framework 4 --Microsoft's core framework for modeling and interacting with datain .NET applications. The second edition of this acclaimed guideprovides a hands-on tour of the framework latest version in Visual Studio 2010 and .NET Framework 4. Not only will you learn how touse EF4 in a variety of applications, you'll also gain a deepunderstanding of its architecture and APIs. Written by JuliaLerman, the leading independent authority on the framework,Programming Entity Framework covers it all -- from the Entity DataModel and Object Services to WCF Services, MVC Apps, and unittesting. This book highlights important changes for experienced developers familiar with the earlier version. * Understand the coreconcepts you need to make the best use of the EF4 in your applications * Learn to query your data, using either LINQ toEntities or Entity SQL * Create Windows Forms, WPF, ASP.NET WebForms, and ASP.NET MVC applications * Build and consume WCF Services, WCF Data Services, and WCF RIA Services * Use Object Services to work directly with your entity objects * Createpersistent ignorant entities, repositories, and write unit tests *Delve into model customization, relationship management, change tracking, data concurrency, and more * Get scores of reusable examples -- written in C# (with notes on Visual Basic syntax) --that you can implement right away 作 者 简 介：Julia Lerman is the leading independent authority on the Entity Framework and has been using and teaching the technology since itsinception two years ago. She is well known in the .NET community asa Microsoft MVP, ASPInsider and INETA Speaker. She is a prolific blogger, a frequent presenter at technical conferences around the world, including DevConnections and TechEd and she writes articlesfor many well-known technical publications. Julia lives in Vermontwhere she runs the Vermont.NET User Group, is a board member of theVermont Software Developers Alliance, and a member of the Champlain College Software Engineering Advisory Board. You can read her blogsat www.thedatafarm.com/blog.
Programming Entity Framework 2nd edition
09-22
Programming Entity Framework 详细的Ado.net Entity Framework资料~~
Programming Entity Framework 第二版 翻译索引
weixin_33962621的博客
10-15 70
一直断断续续地用着EF，但一直未系统地学习。下载了这本书，也一直没有好好地看完。从今天开始啃这本书，说是专门的翻译谈不上，以前也未做过类似的事情。但我还是会尝试着去做这件事。我希望能坚持下来，不管是否太迟。 本书的介绍，来自DouBanhttp://book.douban.com/subject/3627937/，需要英文电子版的可自行下载。 当前进度：第三章进行中。。。 ...
asp.net------ef实体类更新的方法
王雪亮
11-07 1896
采用此方法时，强烈建议，更新前，先将model层的代码拷贝出来，或是上传到版本控制工具上。 整体思路： 1.model层的代码备份 2.删除以前的edmx文件，新增新的edmx(只含有想添加的表) 3.拷贝出生成的文件(edmx对应的xml和实体类.cs) 4.删除刚生成的edmx，恢复成原始状态 5.以xml打开原始状态的edmx文件，将新生成的edmx相应节点放进原始edmx文件...
Programming Entity Framework 2nd Edition
10-26
This is definitely the book to have by your side if you are programming with the ADO.NET Entity Framework 1.0. The author touches on a ton of subjects that include: Data Binding with Windows Forms ...
Programming Entity Framework
TopMVP
04-17 620
版权声明：原创作品，允许转载，转载时请务必以超链接形式标明文章原始出版、作者信息和本声明。否则将追究法律责任。http://blog.csdn.net/topmvp - topmvpProgramming Entity Framework is a thorough introduction to Microsofts new core framework for modeling and in
17、Spring MVC 之 COC support
carl.zhao的专栏
11-06 1630
对于很多项目,坚持既定的约定,并设置合理的默认值是他们(项目)所需要的东西。并且Spring WEB MVC已经明确的支持约定优于配置。这意味着如果你建立一组命名约定等,你可以充分的减少大多数配置。其中必要的设置包含handler mappings,view resolvers, ModelAndView实例等等。对于快速原型这是一个被视为很好的,提供一定程度的(总是好)一致性代码库。你应该选择把它推行到生产中。
[Programming Entity Framework] 第1章 ADO.NET实体框架介绍（一）
weixin_34056162的博客
10-15 89
Programming Entity Framework 第二版 翻译索引 在微软2009年开发者大会上，微软非常著名的工程师说，"如果你是.NET开发人员，EF是我们的目标。我们在那儿，来吧，时机到了。"。 是的，时机到了。 在此之前，开发人员花费了太多时间担心他们后端的数据库、表及他们的关系、存储过程的名称及参数、视图还有他们返回数据的模式。对于.NET开发人员，微软新的...
电子书下载：Programming Entity Framework DbContext
weixin_30781775的博客
07-22 77
下载：http://www.ctdisk.com/file/7721407 转载于:https://www.cnblogs.com/MaxWoods/archive/2012/06/16/2551797.html
Note On <Programming Entity Framework 2nd Edition> -02: How to Use SqlExpress Profiler 2.0
Vincent's Tech Blog
12-08 1771
Chapter3: Querying Entity Data Models The example code of Entity SQL in this chapter at page 57 doesn't work in Entity Framework 6.0. And in EF5.0, you need to change it in this way: var queryStri
如何使用<Beginning ASP.NET 3.5 in C# and VB>书中的示例代码
Vincent's Tech Blog
05-15 1613
以第13章为例：LINQ 先创建一个website
SNOOP - WPF Inspector
Vincent's Tech Blog
04-17 1091
Official site: Download the installation file, unzip it: Install it: Run it, according to the doc, you had better run it as administrator to avoid Snoop not being able to fi
Note on <C# 3.0 UNLEASHED With the .NET Framework 3.5> - 01
Vincent's Tech Blog
05-11 937
Chapter 15: Managing Object Lifetime Multiple constructors: public class WebSite { string siteName; string url; string description; // Constructors public WebSite(): this("No Site", "no
Automatically Grab Images From a Website With C#
Vincent's Tech Blog
09-27 929
Requirement definition The application should be able to: Retrieve the HTML markup in text from a given URL, through HTTP request; Extract the URI of the image from the HTML markup;Save the i
<Pro WPF 4.5 in C#> - Note-01
Vincent's Tech Blog
04-16 910
Chapter 2: XAML Properties and Events in XAML Markup Extensions You may want to set a property value dynamically by binding it to a property in another control. Markup extensions ca
Notes On <Practical ASP.NET Web API> - 01
Vincent's Tech Blog
06-10 887
Chp-1: Building a Basic Web API
CompletableFuture<ResponseEntity<String>>这是一个什么类
最新发布
03-29
CompletableFuture<ResponseEntity<String>> 是一个Java的异步编程类，它表示一个异步操作的未来结果。它的泛型参数 ResponseEntity<String> 表示异步操作返回的结果类型为 ResponseEntity<String>，即HTTP响应实体...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值