none
Add an edmx file but the designer is not shown. RRS feed

  • Question

  • I followed the How to: Manually Define an Entity Data Model (Entity Framework).

    Finally I created an edmx file and added it to the project, but the designer is not shown. My whole code:

    <?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>
          <Schema Namespace="AdventureWorksModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
            <EntityContainer Name="AdventureWorksModelStoreContainer">
              <EntitySet Name="Address" EntityType="AdventureWorksModel.Store.Address"
                         store:Type="Tables" Schema="Person" />
              <EntitySet Name="Contact" EntityType="AdventureWorksModel.Store.Contact"
                         store:Type="Tables" Schema="Person" />
              <EntitySet Name="Product" EntityType="AdventureWorksModel.Store.Product"
                         store:Type="Tables" Schema="Production" />
              <EntitySet Name="SalesOrderDetail" EntityType="AdventureWorksModel.Store.SalesOrderDetail"
                         store:Type="Tables" Schema="Sales" />
              <EntitySet Name="SalesOrderHeader" EntityType="AdventureWorksModel.Store.SalesOrderHeader"
                         store:Type="Tables" Schema="Sales" />
              <AssociationSet Name="FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID"
                              Association="AdventureWorksModel.Store.FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID">
                <End Role="SalesOrderHeader" EntitySet="SalesOrderHeader" />
                <End Role="SalesOrderDetail" EntitySet="SalesOrderDetail" />
              </AssociationSet>
              <AssociationSet Name="FK_SalesOrderHeader_Address_BillToAddressID"
                              Association="AdventureWorksModel.Store.FK_SalesOrderHeader_Address_BillToAddressID">
                <End Role="Address" EntitySet="Address" />
                <End Role="SalesOrderHeader" EntitySet="SalesOrderHeader" />
              </AssociationSet>
              <AssociationSet Name="FK_SalesOrderHeader_Address_ShipToAddressID"
                              Association="AdventureWorksModel.Store.FK_SalesOrderHeader_Address_ShipToAddressID">
                <End Role="Address" EntitySet="Address" />
                <End Role="SalesOrderHeader" EntitySet="SalesOrderHeader" />
              </AssociationSet>
              <AssociationSet Name="FK_SalesOrderHeader_Contact_ContactID"
                              Association="AdventureWorksModel.Store.FK_SalesOrderHeader_Contact_ContactID">
                <End Role="Contact" EntitySet="Contact" />
                <End Role="SalesOrderHeader" EntitySet="SalesOrderHeader" />
              </AssociationSet>
            </EntityContainer>
            <EntityType Name="Address">
              <Key>
                <PropertyRef Name="AddressID" />
              </Key>
              <Property Name="AddressID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
              <Property Name="AddressLine1" Type="nvarchar" Nullable="false" MaxLength="60" />
              <Property Name="AddressLine2" Type="nvarchar" MaxLength="60" />
              <Property Name="City" Type="nvarchar" Nullable="false" MaxLength="30" />
              <Property Name="StateProvinceID" Type="int" Nullable="false" />
              <Property Name="PostalCode" Type="nvarchar" Nullable="false" MaxLength="15" />
              <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" />
              <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
            </EntityType>
            <EntityType Name="Contact">
              <Key>
                <PropertyRef Name="ContactID" />
              </Key>
              <Property Name="ContactID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
              <Property Name="NameStyle" Type="bit" Nullable="false" />
              <Property Name="Title" Type="nvarchar" MaxLength="8" />
              <Property Name="FirstName" Type="nvarchar" Nullable="false" MaxLength="50" />
              <Property Name="MiddleName" Type="nvarchar" MaxLength="50" />
              <Property Name="LastName" Type="nvarchar" Nullable="false" MaxLength="50" />
              <Property Name="Suffix" Type="nvarchar" MaxLength="10" />
              <Property Name="EmailAddress" Type="nvarchar" MaxLength="50" />
              <Property Name="EmailPromotion" Type="int" Nullable="false" />
              <Property Name="Phone" Type="nvarchar" MaxLength="25" />
              <Property Name="PasswordHash" Type="varchar" Nullable="false" MaxLength="128" />
              <Property Name="PasswordSalt" Type="varchar" Nullable="false" MaxLength="10" />
              <Property Name="AdditionalContactInfo" Type="xml" />
              <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" />
              <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
            </EntityType>
            <EntityType Name="Product">
              <Key>
                <PropertyRef Name="ProductID" />
              </Key>
              <Property Name="ProductID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
              <Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="50" />
              <Property Name="ProductNumber" Type="nvarchar" Nullable="false" MaxLength="25" />
              <Property Name="MakeFlag" Type="bit" Nullable="false" />
              <Property Name="FinishedGoodsFlag" Type="bit" Nullable="false" />
              <Property Name="Color" Type="nvarchar" MaxLength="15" />
              <Property Name="SafetyStockLevel" Type="smallint" Nullable="false" />
              <Property Name="ReorderPoint" Type="smallint" Nullable="false" />
              <Property Name="StandardCost" Type="money" Nullable="false" />
              <Property Name="ListPrice" Type="money" Nullable="false" />
              <Property Name="Size" Type="nvarchar" MaxLength="5" />
              <Property Name="SizeUnitMeasureCode" Type="nchar" MaxLength="3" />
              <Property Name="WeightUnitMeasureCode" Type="nchar" MaxLength="3" />
              <Property Name="Weight" Type="decimal" Precision="8" Scale="2" />
              <Property Name="DaysToManufacture" Type="int" Nullable="false" />
              <Property Name="ProductLine" Type="nchar" MaxLength="2" />
              <Property Name="Class" Type="nchar" MaxLength="2" />
              <Property Name="Style" Type="nchar" MaxLength="2" />
              <Property Name="ProductSubcategoryID" Type="int" />
              <Property Name="ProductModelID" Type="int" />
              <Property Name="SellStartDate" Type="datetime" Nullable="false" />
              <Property Name="SellEndDate" Type="datetime" />
              <Property Name="DiscontinuedDate" Type="datetime" />
              <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" />
              <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
            </EntityType>
            <EntityType Name="SalesOrderDetail">
              <Key>
                <PropertyRef Name="SalesOrderID" />
                <PropertyRef Name="SalesOrderDetailID" />
              </Key>
              <Property Name="SalesOrderID" Type="int" Nullable="false" />
              <Property Name="SalesOrderDetailID" Type="int" Nullable="false"
                        StoreGeneratedPattern="Identity" />
              <Property Name="CarrierTrackingNumber" Type="nvarchar" MaxLength="25" />
              <Property Name="OrderQty" Type="smallint" Nullable="false" />
              <Property Name="ProductID" Type="int" Nullable="false" />
              <Property Name="SpecialOfferID" Type="int" Nullable="false" />
              <Property Name="UnitPrice" Type="money" Nullable="false" />
              <Property Name="UnitPriceDiscount" Type="money" Nullable="false" />
              <Property Name="LineTotal" Type="numeric" Nullable="false" Precision="38" Scale="6"
                        StoreGeneratedPattern="Computed" />
              <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" />
              <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
            </EntityType>
            <EntityType Name="SalesOrderHeader">
              <Key>
                <PropertyRef Name="SalesOrderID" />
              </Key>
              <Property Name="SalesOrderID" Type="int" Nullable="false"
                        StoreGeneratedPattern="Identity" />
              <Property Name="RevisionNumber" Type="tinyint" Nullable="false" />
              <Property Name="OrderDate" Type="datetime" Nullable="false" />
              <Property Name="DueDate" Type="datetime" Nullable="false" />
              <Property Name="ShipDate" Type="datetime" />
              <Property Name="Status" Type="tinyint" Nullable="false" />
              <Property Name="OnlineOrderFlag" Type="bit" Nullable="false" />
              <Property Name="SalesOrderNumber" Type="nvarchar" Nullable="false" MaxLength="25"
                        StoreGeneratedPattern="Computed" />
              <Property Name="PurchaseOrderNumber" Type="nvarchar" MaxLength="25" />
              <Property Name="AccountNumber" Type="nvarchar" MaxLength="15" />
              <Property Name="CustomerID" Type="int" Nullable="false" />
              <Property Name="ContactID" Type="int" Nullable="false" />
              <Property Name="SalesPersonID" Type="int" />
              <Property Name="TerritoryID" Type="int" />
              <Property Name="BillToAddressID" Type="int" Nullable="false" />
              <Property Name="ShipToAddressID" Type="int" Nullable="false" />
              <Property Name="ShipMethodID" Type="int" Nullable="false" />
              <Property Name="CreditCardID" Type="int" />
              <Property Name="CreditCardApprovalCode" Type="varchar" MaxLength="15" />
              <Property Name="CurrencyRateID" Type="int" />
              <Property Name="SubTotal" Type="money" Nullable="false" />
              <Property Name="TaxAmt" Type="money" Nullable="false" />
              <Property Name="Freight" Type="money" Nullable="false" />
              <Property Name="TotalDue" Type="money" Nullable="false"
                        StoreGeneratedPattern="Computed" />
              <Property Name="Comment" Type="nvarchar" MaxLength="128" />
              <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" />
              <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
            </EntityType>
            <Association Name="FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID">
              <End Role="SalesOrderHeader" Type="AdventureWorksModel.Store.SalesOrderHeader"
                   Multiplicity="1">
                <OnDelete Action="Cascade" />
              </End>
              <End Role="SalesOrderDetail" Type="AdventureWorksModel.Store.SalesOrderDetail"
                   Multiplicity="*" />
              <ReferentialConstraint>
                <Principal Role="SalesOrderHeader">
                  <PropertyRef Name="SalesOrderID" />
                </Principal>
                <Dependent Role="SalesOrderDetail">
                  <PropertyRef Name="SalesOrderID" />
                </Dependent>
              </ReferentialConstraint>
            </Association>
            <Association Name="FK_SalesOrderHeader_Address_BillToAddressID">
              <End Role="Address" Type="AdventureWorksModel.Store.Address" Multiplicity="1" />
              <End Role="SalesOrderHeader" Type="AdventureWorksModel.Store.SalesOrderHeader"
                   Multiplicity="*" />
              <ReferentialConstraint>
                <Principal Role="Address">
                  <PropertyRef Name="AddressID" />
                </Principal>
                <Dependent Role="SalesOrderHeader">
                  <PropertyRef Name="BillToAddressID" />
                </Dependent>
              </ReferentialConstraint>
            </Association>
            <Association Name="FK_SalesOrderHeader_Address_ShipToAddressID">
              <End Role="Address" Type="AdventureWorksModel.Store.Address" Multiplicity="1" />
              <End Role="SalesOrderHeader" Type="AdventureWorksModel.Store.SalesOrderHeader"
                   Multiplicity="*" />
              <ReferentialConstraint>
                <Principal Role="Address">
                  <PropertyRef Name="AddressID" />
                </Principal>
                <Dependent Role="SalesOrderHeader">
                  <PropertyRef Name="ShipToAddressID" />
                </Dependent>
              </ReferentialConstraint>
            </Association>
            <Association Name="FK_SalesOrderHeader_Contact_ContactID">
              <End Role="Contact" Type="AdventureWorksModel.Store.Contact" Multiplicity="1" />
              <End Role="SalesOrderHeader" Type="AdventureWorksModel.Store.SalesOrderHeader"
                   Multiplicity="*" />
              <ReferentialConstraint>
                <Principal Role="Contact">
                  <PropertyRef Name="ContactID" />
                </Principal>
                <Dependent Role="SalesOrderHeader">
                  <PropertyRef Name="ContactID" />
                </Dependent>
              </ReferentialConstraint>
            </Association>
          </Schema>
        </edmx:StorageModels>
        <!-- CSDL content -->
        <edmx:ConceptualModels>
          <Schema Namespace="AdventureWorksModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
            <EntityContainer Name="AdventureWorksEntities">
              <EntitySet Name="Addresses" EntityType="AdventureWorksModel.Address" />
              <EntitySet Name="Contacts" EntityType="AdventureWorksModel.Contact" />
              <EntitySet Name="Products" EntityType="AdventureWorksModel.Product" />
              <EntitySet Name="SalesOrderDetails" EntityType="AdventureWorksModel.SalesOrderDetail" />
              <EntitySet Name="SalesOrderHeaders" EntityType="AdventureWorksModel.SalesOrderHeader" />
              <AssociationSet Name="FK_SalesOrderHeader_Address_BillToAddressID"
                              Association="AdventureWorksModel.FK_SalesOrderHeader_Address_BillToAddressID">
                <End Role="Address" EntitySet="Addresses" />
                <End Role="SalesOrderHeader" EntitySet="SalesOrderHeaders" />
              </AssociationSet>
              <AssociationSet Name="FK_SalesOrderHeader_Address_ShipToAddressID"
                              Association="AdventureWorksModel.FK_SalesOrderHeader_Address_ShipToAddressID">
                <End Role="Address" EntitySet="Addresses" />
                <End Role="SalesOrderHeader" EntitySet="SalesOrderHeaders" />
              </AssociationSet>
              <AssociationSet Name="FK_SalesOrderHeader_Contact_ContactID"
                              Association="AdventureWorksModel.FK_SalesOrderHeader_Contact_ContactID">
                <End Role="Contact" EntitySet="Contacts" />
                <End Role="SalesOrderHeader" EntitySet="SalesOrderHeaders" />
              </AssociationSet>
              <AssociationSet Name="FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID"
                              Association="AdventureWorksModel.FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID">
                <End Role="SalesOrderHeader" EntitySet="SalesOrderHeaders" />
                <End Role="SalesOrderDetail" EntitySet="SalesOrderDetails" />
              </AssociationSet>
            </EntityContainer>
            <EntityType Name="Address">
              <Key>
                <PropertyRef Name="AddressID" />
              </Key>
              <Property Name="AddressID" Type="Int32" Nullable="false"
                        annotation:StoreGeneratedPattern="Identity" />
              <Property Name="AddressLine1" Type="String" Nullable="false" MaxLength="60"
                        Unicode="true" FixedLength="false" />
              <Property Name="AddressLine2" Type="String" MaxLength="60"
                        Unicode="true" FixedLength="false" />
              <Property Name="City" Type="String" Nullable="false" MaxLength="30"
                        Unicode="true" FixedLength="false" />
              <Property Name="StateProvinceID" Type="Int32" Nullable="false" />
              <Property Name="PostalCode" Type="String" Nullable="false" MaxLength="15"
                        Unicode="true" FixedLength="false" />
              <Property Name="rowguid" Type="Guid" Nullable="false" />
              <Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
              <NavigationProperty Name="SalesOrderHeaders"
                                  Relationship="AdventureWorksModel.FK_SalesOrderHeader_Address_BillToAddressID"
                                  FromRole="Address" ToRole="SalesOrderHeader" />
              <NavigationProperty Name="SalesOrderHeaders1"
                                  Relationship="AdventureWorksModel.FK_SalesOrderHeader_Address_ShipToAddressID"
                                  FromRole="Address" ToRole="SalesOrderHeader" />
            </EntityType>
            <EntityType Name="Contact">
              <Key>
                <PropertyRef Name="ContactID" />
              </Key>
              <Property Name="ContactID" Type="Int32" Nullable="false"
                        annotation:StoreGeneratedPattern="Identity" />
              <Property Name="NameStyle" Type="Boolean" Nullable="false" />
              <Property Name="Title" Type="String" MaxLength="8"
                        Unicode="true" FixedLength="false" />
              <Property Name="FirstName" Type="String" Nullable="false" MaxLength="50"
                        Unicode="true" FixedLength="false" />
              <Property Name="MiddleName" Type="String" MaxLength="50"
                        Unicode="true" FixedLength="false" />
              <Property Name="LastName" Type="String" Nullable="false" MaxLength="50"
                        Unicode="true" FixedLength="false" />
              <Property Name="Suffix" Type="String" MaxLength="10"
                        Unicode="true" FixedLength="false" />
              <Property Name="EmailAddress" Type="String" MaxLength="50"
                        Unicode="true" FixedLength="false" />
              <Property Name="EmailPromotion" Type="Int32" Nullable="false" />
              <Property Name="Phone" Type="String" MaxLength="25"
                        Unicode="true" FixedLength="false" />
              <Property Name="PasswordHash" Type="String" Nullable="false" MaxLength="128"
                        Unicode="false" FixedLength="false" />
              <Property Name="PasswordSalt" Type="String" Nullable="false" MaxLength="10"
                        Unicode="false" FixedLength="false" />
              <Property Name="AdditionalContactInfo" Type="String" MaxLength="Max"
                        Unicode="true" FixedLength="false" />
              <Property Name="rowguid" Type="Guid" Nullable="false" />
              <Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
              <NavigationProperty Name="SalesOrderHeaders"
                                  Relationship="AdventureWorksModel.FK_SalesOrderHeader_Contact_ContactID"
                                  FromRole="Contact" ToRole="SalesOrderHeader" />
            </EntityType>
            <EntityType Name="Product">
              <Key>
                <PropertyRef Name="ProductID" />
              </Key>
              <Property Name="ProductID" Type="Int32" Nullable="false"
                        annotation:StoreGeneratedPattern="Identity" />
              <Property Name="Name" Type="String" Nullable="false" MaxLength="50"
                        Unicode="true" FixedLength="false" />
              <Property Name="ProductNumber" Type="String" Nullable="false" MaxLength="25"
                        Unicode="true" FixedLength="false" />
              <Property Name="MakeFlag" Type="Boolean" Nullable="false" />
              <Property Name="FinishedGoodsFlag" Type="Boolean" Nullable="false" />
              <Property Name="Color" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
              <Property Name="SafetyStockLevel" Type="Int16" Nullable="false" />
              <Property Name="ReorderPoint" Type="Int16" Nullable="false" />
              <Property Name="StandardCost" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
              <Property Name="ListPrice" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
              <Property Name="Size" Type="String" MaxLength="5" Unicode="true" FixedLength="false" />
              <Property Name="SizeUnitMeasureCode" Type="String" MaxLength="3"
                        Unicode="true" FixedLength="true" />
              <Property Name="WeightUnitMeasureCode" Type="String" MaxLength="3"
                        Unicode="true" FixedLength="true" />
              <Property Name="Weight" Type="Decimal" Precision="8" Scale="2" />
              <Property Name="DaysToManufacture" Type="Int32" Nullable="false" />
              <Property Name="ProductLine" Type="String" MaxLength="2" Unicode="true" FixedLength="true" />
              <Property Name="Class" Type="String" MaxLength="2" Unicode="true" FixedLength="true" />
              <Property Name="Style" Type="String" MaxLength="2" Unicode="true" FixedLength="true" />
              <Property Name="ProductSubcategoryID" Type="Int32" />
              <Property Name="ProductModelID" Type="Int32" />
              <Property Name="SellStartDate" Type="DateTime" Nullable="false" />
              <Property Name="SellEndDate" Type="DateTime" />
              <Property Name="DiscontinuedDate" Type="DateTime" />
              <Property Name="rowguid" Type="Guid" Nullable="false" />
              <Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
            </EntityType>
            <EntityType Name="SalesOrderDetail">
              <Key>
                <PropertyRef Name="SalesOrderID" />
                <PropertyRef Name="SalesOrderDetailID" />
              </Key>
              <Property Name="SalesOrderID" Type="Int32" Nullable="false" />
              <Property Name="SalesOrderDetailID" Type="Int32" Nullable="false"
                        annotation:StoreGeneratedPattern="Identity" />
              <Property Name="CarrierTrackingNumber" Type="String" MaxLength="25"
                        Unicode="true" FixedLength="false" />
              <Property Name="OrderQty" Type="Int16" Nullable="false" />
              <Property Name="ProductID" Type="Int32" Nullable="false" />
              <Property Name="SpecialOfferID" Type="Int32" Nullable="false" />
              <Property Name="UnitPrice" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
              <Property Name="UnitPriceDiscount" Type="Decimal" Nullable="false"
                        Precision="19" Scale="4" />
              <Property Name="LineTotal" Type="Decimal" Nullable="false" Precision="38" Scale="6"
                        annotation:StoreGeneratedPattern="Computed" />
              <Property Name="rowguid" Type="Guid" Nullable="false" />
              <Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
              <NavigationProperty Name="SalesOrderHeader"
                                  Relationship="AdventureWorksModel.FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID"
                                  FromRole="SalesOrderDetail" ToRole="SalesOrderHeader" />
            </EntityType>
            <EntityType Name="SalesOrderHeader">
              <Key>
                <PropertyRef Name="SalesOrderID" />
              </Key>
              <Property Name="SalesOrderID" Type="Int32" Nullable="false"
                        annotation:StoreGeneratedPattern="Identity" />
              <Property Name="RevisionNumber" Type="Byte" Nullable="false" />
              <Property Name="OrderDate" Type="DateTime" Nullable="false" />
              <Property Name="DueDate" Type="DateTime" Nullable="false" />
              <Property Name="ShipDate" Type="DateTime" />
              <Property Name="Status" Type="Byte" Nullable="false" />
              <Property Name="OnlineOrderFlag" Type="Boolean" Nullable="false" />
              <Property Name="SalesOrderNumber" Type="String" Nullable="false" MaxLength="25"
                        Unicode="true" FixedLength="false"
                        annotation:StoreGeneratedPattern="Computed" />
              <Property Name="PurchaseOrderNumber" Type="String" MaxLength="25"
                        Unicode="true" FixedLength="false" />
              <Property Name="AccountNumber" Type="String" MaxLength="15"
                        Unicode="true" FixedLength="false" />
              <Property Name="CustomerID" Type="Int32" Nullable="false" />
              <Property Name="ContactID" Type="Int32" Nullable="false" />
              <Property Name="SalesPersonID" Type="Int32" />
              <Property Name="TerritoryID" Type="Int32" />
              <Property Name="BillToAddressID" Type="Int32" Nullable="false" />
              <Property Name="ShipToAddressID" Type="Int32" Nullable="false" />
              <Property Name="ShipMethodID" Type="Int32" Nullable="false" />
              <Property Name="CreditCardID" Type="Int32" />
              <Property Name="CreditCardApprovalCode" Type="String" MaxLength="15"
                        Unicode="false" FixedLength="false" />
              <Property Name="CurrencyRateID" Type="Int32" />
              <Property Name="SubTotal" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
              <Property Name="TaxAmt" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
              <Property Name="Freight" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
              <Property Name="TotalDue" Type="Decimal" Nullable="false" Precision="19" Scale="4"
                        annotation:StoreGeneratedPattern="Computed" />
              <Property Name="Comment" Type="String" MaxLength="128" Unicode="true" FixedLength="false" />
              <Property Name="rowguid" Type="Guid" Nullable="false" />
              <Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
              <NavigationProperty Name="Address"
                                  Relationship="AdventureWorksModel.FK_SalesOrderHeader_Address_BillToAddressID"
                                  FromRole="SalesOrderHeader" ToRole="Address" />
              <NavigationProperty Name="Address1"
                                  Relationship="AdventureWorksModel.FK_SalesOrderHeader_Address_ShipToAddressID"
                                  FromRole="SalesOrderHeader" ToRole="Address" />
              <NavigationProperty Name="Contact"
                                  Relationship="AdventureWorksModel.FK_SalesOrderHeader_Contact_ContactID"
                                  FromRole="SalesOrderHeader" ToRole="Contact" />
              <NavigationProperty Name="SalesOrderDetails"
                                  Relationship="AdventureWorksModel.FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID"
                                  FromRole="SalesOrderHeader" ToRole="SalesOrderDetail" />
            </EntityType>
            <Association Name="FK_SalesOrderHeader_Address_BillToAddressID">
              <End Role="Address" Type="AdventureWorksModel.Address" Multiplicity="1" />
              <End Role="SalesOrderHeader" Type="AdventureWorksModel.SalesOrderHeader" Multiplicity="*" />
              <ReferentialConstraint>
                <Principal Role="Address">
                  <PropertyRef Name="AddressID" />
                </Principal>
                <Dependent Role="SalesOrderHeader">
                  <PropertyRef Name="BillToAddressID" />
                </Dependent>
              </ReferentialConstraint>
            </Association>
            <Association Name="FK_SalesOrderHeader_Address_ShipToAddressID">
              <End Role="Address" Type="AdventureWorksModel.Address" Multiplicity="1" />
              <End Role="SalesOrderHeader" Type="AdventureWorksModel.SalesOrderHeader" Multiplicity="*" />
              <ReferentialConstraint>
                <Principal Role="Address">
                  <PropertyRef Name="AddressID" />
                </Principal>
                <Dependent Role="SalesOrderHeader">
                  <PropertyRef Name="ShipToAddressID" />
                </Dependent>
              </ReferentialConstraint>
            </Association>
            <Association Name="FK_SalesOrderHeader_Contact_ContactID">
              <End Role="Contact" Type="AdventureWorksModel.Contact" Multiplicity="1" />
              <End Role="SalesOrderHeader" Type="AdventureWorksModel.SalesOrderHeader" Multiplicity="*" />
              <ReferentialConstraint>
                <Principal Role="Contact">
                  <PropertyRef Name="ContactID" />
                </Principal>
                <Dependent Role="SalesOrderHeader">
                  <PropertyRef Name="ContactID" />
                </Dependent>
              </ReferentialConstraint>
            </Association>
            <Association Name="FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID">
              <End Role="SalesOrderHeader" Type="AdventureWorksModel.SalesOrderHeader" Multiplicity="1">
                <OnDelete Action="Cascade" />
              </End>
              <End Role="SalesOrderDetail" Type="AdventureWorksModel.SalesOrderDetail" Multiplicity="*" />
              <ReferentialConstraint>
                <Principal Role="SalesOrderHeader">
                  <PropertyRef Name="SalesOrderID" />
                </Principal>
                <Dependent Role="SalesOrderDetail">
                  <PropertyRef Name="SalesOrderID" />
                </Dependent>
              </ReferentialConstraint>
            </Association>
          </Schema>
        </edmx:ConceptualModels>
        <!-- C-S mapping content -->
        <edmx:Mappings>
          <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
            <EntityContainerMapping StorageEntityContainer="AdventureWorksModelStoreContainer"
                                    CdmEntityContainer="AdventureWorksEntities">
              <EntitySetMapping Name="Addresses">
                <EntityTypeMapping TypeName="AdventureWorksModel.Address">
                  <MappingFragment StoreEntitySet="Address">
                    <ScalarProperty Name="AddressID" ColumnName="AddressID" />
                    <ScalarProperty Name="AddressLine1" ColumnName="AddressLine1" />
                    <ScalarProperty Name="AddressLine2" ColumnName="AddressLine2" />
                    <ScalarProperty Name="City" ColumnName="City" />
                    <ScalarProperty Name="StateProvinceID" ColumnName="StateProvinceID" />
                    <ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
                    <ScalarProperty Name="rowguid" ColumnName="rowguid" />
                    <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                  </MappingFragment>
                </EntityTypeMapping>
              </EntitySetMapping>
              <EntitySetMapping Name="Contacts">
                <EntityTypeMapping TypeName="AdventureWorksModel.Contact">
                  <MappingFragment StoreEntitySet="Contact">
                    <ScalarProperty Name="ContactID" ColumnName="ContactID" />
                    <ScalarProperty Name="NameStyle" ColumnName="NameStyle" />
                    <ScalarProperty Name="Title" ColumnName="Title" />
                    <ScalarProperty Name="FirstName" ColumnName="FirstName" />
                    <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
                    <ScalarProperty Name="LastName" ColumnName="LastName" />
                    <ScalarProperty Name="Suffix" ColumnName="Suffix" />
                    <ScalarProperty Name="EmailAddress" ColumnName="EmailAddress" />
                    <ScalarProperty Name="EmailPromotion" ColumnName="EmailPromotion" />
                    <ScalarProperty Name="Phone" ColumnName="Phone" />
                    <ScalarProperty Name="PasswordHash" ColumnName="PasswordHash" />
                    <ScalarProperty Name="PasswordSalt" ColumnName="PasswordSalt" />
                    <ScalarProperty Name="AdditionalContactInfo" ColumnName="AdditionalContactInfo" />
                    <ScalarProperty Name="rowguid" ColumnName="rowguid" />
                    <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                  </MappingFragment>
                </EntityTypeMapping>
              </EntitySetMapping>
              <EntitySetMapping Name="Products">
                <EntityTypeMapping TypeName="AdventureWorksModel.Product">
                  <MappingFragment StoreEntitySet="Product">
                    <ScalarProperty Name="ProductID" ColumnName="ProductID" />
                    <ScalarProperty Name="Name" ColumnName="Name" />
                    <ScalarProperty Name="ProductNumber" ColumnName="ProductNumber" />
                    <ScalarProperty Name="MakeFlag" ColumnName="MakeFlag" />
                    <ScalarProperty Name="FinishedGoodsFlag" ColumnName="FinishedGoodsFlag" />
                    <ScalarProperty Name="Color" ColumnName="Color" />
                    <ScalarProperty Name="SafetyStockLevel" ColumnName="SafetyStockLevel" />
                    <ScalarProperty Name="ReorderPoint" ColumnName="ReorderPoint" />
                    <ScalarProperty Name="StandardCost" ColumnName="StandardCost" />
                    <ScalarProperty Name="ListPrice" ColumnName="ListPrice" />
                    <ScalarProperty Name="Size" ColumnName="Size" />
                    <ScalarProperty Name="SizeUnitMeasureCode" ColumnName="SizeUnitMeasureCode" />
                    <ScalarProperty Name="WeightUnitMeasureCode" ColumnName="WeightUnitMeasureCode" />
                    <ScalarProperty Name="Weight" ColumnName="Weight" />
                    <ScalarProperty Name="DaysToManufacture" ColumnName="DaysToManufacture" />
                    <ScalarProperty Name="ProductLine" ColumnName="ProductLine" />
                    <ScalarProperty Name="Class" ColumnName="Class" />
                    <ScalarProperty Name="Style" ColumnName="Style" />
                    <ScalarProperty Name="ProductSubcategoryID" ColumnName="ProductSubcategoryID" />
                    <ScalarProperty Name="ProductModelID" ColumnName="ProductModelID" />
                    <ScalarProperty Name="SellStartDate" ColumnName="SellStartDate" />
                    <ScalarProperty Name="SellEndDate" ColumnName="SellEndDate" />
                    <ScalarProperty Name="DiscontinuedDate" ColumnName="DiscontinuedDate" />
                    <ScalarProperty Name="rowguid" ColumnName="rowguid" />
                    <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                  </MappingFragment>
                </EntityTypeMapping>
              </EntitySetMapping>
              <EntitySetMapping Name="SalesOrderDetails">
                <EntityTypeMapping TypeName="AdventureWorksModel.SalesOrderDetail">
                  <MappingFragment StoreEntitySet="SalesOrderDetail">
                    <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
                    <ScalarProperty Name="SalesOrderDetailID" ColumnName="SalesOrderDetailID" />
                    <ScalarProperty Name="CarrierTrackingNumber" ColumnName="CarrierTrackingNumber" />
                    <ScalarProperty Name="OrderQty" ColumnName="OrderQty" />
                    <ScalarProperty Name="ProductID" ColumnName="ProductID" />
                    <ScalarProperty Name="SpecialOfferID" ColumnName="SpecialOfferID" />
                    <ScalarProperty Name="UnitPrice" ColumnName="UnitPrice" />
                    <ScalarProperty Name="UnitPriceDiscount" ColumnName="UnitPriceDiscount" />
                    <ScalarProperty Name="LineTotal" ColumnName="LineTotal" />
                    <ScalarProperty Name="rowguid" ColumnName="rowguid" />
                    <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                  </MappingFragment>
                </EntityTypeMapping>
              </EntitySetMapping>
              <EntitySetMapping Name="SalesOrderHeaders">
                <EntityTypeMapping TypeName="AdventureWorksModel.SalesOrderHeader">
                  <MappingFragment StoreEntitySet="SalesOrderHeader">
                    <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
                    <ScalarProperty Name="RevisionNumber" ColumnName="RevisionNumber" />
                    <ScalarProperty Name="OrderDate" ColumnName="OrderDate" />
                    <ScalarProperty Name="DueDate" ColumnName="DueDate" />
                    <ScalarProperty Name="ShipDate" ColumnName="ShipDate" />
                    <ScalarProperty Name="Status" ColumnName="Status" />
                    <ScalarProperty Name="OnlineOrderFlag" ColumnName="OnlineOrderFlag" />
                    <ScalarProperty Name="SalesOrderNumber" ColumnName="SalesOrderNumber" />
                    <ScalarProperty Name="PurchaseOrderNumber" ColumnName="PurchaseOrderNumber" />
                    <ScalarProperty Name="AccountNumber" ColumnName="AccountNumber" />
                    <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
                    <ScalarProperty Name="ContactID" ColumnName="ContactID" />
                    <ScalarProperty Name="SalesPersonID" ColumnName="SalesPersonID" />
                    <ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
                    <ScalarProperty Name="BillToAddressID" ColumnName="BillToAddressID" />
                    <ScalarProperty Name="ShipToAddressID" ColumnName="ShipToAddressID" />
                    <ScalarProperty Name="ShipMethodID" ColumnName="ShipMethodID" />
                    <ScalarProperty Name="CreditCardID" ColumnName="CreditCardID" />
                    <ScalarProperty Name="CreditCardApprovalCode" ColumnName="CreditCardApprovalCode" />
                    <ScalarProperty Name="CurrencyRateID" ColumnName="CurrencyRateID" />
                    <ScalarProperty Name="SubTotal" ColumnName="SubTotal" />
                    <ScalarProperty Name="TaxAmt" ColumnName="TaxAmt" />
                    <ScalarProperty Name="Freight" ColumnName="Freight" />
                    <ScalarProperty Name="TotalDue" ColumnName="TotalDue" />
                    <ScalarProperty Name="Comment" ColumnName="Comment" />
                    <ScalarProperty Name="rowguid" ColumnName="rowguid" />
                    <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                  </MappingFragment>
                </EntityTypeMapping>
              </EntitySetMapping>
            </EntityContainerMapping>
          </Mapping>
        </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>
    Thanks for help.

    Monday, March 30, 2015 5:27 PM

All replies

  • Hi ardmore,

    Try right-clicking the file, selecting Open with..., then choose ADO.NET Entity Data Model Designer.

    The Entity Designer is integrated with Visual Studio components. If it still doesn't work,  you need to reinstall the VS to repair these components.

    VS download: https://www.visualstudio.com/en-us/downloads/download-visual-studio-vs.aspx

    If you have any other concern regarding this issue, please feel free to let me know.

    Best regards,
    Youjun Tang


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, March 31, 2015 3:21 AM
  • I am using VS 2013 Professional Edition. So I don't think that it is the VS issue. And I got an message:

    Message	1	The designer could not be shown for this file because none of the classes within it can be designed.		0	0	
    

    Tuesday, March 31, 2015 12:52 PM
  • Hello ardmore,

    >>Finally I created an edmx file and added it to the project, but the designer is not shown. My whole code:

    The UI is controlled  by the diagram, you need to add a description for an entity:

    <?xml version="1.0" encoding="utf-8"?>
    
    <edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
    
     <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
    
      <edmx:Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
    
        <!-- Diagram content (shape and connector positions) -->
    
        <edmx:Diagrams>
    
          <Diagram DiagramId="8416e6d1dbdd4d99b68b7d08f19dcbab" Name="Diagram1">
    
            <EntityTypeShape EntityType="WinFormDBModel.Order" Width="1.5" PointX="0.75" PointY="0.75" IsExpanded="true" />
    
          </Diagram>
    
        </edmx:Diagrams>
    
      </edmx:Designer>
    
    </edmx:Edmx>
    

    If this does not work, please let me know.

    Regards.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Monday, April 6, 2015 10:08 AM
    Moderator
  • No, I need an edmx file which combines three files together and show. Your code doesn't have it. I want the entire code.
    Monday, April 6, 2015 12:24 PM
  • Hello,

    >>No, I need an edmx file which combines three files together and show. Your code doesn't have it. I want the entire code.

    Because the diagram is a separate file in my side. I reviewed your provided edmx file and notice that you already contains the Diagrams section. And from your current provided code, it contains nothing. Please add below code to the Diagrams section to see if there are entities shown in the designer.

    <Diagrams>
    
          <Diagram DiagramId="e331c46a11f44668a1de4dbd2eea53da" Name="Diagram1">
    
            <EntityTypeShape EntityType="AdventureWorksModel.Address" Width="1.5" PointX="0.75" PointY="3.25" IsExpanded="true" />
    
            <EntityTypeShape EntityType="AdventureWorksModel.Contact" Width="1.5" PointX="0.75" PointY="8.625" IsExpanded="true" />
    
            <EntityTypeShape EntityType="AdventureWorksModel.Product" Width="1.5" PointX="7.75" PointY="0.75" IsExpanded="true" />
    
            <EntityTypeShape EntityType="AdventureWorksModel.SalesOrderDetail" Width="1.5" PointX="5.25" PointY="3" IsExpanded="true" />
    
            <EntityTypeShape EntityType="AdventureWorksModel.SalesOrderHeader" Width="1.5" PointX="3" PointY="1.125" IsExpanded="true" />
    
            <AssociationConnector Association="AdventureWorksModel.FK_SalesOrderHeader_Address_BillToAddressID" ManuallyRouted="false" />
    
            <AssociationConnector Association="AdventureWorksModel.FK_SalesOrderHeader_Address_ShipToAddressID" ManuallyRouted="false" />
    
            <AssociationConnector Association="AdventureWorksModel.FK_SalesOrderHeader_Contact_ContactID" ManuallyRouted="false" />
    
            <AssociationConnector Association="AdventureWorksModel.FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID" ManuallyRouted="false" />
    
          </Diagram>
    
        </Diagrams>
    

    With your provided xml code and after adding these additional code, these entities are shown:

    If I do not understand this issue correctly, please feel free to let me know.

    Regards,

    Fred.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Tuesday, April 7, 2015 5:36 AM
    Moderator
  • My entire code:

    <?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>
          <Schema Namespace="AdventureWorksModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
            <EntityContainer Name="AdventureWorksModelStoreContainer">
              <EntitySet Name="Address" EntityType="AdventureWorksModel.Store.Address"
                         store:Type="Tables" Schema="Person" />
              <EntitySet Name="Contact" EntityType="AdventureWorksModel.Store.Contact"
                         store:Type="Tables" Schema="Person" />
              <EntitySet Name="Product" EntityType="AdventureWorksModel.Store.Product"
                         store:Type="Tables" Schema="Production" />
              <EntitySet Name="SalesOrderDetail" EntityType="AdventureWorksModel.Store.SalesOrderDetail"
                         store:Type="Tables" Schema="Sales" />
              <EntitySet Name="SalesOrderHeader" EntityType="AdventureWorksModel.Store.SalesOrderHeader"
                         store:Type="Tables" Schema="Sales" />
              <AssociationSet Name="FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID"
                              Association="AdventureWorksModel.Store.FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID">
                <End Role="SalesOrderHeader" EntitySet="SalesOrderHeader" />
                <End Role="SalesOrderDetail" EntitySet="SalesOrderDetail" />
              </AssociationSet>
              <AssociationSet Name="FK_SalesOrderHeader_Address_BillToAddressID"
                              Association="AdventureWorksModel.Store.FK_SalesOrderHeader_Address_BillToAddressID">
                <End Role="Address" EntitySet="Address" />
                <End Role="SalesOrderHeader" EntitySet="SalesOrderHeader" />
              </AssociationSet>
              <AssociationSet Name="FK_SalesOrderHeader_Address_ShipToAddressID"
                              Association="AdventureWorksModel.Store.FK_SalesOrderHeader_Address_ShipToAddressID">
                <End Role="Address" EntitySet="Address" />
                <End Role="SalesOrderHeader" EntitySet="SalesOrderHeader" />
              </AssociationSet>
              <AssociationSet Name="FK_SalesOrderHeader_Contact_ContactID"
                              Association="AdventureWorksModel.Store.FK_SalesOrderHeader_Contact_ContactID">
                <End Role="Contact" EntitySet="Contact" />
                <End Role="SalesOrderHeader" EntitySet="SalesOrderHeader" />
              </AssociationSet>
            </EntityContainer>
            <EntityType Name="Address">
              <Key>
                <PropertyRef Name="AddressID" />
              </Key>
              <Property Name="AddressID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
              <Property Name="AddressLine1" Type="nvarchar" Nullable="false" MaxLength="60" />
              <Property Name="AddressLine2" Type="nvarchar" MaxLength="60" />
              <Property Name="City" Type="nvarchar" Nullable="false" MaxLength="30" />
              <Property Name="StateProvinceID" Type="int" Nullable="false" />
              <Property Name="PostalCode" Type="nvarchar" Nullable="false" MaxLength="15" />
              <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" />
              <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
            </EntityType>
            <EntityType Name="Contact">
              <Key>
                <PropertyRef Name="ContactID" />
              </Key>
              <Property Name="ContactID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
              <Property Name="NameStyle" Type="bit" Nullable="false" />
              <Property Name="Title" Type="nvarchar" MaxLength="8" />
              <Property Name="FirstName" Type="nvarchar" Nullable="false" MaxLength="50" />
              <Property Name="MiddleName" Type="nvarchar" MaxLength="50" />
              <Property Name="LastName" Type="nvarchar" Nullable="false" MaxLength="50" />
              <Property Name="Suffix" Type="nvarchar" MaxLength="10" />
              <Property Name="EmailAddress" Type="nvarchar" MaxLength="50" />
              <Property Name="EmailPromotion" Type="int" Nullable="false" />
              <Property Name="Phone" Type="nvarchar" MaxLength="25" />
              <Property Name="PasswordHash" Type="varchar" Nullable="false" MaxLength="128" />
              <Property Name="PasswordSalt" Type="varchar" Nullable="false" MaxLength="10" />
              <Property Name="AdditionalContactInfo" Type="xml" />
              <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" />
              <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
            </EntityType>
            <EntityType Name="Product">
              <Key>
                <PropertyRef Name="ProductID" />
              </Key>
              <Property Name="ProductID" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
              <Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="50" />
              <Property Name="ProductNumber" Type="nvarchar" Nullable="false" MaxLength="25" />
              <Property Name="MakeFlag" Type="bit" Nullable="false" />
              <Property Name="FinishedGoodsFlag" Type="bit" Nullable="false" />
              <Property Name="Color" Type="nvarchar" MaxLength="15" />
              <Property Name="SafetyStockLevel" Type="smallint" Nullable="false" />
              <Property Name="ReorderPoint" Type="smallint" Nullable="false" />
              <Property Name="StandardCost" Type="money" Nullable="false" />
              <Property Name="ListPrice" Type="money" Nullable="false" />
              <Property Name="Size" Type="nvarchar" MaxLength="5" />
              <Property Name="SizeUnitMeasureCode" Type="nchar" MaxLength="3" />
              <Property Name="WeightUnitMeasureCode" Type="nchar" MaxLength="3" />
              <Property Name="Weight" Type="decimal" Precision="8" Scale="2" />
              <Property Name="DaysToManufacture" Type="int" Nullable="false" />
              <Property Name="ProductLine" Type="nchar" MaxLength="2" />
              <Property Name="Class" Type="nchar" MaxLength="2" />
              <Property Name="Style" Type="nchar" MaxLength="2" />
              <Property Name="ProductSubcategoryID" Type="int" />
              <Property Name="ProductModelID" Type="int" />
              <Property Name="SellStartDate" Type="datetime" Nullable="false" />
              <Property Name="SellEndDate" Type="datetime" />
              <Property Name="DiscontinuedDate" Type="datetime" />
              <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" />
              <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
            </EntityType>
            <EntityType Name="SalesOrderDetail">
              <Key>
                <PropertyRef Name="SalesOrderID" />
                <PropertyRef Name="SalesOrderDetailID" />
              </Key>
              <Property Name="SalesOrderID" Type="int" Nullable="false" />
              <Property Name="SalesOrderDetailID" Type="int" Nullable="false"
                        StoreGeneratedPattern="Identity" />
              <Property Name="CarrierTrackingNumber" Type="nvarchar" MaxLength="25" />
              <Property Name="OrderQty" Type="smallint" Nullable="false" />
              <Property Name="ProductID" Type="int" Nullable="false" />
              <Property Name="SpecialOfferID" Type="int" Nullable="false" />
              <Property Name="UnitPrice" Type="money" Nullable="false" />
              <Property Name="UnitPriceDiscount" Type="money" Nullable="false" />
              <Property Name="LineTotal" Type="numeric" Nullable="false" Precision="38" Scale="6"
                        StoreGeneratedPattern="Computed" />
              <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" />
              <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
            </EntityType>
            <EntityType Name="SalesOrderHeader">
              <Key>
                <PropertyRef Name="SalesOrderID" />
              </Key>
              <Property Name="SalesOrderID" Type="int" Nullable="false"
                        StoreGeneratedPattern="Identity" />
              <Property Name="RevisionNumber" Type="tinyint" Nullable="false" />
              <Property Name="OrderDate" Type="datetime" Nullable="false" />
              <Property Name="DueDate" Type="datetime" Nullable="false" />
              <Property Name="ShipDate" Type="datetime" />
              <Property Name="Status" Type="tinyint" Nullable="false" />
              <Property Name="OnlineOrderFlag" Type="bit" Nullable="false" />
              <Property Name="SalesOrderNumber" Type="nvarchar" Nullable="false" MaxLength="25"
                        StoreGeneratedPattern="Computed" />
              <Property Name="PurchaseOrderNumber" Type="nvarchar" MaxLength="25" />
              <Property Name="AccountNumber" Type="nvarchar" MaxLength="15" />
              <Property Name="CustomerID" Type="int" Nullable="false" />
              <Property Name="ContactID" Type="int" Nullable="false" />
              <Property Name="SalesPersonID" Type="int" />
              <Property Name="TerritoryID" Type="int" />
              <Property Name="BillToAddressID" Type="int" Nullable="false" />
              <Property Name="ShipToAddressID" Type="int" Nullable="false" />
              <Property Name="ShipMethodID" Type="int" Nullable="false" />
              <Property Name="CreditCardID" Type="int" />
              <Property Name="CreditCardApprovalCode" Type="varchar" MaxLength="15" />
              <Property Name="CurrencyRateID" Type="int" />
              <Property Name="SubTotal" Type="money" Nullable="false" />
              <Property Name="TaxAmt" Type="money" Nullable="false" />
              <Property Name="Freight" Type="money" Nullable="false" />
              <Property Name="TotalDue" Type="money" Nullable="false"
                        StoreGeneratedPattern="Computed" />
              <Property Name="Comment" Type="nvarchar" MaxLength="128" />
              <Property Name="rowguid" Type="uniqueidentifier" Nullable="false" />
              <Property Name="ModifiedDate" Type="datetime" Nullable="false" />
            </EntityType>
            <Association Name="FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID">
              <End Role="SalesOrderHeader" Type="AdventureWorksModel.Store.SalesOrderHeader"
                   Multiplicity="1">
                <OnDelete Action="Cascade" />
              </End>
              <End Role="SalesOrderDetail" Type="AdventureWorksModel.Store.SalesOrderDetail"
                   Multiplicity="*" />
              <ReferentialConstraint>
                <Principal Role="SalesOrderHeader">
                  <PropertyRef Name="SalesOrderID" />
                </Principal>
                <Dependent Role="SalesOrderDetail">
                  <PropertyRef Name="SalesOrderID" />
                </Dependent>
              </ReferentialConstraint>
            </Association>
            <Association Name="FK_SalesOrderHeader_Address_BillToAddressID">
              <End Role="Address" Type="AdventureWorksModel.Store.Address" Multiplicity="1" />
              <End Role="SalesOrderHeader" Type="AdventureWorksModel.Store.SalesOrderHeader"
                   Multiplicity="*" />
              <ReferentialConstraint>
                <Principal Role="Address">
                  <PropertyRef Name="AddressID" />
                </Principal>
                <Dependent Role="SalesOrderHeader">
                  <PropertyRef Name="BillToAddressID" />
                </Dependent>
              </ReferentialConstraint>
            </Association>
            <Association Name="FK_SalesOrderHeader_Address_ShipToAddressID">
              <End Role="Address" Type="AdventureWorksModel.Store.Address" Multiplicity="1" />
              <End Role="SalesOrderHeader" Type="AdventureWorksModel.Store.SalesOrderHeader"
                   Multiplicity="*" />
              <ReferentialConstraint>
                <Principal Role="Address">
                  <PropertyRef Name="AddressID" />
                </Principal>
                <Dependent Role="SalesOrderHeader">
                  <PropertyRef Name="ShipToAddressID" />
                </Dependent>
              </ReferentialConstraint>
            </Association>
            <Association Name="FK_SalesOrderHeader_Contact_ContactID">
              <End Role="Contact" Type="AdventureWorksModel.Store.Contact" Multiplicity="1" />
              <End Role="SalesOrderHeader" Type="AdventureWorksModel.Store.SalesOrderHeader"
                   Multiplicity="*" />
              <ReferentialConstraint>
                <Principal Role="Contact">
                  <PropertyRef Name="ContactID" />
                </Principal>
                <Dependent Role="SalesOrderHeader">
                  <PropertyRef Name="ContactID" />
                </Dependent>
              </ReferentialConstraint>
            </Association>
          </Schema>
        </edmx:StorageModels>
        <!-- CSDL content -->
        <edmx:ConceptualModels>
          <Schema Namespace="AdventureWorksModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
            <EntityContainer Name="AdventureWorksEntities">
              <EntitySet Name="Addresses" EntityType="AdventureWorksModel.Address" />
              <EntitySet Name="Contacts" EntityType="AdventureWorksModel.Contact" />
              <EntitySet Name="Products" EntityType="AdventureWorksModel.Product" />
              <EntitySet Name="SalesOrderDetails" EntityType="AdventureWorksModel.SalesOrderDetail" />
              <EntitySet Name="SalesOrderHeaders" EntityType="AdventureWorksModel.SalesOrderHeader" />
              <AssociationSet Name="FK_SalesOrderHeader_Address_BillToAddressID"
                              Association="AdventureWorksModel.FK_SalesOrderHeader_Address_BillToAddressID">
                <End Role="Address" EntitySet="Addresses" />
                <End Role="SalesOrderHeader" EntitySet="SalesOrderHeaders" />
              </AssociationSet>
              <AssociationSet Name="FK_SalesOrderHeader_Address_ShipToAddressID"
                              Association="AdventureWorksModel.FK_SalesOrderHeader_Address_ShipToAddressID">
                <End Role="Address" EntitySet="Addresses" />
                <End Role="SalesOrderHeader" EntitySet="SalesOrderHeaders" />
              </AssociationSet>
              <AssociationSet Name="FK_SalesOrderHeader_Contact_ContactID"
                              Association="AdventureWorksModel.FK_SalesOrderHeader_Contact_ContactID">
                <End Role="Contact" EntitySet="Contacts" />
                <End Role="SalesOrderHeader" EntitySet="SalesOrderHeaders" />
              </AssociationSet>
              <AssociationSet Name="FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID"
                              Association="AdventureWorksModel.FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID">
                <End Role="SalesOrderHeader" EntitySet="SalesOrderHeaders" />
                <End Role="SalesOrderDetail" EntitySet="SalesOrderDetails" />
              </AssociationSet>
            </EntityContainer>
            <EntityType Name="Address">
              <Key>
                <PropertyRef Name="AddressID" />
              </Key>
              <Property Name="AddressID" Type="Int32" Nullable="false"
                        annotation:StoreGeneratedPattern="Identity" />
              <Property Name="AddressLine1" Type="String" Nullable="false" MaxLength="60"
                        Unicode="true" FixedLength="false" />
              <Property Name="AddressLine2" Type="String" MaxLength="60"
                        Unicode="true" FixedLength="false" />
              <Property Name="City" Type="String" Nullable="false" MaxLength="30"
                        Unicode="true" FixedLength="false" />
              <Property Name="StateProvinceID" Type="Int32" Nullable="false" />
              <Property Name="PostalCode" Type="String" Nullable="false" MaxLength="15"
                        Unicode="true" FixedLength="false" />
              <Property Name="rowguid" Type="Guid" Nullable="false" />
              <Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
              <NavigationProperty Name="SalesOrderHeaders"
                                  Relationship="AdventureWorksModel.FK_SalesOrderHeader_Address_BillToAddressID"
                                  FromRole="Address" ToRole="SalesOrderHeader" />
              <NavigationProperty Name="SalesOrderHeaders1"
                                  Relationship="AdventureWorksModel.FK_SalesOrderHeader_Address_ShipToAddressID"
                                  FromRole="Address" ToRole="SalesOrderHeader" />
            </EntityType>
            <EntityType Name="Contact">
              <Key>
                <PropertyRef Name="ContactID" />
              </Key>
              <Property Name="ContactID" Type="Int32" Nullable="false"
                        annotation:StoreGeneratedPattern="Identity" />
              <Property Name="NameStyle" Type="Boolean" Nullable="false" />
              <Property Name="Title" Type="String" MaxLength="8"
                        Unicode="true" FixedLength="false" />
              <Property Name="FirstName" Type="String" Nullable="false" MaxLength="50"
                        Unicode="true" FixedLength="false" />
              <Property Name="MiddleName" Type="String" MaxLength="50"
                        Unicode="true" FixedLength="false" />
              <Property Name="LastName" Type="String" Nullable="false" MaxLength="50"
                        Unicode="true" FixedLength="false" />
              <Property Name="Suffix" Type="String" MaxLength="10"
                        Unicode="true" FixedLength="false" />
              <Property Name="EmailAddress" Type="String" MaxLength="50"
                        Unicode="true" FixedLength="false" />
              <Property Name="EmailPromotion" Type="Int32" Nullable="false" />
              <Property Name="Phone" Type="String" MaxLength="25"
                        Unicode="true" FixedLength="false" />
              <Property Name="PasswordHash" Type="String" Nullable="false" MaxLength="128"
                        Unicode="false" FixedLength="false" />
              <Property Name="PasswordSalt" Type="String" Nullable="false" MaxLength="10"
                        Unicode="false" FixedLength="false" />
              <Property Name="AdditionalContactInfo" Type="String" MaxLength="Max"
                        Unicode="true" FixedLength="false" />
              <Property Name="rowguid" Type="Guid" Nullable="false" />
              <Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
              <NavigationProperty Name="SalesOrderHeaders"
                                  Relationship="AdventureWorksModel.FK_SalesOrderHeader_Contact_ContactID"
                                  FromRole="Contact" ToRole="SalesOrderHeader" />
            </EntityType>
            <EntityType Name="Product">
              <Key>
                <PropertyRef Name="ProductID" />
              </Key>
              <Property Name="ProductID" Type="Int32" Nullable="false"
                        annotation:StoreGeneratedPattern="Identity" />
              <Property Name="Name" Type="String" Nullable="false" MaxLength="50"
                        Unicode="true" FixedLength="false" />
              <Property Name="ProductNumber" Type="String" Nullable="false" MaxLength="25"
                        Unicode="true" FixedLength="false" />
              <Property Name="MakeFlag" Type="Boolean" Nullable="false" />
              <Property Name="FinishedGoodsFlag" Type="Boolean" Nullable="false" />
              <Property Name="Color" Type="String" MaxLength="15" Unicode="true" FixedLength="false" />
              <Property Name="SafetyStockLevel" Type="Int16" Nullable="false" />
              <Property Name="ReorderPoint" Type="Int16" Nullable="false" />
              <Property Name="StandardCost" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
              <Property Name="ListPrice" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
              <Property Name="Size" Type="String" MaxLength="5" Unicode="true" FixedLength="false" />
              <Property Name="SizeUnitMeasureCode" Type="String" MaxLength="3"
                        Unicode="true" FixedLength="true" />
              <Property Name="WeightUnitMeasureCode" Type="String" MaxLength="3"
                        Unicode="true" FixedLength="true" />
              <Property Name="Weight" Type="Decimal" Precision="8" Scale="2" />
              <Property Name="DaysToManufacture" Type="Int32" Nullable="false" />
              <Property Name="ProductLine" Type="String" MaxLength="2" Unicode="true" FixedLength="true" />
              <Property Name="Class" Type="String" MaxLength="2" Unicode="true" FixedLength="true" />
              <Property Name="Style" Type="String" MaxLength="2" Unicode="true" FixedLength="true" />
              <Property Name="ProductSubcategoryID" Type="Int32" />
              <Property Name="ProductModelID" Type="Int32" />
              <Property Name="SellStartDate" Type="DateTime" Nullable="false" />
              <Property Name="SellEndDate" Type="DateTime" />
              <Property Name="DiscontinuedDate" Type="DateTime" />
              <Property Name="rowguid" Type="Guid" Nullable="false" />
              <Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
            </EntityType>
            <EntityType Name="SalesOrderDetail">
              <Key>
                <PropertyRef Name="SalesOrderID" />
                <PropertyRef Name="SalesOrderDetailID" />
              </Key>
              <Property Name="SalesOrderID" Type="Int32" Nullable="false" />
              <Property Name="SalesOrderDetailID" Type="Int32" Nullable="false"
                        annotation:StoreGeneratedPattern="Identity" />
              <Property Name="CarrierTrackingNumber" Type="String" MaxLength="25"
                        Unicode="true" FixedLength="false" />
              <Property Name="OrderQty" Type="Int16" Nullable="false" />
              <Property Name="ProductID" Type="Int32" Nullable="false" />
              <Property Name="SpecialOfferID" Type="Int32" Nullable="false" />
              <Property Name="UnitPrice" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
              <Property Name="UnitPriceDiscount" Type="Decimal" Nullable="false"
                        Precision="19" Scale="4" />
              <Property Name="LineTotal" Type="Decimal" Nullable="false" Precision="38" Scale="6"
                        annotation:StoreGeneratedPattern="Computed" />
              <Property Name="rowguid" Type="Guid" Nullable="false" />
              <Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
              <NavigationProperty Name="SalesOrderHeader"
                                  Relationship="AdventureWorksModel.FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID"
                                  FromRole="SalesOrderDetail" ToRole="SalesOrderHeader" />
            </EntityType>
            <EntityType Name="SalesOrderHeader">
              <Key>
                <PropertyRef Name="SalesOrderID" />
              </Key>
              <Property Name="SalesOrderID" Type="Int32" Nullable="false"
                        annotation:StoreGeneratedPattern="Identity" />
              <Property Name="RevisionNumber" Type="Byte" Nullable="false" />
              <Property Name="OrderDate" Type="DateTime" Nullable="false" />
              <Property Name="DueDate" Type="DateTime" Nullable="false" />
              <Property Name="ShipDate" Type="DateTime" />
              <Property Name="Status" Type="Byte" Nullable="false" />
              <Property Name="OnlineOrderFlag" Type="Boolean" Nullable="false" />
              <Property Name="SalesOrderNumber" Type="String" Nullable="false" MaxLength="25"
                        Unicode="true" FixedLength="false"
                        annotation:StoreGeneratedPattern="Computed" />
              <Property Name="PurchaseOrderNumber" Type="String" MaxLength="25"
                        Unicode="true" FixedLength="false" />
              <Property Name="AccountNumber" Type="String" MaxLength="15"
                        Unicode="true" FixedLength="false" />
              <Property Name="CustomerID" Type="Int32" Nullable="false" />
              <Property Name="ContactID" Type="Int32" Nullable="false" />
              <Property Name="SalesPersonID" Type="Int32" />
              <Property Name="TerritoryID" Type="Int32" />
              <Property Name="BillToAddressID" Type="Int32" Nullable="false" />
              <Property Name="ShipToAddressID" Type="Int32" Nullable="false" />
              <Property Name="ShipMethodID" Type="Int32" Nullable="false" />
              <Property Name="CreditCardID" Type="Int32" />
              <Property Name="CreditCardApprovalCode" Type="String" MaxLength="15"
                        Unicode="false" FixedLength="false" />
              <Property Name="CurrencyRateID" Type="Int32" />
              <Property Name="SubTotal" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
              <Property Name="TaxAmt" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
              <Property Name="Freight" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
              <Property Name="TotalDue" Type="Decimal" Nullable="false" Precision="19" Scale="4"
                        annotation:StoreGeneratedPattern="Computed" />
              <Property Name="Comment" Type="String" MaxLength="128" Unicode="true" FixedLength="false" />
              <Property Name="rowguid" Type="Guid" Nullable="false" />
              <Property Name="ModifiedDate" Type="DateTime" Nullable="false" />
              <NavigationProperty Name="Address"
                                  Relationship="AdventureWorksModel.FK_SalesOrderHeader_Address_BillToAddressID"
                                  FromRole="SalesOrderHeader" ToRole="Address" />
              <NavigationProperty Name="Address1"
                                  Relationship="AdventureWorksModel.FK_SalesOrderHeader_Address_ShipToAddressID"
                                  FromRole="SalesOrderHeader" ToRole="Address" />
              <NavigationProperty Name="Contact"
                                  Relationship="AdventureWorksModel.FK_SalesOrderHeader_Contact_ContactID"
                                  FromRole="SalesOrderHeader" ToRole="Contact" />
              <NavigationProperty Name="SalesOrderDetails"
                                  Relationship="AdventureWorksModel.FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID"
                                  FromRole="SalesOrderHeader" ToRole="SalesOrderDetail" />
            </EntityType>
            <Association Name="FK_SalesOrderHeader_Address_BillToAddressID">
              <End Role="Address" Type="AdventureWorksModel.Address" Multiplicity="1" />
              <End Role="SalesOrderHeader" Type="AdventureWorksModel.SalesOrderHeader" Multiplicity="*" />
              <ReferentialConstraint>
                <Principal Role="Address">
                  <PropertyRef Name="AddressID" />
                </Principal>
                <Dependent Role="SalesOrderHeader">
                  <PropertyRef Name="BillToAddressID" />
                </Dependent>
              </ReferentialConstraint>
            </Association>
            <Association Name="FK_SalesOrderHeader_Address_ShipToAddressID">
              <End Role="Address" Type="AdventureWorksModel.Address" Multiplicity="1" />
              <End Role="SalesOrderHeader" Type="AdventureWorksModel.SalesOrderHeader" Multiplicity="*" />
              <ReferentialConstraint>
                <Principal Role="Address">
                  <PropertyRef Name="AddressID" />
                </Principal>
                <Dependent Role="SalesOrderHeader">
                  <PropertyRef Name="ShipToAddressID" />
                </Dependent>
              </ReferentialConstraint>
            </Association>
            <Association Name="FK_SalesOrderHeader_Contact_ContactID">
              <End Role="Contact" Type="AdventureWorksModel.Contact" Multiplicity="1" />
              <End Role="SalesOrderHeader" Type="AdventureWorksModel.SalesOrderHeader" Multiplicity="*" />
              <ReferentialConstraint>
                <Principal Role="Contact">
                  <PropertyRef Name="ContactID" />
                </Principal>
                <Dependent Role="SalesOrderHeader">
                  <PropertyRef Name="ContactID" />
                </Dependent>
              </ReferentialConstraint>
            </Association>
            <Association Name="FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID">
              <End Role="SalesOrderHeader" Type="AdventureWorksModel.SalesOrderHeader" Multiplicity="1">
                <OnDelete Action="Cascade" />
              </End>
              <End Role="SalesOrderDetail" Type="AdventureWorksModel.SalesOrderDetail" Multiplicity="*" />
              <ReferentialConstraint>
                <Principal Role="SalesOrderHeader">
                  <PropertyRef Name="SalesOrderID" />
                </Principal>
                <Dependent Role="SalesOrderDetail">
                  <PropertyRef Name="SalesOrderID" />
                </Dependent>
              </ReferentialConstraint>
            </Association>
          </Schema>
        </edmx:ConceptualModels>
        <!-- C-S mapping content -->
        <edmx:Mappings>
          <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
            <EntityContainerMapping StorageEntityContainer="AdventureWorksModelStoreContainer"
                                    CdmEntityContainer="AdventureWorksEntities">
              <EntitySetMapping Name="Addresses">
                <EntityTypeMapping TypeName="AdventureWorksModel.Address">
                  <MappingFragment StoreEntitySet="Address">
                    <ScalarProperty Name="AddressID" ColumnName="AddressID" />
                    <ScalarProperty Name="AddressLine1" ColumnName="AddressLine1" />
                    <ScalarProperty Name="AddressLine2" ColumnName="AddressLine2" />
                    <ScalarProperty Name="City" ColumnName="City" />
                    <ScalarProperty Name="StateProvinceID" ColumnName="StateProvinceID" />
                    <ScalarProperty Name="PostalCode" ColumnName="PostalCode" />
                    <ScalarProperty Name="rowguid" ColumnName="rowguid" />
                    <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                  </MappingFragment>
                </EntityTypeMapping>
              </EntitySetMapping>
              <EntitySetMapping Name="Contacts">
                <EntityTypeMapping TypeName="AdventureWorksModel.Contact">
                  <MappingFragment StoreEntitySet="Contact">
                    <ScalarProperty Name="ContactID" ColumnName="ContactID" />
                    <ScalarProperty Name="NameStyle" ColumnName="NameStyle" />
                    <ScalarProperty Name="Title" ColumnName="Title" />
                    <ScalarProperty Name="FirstName" ColumnName="FirstName" />
                    <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
                    <ScalarProperty Name="LastName" ColumnName="LastName" />
                    <ScalarProperty Name="Suffix" ColumnName="Suffix" />
                    <ScalarProperty Name="EmailAddress" ColumnName="EmailAddress" />
                    <ScalarProperty Name="EmailPromotion" ColumnName="EmailPromotion" />
                    <ScalarProperty Name="Phone" ColumnName="Phone" />
                    <ScalarProperty Name="PasswordHash" ColumnName="PasswordHash" />
                    <ScalarProperty Name="PasswordSalt" ColumnName="PasswordSalt" />
                    <ScalarProperty Name="AdditionalContactInfo" ColumnName="AdditionalContactInfo" />
                    <ScalarProperty Name="rowguid" ColumnName="rowguid" />
                    <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                  </MappingFragment>
                </EntityTypeMapping>
              </EntitySetMapping>
              <EntitySetMapping Name="Products">
                <EntityTypeMapping TypeName="AdventureWorksModel.Product">
                  <MappingFragment StoreEntitySet="Product">
                    <ScalarProperty Name="ProductID" ColumnName="ProductID" />
                    <ScalarProperty Name="Name" ColumnName="Name" />
                    <ScalarProperty Name="ProductNumber" ColumnName="ProductNumber" />
                    <ScalarProperty Name="MakeFlag" ColumnName="MakeFlag" />
                    <ScalarProperty Name="FinishedGoodsFlag" ColumnName="FinishedGoodsFlag" />
                    <ScalarProperty Name="Color" ColumnName="Color" />
                    <ScalarProperty Name="SafetyStockLevel" ColumnName="SafetyStockLevel" />
                    <ScalarProperty Name="ReorderPoint" ColumnName="ReorderPoint" />
                    <ScalarProperty Name="StandardCost" ColumnName="StandardCost" />
                    <ScalarProperty Name="ListPrice" ColumnName="ListPrice" />
                    <ScalarProperty Name="Size" ColumnName="Size" />
                    <ScalarProperty Name="SizeUnitMeasureCode" ColumnName="SizeUnitMeasureCode" />
                    <ScalarProperty Name="WeightUnitMeasureCode" ColumnName="WeightUnitMeasureCode" />
                    <ScalarProperty Name="Weight" ColumnName="Weight" />
                    <ScalarProperty Name="DaysToManufacture" ColumnName="DaysToManufacture" />
                    <ScalarProperty Name="ProductLine" ColumnName="ProductLine" />
                    <ScalarProperty Name="Class" ColumnName="Class" />
                    <ScalarProperty Name="Style" ColumnName="Style" />
                    <ScalarProperty Name="ProductSubcategoryID" ColumnName="ProductSubcategoryID" />
                    <ScalarProperty Name="ProductModelID" ColumnName="ProductModelID" />
                    <ScalarProperty Name="SellStartDate" ColumnName="SellStartDate" />
                    <ScalarProperty Name="SellEndDate" ColumnName="SellEndDate" />
                    <ScalarProperty Name="DiscontinuedDate" ColumnName="DiscontinuedDate" />
                    <ScalarProperty Name="rowguid" ColumnName="rowguid" />
                    <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                  </MappingFragment>
                </EntityTypeMapping>
              </EntitySetMapping>
              <EntitySetMapping Name="SalesOrderDetails">
                <EntityTypeMapping TypeName="AdventureWorksModel.SalesOrderDetail">
                  <MappingFragment StoreEntitySet="SalesOrderDetail">
                    <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
                    <ScalarProperty Name="SalesOrderDetailID" ColumnName="SalesOrderDetailID" />
                    <ScalarProperty Name="CarrierTrackingNumber" ColumnName="CarrierTrackingNumber" />
                    <ScalarProperty Name="OrderQty" ColumnName="OrderQty" />
                    <ScalarProperty Name="ProductID" ColumnName="ProductID" />
                    <ScalarProperty Name="SpecialOfferID" ColumnName="SpecialOfferID" />
                    <ScalarProperty Name="UnitPrice" ColumnName="UnitPrice" />
                    <ScalarProperty Name="UnitPriceDiscount" ColumnName="UnitPriceDiscount" />
                    <ScalarProperty Name="LineTotal" ColumnName="LineTotal" />
                    <ScalarProperty Name="rowguid" ColumnName="rowguid" />
                    <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                  </MappingFragment>
                </EntityTypeMapping>
              </EntitySetMapping>
              <EntitySetMapping Name="SalesOrderHeaders">
                <EntityTypeMapping TypeName="AdventureWorksModel.SalesOrderHeader">
                  <MappingFragment StoreEntitySet="SalesOrderHeader">
                    <ScalarProperty Name="SalesOrderID" ColumnName="SalesOrderID" />
                    <ScalarProperty Name="RevisionNumber" ColumnName="RevisionNumber" />
                    <ScalarProperty Name="OrderDate" ColumnName="OrderDate" />
                    <ScalarProperty Name="DueDate" ColumnName="DueDate" />
                    <ScalarProperty Name="ShipDate" ColumnName="ShipDate" />
                    <ScalarProperty Name="Status" ColumnName="Status" />
                    <ScalarProperty Name="OnlineOrderFlag" ColumnName="OnlineOrderFlag" />
                    <ScalarProperty Name="SalesOrderNumber" ColumnName="SalesOrderNumber" />
                    <ScalarProperty Name="PurchaseOrderNumber" ColumnName="PurchaseOrderNumber" />
                    <ScalarProperty Name="AccountNumber" ColumnName="AccountNumber" />
                    <ScalarProperty Name="CustomerID" ColumnName="CustomerID" />
                    <ScalarProperty Name="ContactID" ColumnName="ContactID" />
                    <ScalarProperty Name="SalesPersonID" ColumnName="SalesPersonID" />
                    <ScalarProperty Name="TerritoryID" ColumnName="TerritoryID" />
                    <ScalarProperty Name="BillToAddressID" ColumnName="BillToAddressID" />
                    <ScalarProperty Name="ShipToAddressID" ColumnName="ShipToAddressID" />
                    <ScalarProperty Name="ShipMethodID" ColumnName="ShipMethodID" />
                    <ScalarProperty Name="CreditCardID" ColumnName="CreditCardID" />
                    <ScalarProperty Name="CreditCardApprovalCode" ColumnName="CreditCardApprovalCode" />
                    <ScalarProperty Name="CurrencyRateID" ColumnName="CurrencyRateID" />
                    <ScalarProperty Name="SubTotal" ColumnName="SubTotal" />
                    <ScalarProperty Name="TaxAmt" ColumnName="TaxAmt" />
                    <ScalarProperty Name="Freight" ColumnName="Freight" />
                    <ScalarProperty Name="TotalDue" ColumnName="TotalDue" />
                    <ScalarProperty Name="Comment" ColumnName="Comment" />
                    <ScalarProperty Name="rowguid" ColumnName="rowguid" />
                    <ScalarProperty Name="ModifiedDate" ColumnName="ModifiedDate" />
                  </MappingFragment>
                </EntityTypeMapping>
              </EntitySetMapping>
            </EntityContainerMapping>
          </Mapping>
        </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>
    
          <Diagram DiagramId="e331c46a11f44668a1de4dbd2eea53da" Name="Diagram1">
    
            <EntityTypeShape EntityType="AdventureWorksModel.Address" Width="1.5" PointX="0.75" PointY="3.25" IsExpanded="true" />
    
            <EntityTypeShape EntityType="AdventureWorksModel.Contact" Width="1.5" PointX="0.75" PointY="8.625" IsExpanded="true" />
    
            <EntityTypeShape EntityType="AdventureWorksModel.Product" Width="1.5" PointX="7.75" PointY="0.75" IsExpanded="true" />
    
            <EntityTypeShape EntityType="AdventureWorksModel.SalesOrderDetail" Width="1.5" PointX="5.25" PointY="3" IsExpanded="true" />
    
            <EntityTypeShape EntityType="AdventureWorksModel.SalesOrderHeader" Width="1.5" PointX="3" PointY="1.125" IsExpanded="true" />
    
            <AssociationConnector Association="AdventureWorksModel.FK_SalesOrderHeader_Address_BillToAddressID" ManuallyRouted="false" />
    
            <AssociationConnector Association="AdventureWorksModel.FK_SalesOrderHeader_Address_ShipToAddressID" ManuallyRouted="false" />
    
            <AssociationConnector Association="AdventureWorksModel.FK_SalesOrderHeader_Contact_ContactID" ManuallyRouted="false" />
    
            <AssociationConnector Association="AdventureWorksModel.FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID" ManuallyRouted="false" />
    
          </Diagram>
    
        </Diagrams>
      </Designer>
    </edmx:Edmx>

    It is still not showing. The architectural of my code likes.

    architectural

    Tuesday, April 7, 2015 12:52 PM
  • Hello ardmore,

    I am wondering if I misunderstood your clarification. Do you mean the “the designer” is the XXXModel.Designer.cs file or the entities are not shown in the designer windows? If former, this file is under the edmx file, please expand the edmx, with your provided file, the designer file is shown as:

    Regards.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Wednesday, April 8, 2015 9:30 AM
    Moderator
  • Please see the attached file on my oOneDrive.

    The zip file is "AdventureWorks.zip". Thank you.

    Wednesday, April 8, 2015 12:41 PM
  • Hello,

    I downloaded your provided project and reproduced the issue you described, yes, there are not entities shown on the designer windows. What I found is that the UI information is stored in the edmx file, while as far as I know, the default value is stored in the separate diagram file, so I copied below code:

    <Diagram DiagramId="e331c46a11f44668a1de4dbd2eea53da" Name="Diagram1">
    
    
            <EntityTypeShape EntityType="AdventureWorksModel.Address" Width="1.5" PointX="0.75" PointY="3.25" IsExpanded="true" />
    
    
            <EntityTypeShape EntityType="AdventureWorksModel.Contact" Width="1.5" PointX="0.75" PointY="8.625" IsExpanded="true" />
    
    
            <EntityTypeShape EntityType="AdventureWorksModel.Product" Width="1.5" PointX="7.75" PointY="0.75" IsExpanded="true" />
    
    
            <EntityTypeShape EntityType="AdventureWorksModel.SalesOrderDetail" Width="1.5" PointX="5.25" PointY="3" IsExpanded="true" />
    
    
            <EntityTypeShape EntityType="AdventureWorksModel.SalesOrderHeader" Width="1.5" PointX="3" PointY="1.125" IsExpanded="true" />
    
    
            <AssociationConnector Association="AdventureWorksModel.FK_SalesOrderHeader_Address_BillToAddressID" ManuallyRouted="false" />
    
    
            <AssociationConnector Association="AdventureWorksModel.FK_SalesOrderHeader_Address_ShipToAddressID" ManuallyRouted="false" />
    
    
            <AssociationConnector Association="AdventureWorksModel.FK_SalesOrderHeader_Contact_ContactID" ManuallyRouted="false" />
    
    
            <AssociationConnector Association="AdventureWorksModel.FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID" ManuallyRouted="false" />
    
    
          </Diagram>
    

    To the AdventureWorks.edmx.diagram file and then opne the design windows, it shows these entities. I am wondering when using the wizard tool to generate the edmx file, it does some additionally however, since it is not open source, it is hard to know.

    Regards.


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Proposed as answer by UttamPrasad Thursday, April 9, 2015 12:44 PM
    • Unproposed as answer by UttamPrasad Thursday, April 9, 2015 12:44 PM
    Thursday, April 9, 2015 8:30 AM
    Moderator