Skip to content

Sample Service Metadata

<edmx:Edmx
    xmlns:edmx="http://schemas.microsoft.com/ado/2007/06/edmx" Version="1.0">
    <edmx:DataServices
        xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" m:DataServiceVersion="1.0">
        <Schema
            xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices"
            xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"
            xmlns="http://schemas.microsoft.com/ado/2008/09/edm" Namespace="SAPSQLOData">
            <EntityType Name="OneToOneEnd1">
                <Key>
                    <PropertyRef Name="pk"/>
                </Key>
                <Property Name="pk" Type="Edm.Int32" Nullable="false"/>
                <Property Name="val" Type="Edm.Int32" Nullable="true"/>
                <Property Name="end2pk" Type="Edm.Int32" Nullable="false"/>
                <NavigationProperty Name="OneToOneEnd2" Relationship="SAPSQLOData.ONE_TO_ONE" FromRole="OneToOneEnd1_Principal" ToRole="OneToOneEnd2_Dependent"/>
            </EntityType>
            <EntityType Name="OneToOneEnd2">
                <Key>
                    <PropertyRef Name="pk"/>
                </Key>
                <Property Name="pk" Type="Edm.Int32" Nullable="false"/>
                <Property Name="val" Type="Edm.Int32" Nullable="true"/>
                <Property Name="end1pk" Type="Edm.Int32" Nullable="false"/>
                <NavigationProperty Name="OneToOneEnd1" Relationship="SAPSQLOData.ONE_TO_ONE" FromRole="OneToOneEnd2_Dependent" ToRole="OneToOneEnd1_Principal"/>
            </EntityType>
            <EntityType Name="OneToManyEnd1">
                <Key>
                    <PropertyRef Name="pk"/>
                </Key>
                <Property Name="pk" Type="Edm.Int32" Nullable="false"/>
                <Property Name="val" Type="Edm.Int32" Nullable="true"/>
                <NavigationProperty Name="OneToManyEnd2" Relationship="SAPSQLOData.ONE_TO_MANY" FromRole="OneToManyEnd1_Principal" ToRole="OneToManyEnd2_Dependent"/>
            </EntityType>
            <EntityType Name="OneToManyEnd2">
                <Key>
                    <PropertyRef Name="pk"/>
                </Key>
                <Property Name="pk" Type="Edm.Int32" Nullable="false"/>
                <Property Name="end1pk" Type="Edm.Int32" Nullable="true"/>
                <NavigationProperty Name="OneToManyEnd1" Relationship="SAPSQLOData.ONE_TO_MANY" FromRole="OneToManyEnd2_Dependent" ToRole="OneToManyEnd1_Principal"/>
            </EntityType>
            <EntityType Name="ManyToManyEnd1">
                <Key>
                    <PropertyRef Name="pk"/>
                </Key>
                <Property Name="pk" Type="Edm.Int32" Nullable="false"/>
                <Property Name="val" Type="Edm.Int32" Nullable="true"/>
                <NavigationProperty Name="ManyToManyEnd2" Relationship="SAPSQLOData.MANY_TO_MANY" FromRole="ManyToManyEnd1_Principal" ToRole="ManyToManyEnd2_Dependent"/>
            </EntityType>
            <EntityType Name="ManyToManyEnd2">
                <Key>
                    <PropertyRef Name="pk"/>
                </Key>
                <Property Name="pk" Type="Edm.Int32" Nullable="false"/>
                <Property Name="val" Type="Edm.Int32" Nullable="true"/>
                <NavigationProperty Name="ManyToManyEnd1" Relationship="SAPSQLOData.MANY_TO_MANY" FromRole="ManyToManyEnd2_Dependent" ToRole="ManyToManyEnd1_Principal"/>
            </EntityType>
            <EntityType Name="ManyToZeroOrOneEnd1">
                <Key>
                    <PropertyRef Name="pk"/>
                </Key>
                <Property Name="pk" Type="Edm.Int32" Nullable="false"/>
                <Property Name="end2pk" Type="Edm.Int32" Nullable="true"/>
                <NavigationProperty Name="ManyToZeroOrOneEnd2" Relationship="SAPSQLOData.MANY_TO_ZERO_OR_ONE" FromRole="ManyToZeroOrOneEnd1_Dependent" ToRole="ManyToZeroOrOneEnd2_Principal"/>
            </EntityType>
            <EntityType Name="ManyToZeroOrOneEnd2">
                <Key>
                    <PropertyRef Name="pk"/>
                </Key>
                <Property Name="pk" Type="Edm.Int32" Nullable="false"/>
                <Property Name="val" Type="Edm.Int32" Nullable="true"/>
                <NavigationProperty Name="ManyToZeroOrOneEnd1" Relationship="SAPSQLOData.MANY_TO_ZERO_OR_ONE" FromRole="ManyToZeroOrOneEnd2_Principal" ToRole="ManyToZeroOrOneEnd1_Dependent"/>
            </EntityType>
            <EntityType Name="OneToZeroOrOneEnd1">
                <Key>
                    <PropertyRef Name="pk"/>
                </Key>
                <Property Name="pk" Type="Edm.Int32" Nullable="false"/>
                <Property Name="end2pk" Type="Edm.Int32" Nullable="true"/>
                <NavigationProperty Name="OneToZeroOrOneEnd2" Relationship="SAPSQLOData.ONE_TO_ZERO_OR_ONE" FromRole="OneToZeroOrOneEnd1_Dependent" ToRole="OneToZeroOrOneEnd2_Principal"/>
            </EntityType>
            <EntityType Name="OneToZeroOrOneEnd2">
                <Key>
                    <PropertyRef Name="pk"/>
                </Key>
                <Property Name="pk" Type="Edm.Int32" Nullable="false"/>
                <Property Name="val" Type="Edm.Int32" Nullable="true"/>
                <NavigationProperty Name="OneToZeroOrOneEnd1" Relationship="SAPSQLOData.ONE_TO_ZERO_OR_ONE" FromRole="OneToZeroOrOneEnd2_Principal" ToRole="OneToZeroOrOneEnd1_Dependent"/>
            </EntityType>
            <EntityType Name="ZeroOrOneToZeroOrOneEnd1">
                <Key>
                    <PropertyRef Name="pk"/>
                </Key>
                <Property Name="pk" Type="Edm.Int32" Nullable="false"/>
                <Property Name="val" Type="Edm.Int32" Nullable="true"/>
                <NavigationProperty Name="ZeroOrOneToZeroOrOneEnd2" Relationship="SAPSQLOData.ZERO_OR_ONE_TO_ZERO_OR_ONE" FromRole="ZeroOrOneToZeroOrOneEnd1_Principal" ToRole="ZeroOrOneToZeroOrOneEnd2_Dependent"/>
            </EntityType>
            <EntityType Name="ZeroOrOneToZeroOrOneEnd2">
                <Key>
                    <PropertyRef Name="pk"/>
                </Key>
                <Property Name="pk" Type="Edm.Int32" Nullable="false"/>
                <Property Name="val" Type="Edm.Int32" Nullable="true"/>
                <Property Name="end1pk" Type="Edm.Int32" Nullable="true"/>
                <NavigationProperty Name="ZeroOrOneToZeroOrOneEnd1" Relationship="SAPSQLOData.ZERO_OR_ONE_TO_ZERO_OR_ONE" FromRole="ZeroOrOneToZeroOrOneEnd2_Dependent" ToRole="ZeroOrOneToZeroOrOneEnd1_Principal"/>
            </EntityType>
            <EntityType Name="MultiLevel1">
                <Key>
                    <PropertyRef Name="pk"/>
                </Key>
                <Property Name="pk" Type="Edm.Int32" Nullable="false"/>
                <Property Name="val" Type="Edm.Int32" Nullable="true"/>
                <NavigationProperty Name="Level2" Relationship="SAPSQLOData.LEVEL1_TO_LEVEL2" FromRole="MultiLevel1_Principal" ToRole="MultiLevel2_Dependent"/>
            </EntityType>
            <EntityType Name="MultiLevel2">
                <Key>
                    <PropertyRef Name="pk"/>
                </Key>
                <Property Name="pk" Type="Edm.Int32" Nullable="false"/>
                <Property Name="level1pk" Type="Edm.Int32" Nullable="true"/>
                <NavigationProperty Name="Level1" Relationship="SAPSQLOData.LEVEL1_TO_LEVEL2" FromRole="MultiLevel2_Dependent" ToRole="MultiLevel1_Principal"/>
                <NavigationProperty Name="Level3" Relationship="SAPSQLOData.LEVEL2_TO_LEVEL3" FromRole="MultiLevel2_Principal" ToRole="MultiLevel3_Dependent"/>
            </EntityType>
            <EntityType Name="MultiLevel3">
                <Key>
                    <PropertyRef Name="pk"/>
                </Key>
                <Property Name="pk" Type="Edm.Int32" Nullable="false"/>
                <Property Name="level2pk" Type="Edm.Int32" Nullable="true"/>
                <NavigationProperty Name="Level2" Relationship="SAPSQLOData.LEVEL2_TO_LEVEL3" FromRole="MultiLevel3_Dependent" ToRole="MultiLevel2_Principal"/>
            </EntityType>
            <EntityType Name="Customers">
                <Key>
                    <PropertyRef Name="CustomerID"/>
                </Key>
                <Property Name="CustomerID" Type="Edm.Int32" Nullable="false"/>
                <Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="20" Unicode="false" Collation="1252LATIN1"/>
                <NavigationProperty Name="Orders" Relationship="SAPSQLOData.Customer_Orders" FromRole="Customers_Principal" ToRole="Orders_Dependent"/>
            </EntityType>
            <EntityType Name="Orders">
                <Key>
                    <PropertyRef Name="OrderID"/>
                </Key>
                <Property Name="OrderID" Type="Edm.Int32" Nullable="false"/>
                <Property Name="CustomerID" Type="Edm.Int32" Nullable="true"/>
                <NavigationProperty Name="Customer" Relationship="SAPSQLOData.Customer_Orders" FromRole="Orders_Dependent" ToRole="Customers_Principal"/>
            </EntityType>
            <Association Name="ONE_TO_ONE">
                <End Role="OneToOneEnd2_Dependent" Type="SAPSQLOData.OneToOneEnd2" Multiplicity="1"/>
                <End Role="OneToOneEnd1_Principal" Type="SAPSQLOData.OneToOneEnd1" Multiplicity="1"/>
                <ReferentialConstraint>
                    <Principal Role="OneToOneEnd1_Principal">
                        <PropertyRef Name="pk"/>
                    </Principal>
                    <Dependent Role="OneToOneEnd2_Dependent">
                        <PropertyRef Name="end1pk"/>
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="ONE_TO_MANY">
                <End Role="OneToManyEnd2_Dependent" Type="SAPSQLOData.OneToManyEnd2" Multiplicity="*"/>
                <End Role="OneToManyEnd1_Principal" Type="SAPSQLOData.OneToManyEnd1" Multiplicity="1"/>
                <ReferentialConstraint>
                    <Principal Role="OneToManyEnd1_Principal">
                        <PropertyRef Name="pk"/>
                    </Principal>
                    <Dependent Role="OneToManyEnd2_Dependent">
                        <PropertyRef Name="end1pk"/>
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="ONE_TO_ZERO_OR_ONE">
                <End Role="OneToZeroOrOneEnd1_Dependent" Type="SAPSQLOData.OneToZeroOrOneEnd1" Multiplicity="1"/>
                <End Role="OneToZeroOrOneEnd2_Principal" Type="SAPSQLOData.OneToZeroOrOneEnd2" Multiplicity="0..1"/>
                <ReferentialConstraint>
                    <Principal Role="OneToZeroOrOneEnd2_Principal">
                        <PropertyRef Name="pk"/>
                    </Principal>
                    <Dependent Role="OneToZeroOrOneEnd1_Dependent">
                        <PropertyRef Name="end2pk"/>
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="ZERO_OR_ONE_TO_ZERO_OR_ONE">
                <End Role="ZeroOrOneToZeroOrOneEnd2_Dependent" Type="SAPSQLOData.ZeroOrOneToZeroOrOneEnd2" Multiplicity="0..1"/>
                <End Role="ZeroOrOneToZeroOrOneEnd1_Principal" Type="SAPSQLOData.ZeroOrOneToZeroOrOneEnd1" Multiplicity="0..1"/>
                <ReferentialConstraint>
                    <Principal Role="ZeroOrOneToZeroOrOneEnd1_Principal">
                        <PropertyRef Name="pk"/>
                    </Principal>
                    <Dependent Role="ZeroOrOneToZeroOrOneEnd2_Dependent">
                        <PropertyRef Name="end1pk"/>
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="MANY_TO_MANY">
                <End Role="ManyToManyEnd2_Dependent" Type="SAPSQLOData.ManyToManyEnd2" Multiplicity="*"/>
                <End Role="ManyToManyEnd1_Principal" Type="SAPSQLOData.ManyToManyEnd1" Multiplicity="*"/>
            </Association>
            <Association Name="MANY_TO_ZERO_OR_ONE">
                <End Role="ManyToZeroOrOneEnd1_Dependent" Type="SAPSQLOData.ManyToZeroOrOneEnd1" Multiplicity="*"/>
                <End Role="ManyToZeroOrOneEnd2_Principal" Type="SAPSQLOData.ManyToZeroOrOneEnd2" Multiplicity="0..1"/>
                <ReferentialConstraint>
                    <Principal Role="ManyToZeroOrOneEnd2_Principal">
                        <PropertyRef Name="pk"/>
                    </Principal>
                    <Dependent Role="ManyToZeroOrOneEnd1_Dependent">
                        <PropertyRef Name="end2pk"/>
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="LEVEL1_TO_LEVEL2">
                <End Role="MultiLevel2_Dependent" Type="SAPSQLOData.MultiLevel2" Multiplicity="*"/>
                <End Role="MultiLevel1_Principal" Type="SAPSQLOData.MultiLevel1" Multiplicity="1"/>
                <ReferentialConstraint>
                    <Principal Role="MultiLevel1_Principal">
                        <PropertyRef Name="pk"/>
                    </Principal>
                    <Dependent Role="MultiLevel2_Dependent">
                        <PropertyRef Name="level1pk"/>
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="LEVEL2_TO_LEVEL3">
                <End Role="MultiLevel3_Dependent" Type="SAPSQLOData.MultiLevel3" Multiplicity="*"/>
                <End Role="MultiLevel2_Principal" Type="SAPSQLOData.MultiLevel2" Multiplicity="1"/>
                <ReferentialConstraint>
                    <Principal Role="MultiLevel2_Principal">
                        <PropertyRef Name="pk"/>
                    </Principal>
                    <Dependent Role="MultiLevel3_Dependent">
                        <PropertyRef Name="level2pk"/>
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <Association Name="Customer_Orders">
                <End Role="Orders_Dependent" Type="SAPSQLOData.Orders" Multiplicity="*"/>
                <End Role="Customers_Principal" Type="SAPSQLOData.Customers" Multiplicity="0..1"/>
                <ReferentialConstraint>
                    <Principal Role="Customers_Principal">
                        <PropertyRef Name="CustomerID"/>
                    </Principal>
                    <Dependent Role="Orders_Dependent">
                        <PropertyRef Name="CustomerID"/>
                    </Dependent>
                </ReferentialConstraint>
            </Association>
            <EntityContainer Name="SAPSQLOData_Container" m:IsDefaultEntityContainer="true">
                <EntitySet Name="OneToOneEnd1" EntityType="SAPSQLOData.OneToOneEnd1"/>
                <EntitySet Name="OneToOneEnd2" EntityType="SAPSQLOData.OneToOneEnd2"/>
                <EntitySet Name="OneToManyEnd1" EntityType="SAPSQLOData.OneToManyEnd1"/>
                <EntitySet Name="OneToManyEnd2" EntityType="SAPSQLOData.OneToManyEnd2"/>
                <EntitySet Name="ManyToManyEnd1" EntityType="SAPSQLOData.ManyToManyEnd1"/>
                <EntitySet Name="ManyToManyEnd2" EntityType="SAPSQLOData.ManyToManyEnd2"/>
                <EntitySet Name="ManyToZeroOrOneEnd1" EntityType="SAPSQLOData.ManyToZeroOrOneEnd1"/>
                <EntitySet Name="ManyToZeroOrOneEnd2" EntityType="SAPSQLOData.ManyToZeroOrOneEnd2"/>
                <EntitySet Name="OneToZeroOrOneEnd1" EntityType="SAPSQLOData.OneToZeroOrOneEnd1"/>
                <EntitySet Name="OneToZeroOrOneEnd2" EntityType="SAPSQLOData.OneToZeroOrOneEnd2"/>
                <EntitySet Name="ZeroOrOneToZeroOrOneEnd1" EntityType="SAPSQLOData.ZeroOrOneToZeroOrOneEnd1"/>
                <EntitySet Name="ZeroOrOneToZeroOrOneEnd2" EntityType="SAPSQLOData.ZeroOrOneToZeroOrOneEnd2"/>
                <EntitySet Name="MultiLevel1" EntityType="SAPSQLOData.MultiLevel1"/>
                <EntitySet Name="MultiLevel2" EntityType="SAPSQLOData.MultiLevel2"/>
                <EntitySet Name="MultiLevel3" EntityType="SAPSQLOData.MultiLevel3"/>
                <EntitySet Name="Customers" EntityType="SAPSQLOData.Customers"/>
                <EntitySet Name="Orders" EntityType="SAPSQLOData.Orders"/>
                <AssociationSet Name="ONE_TO_ONE" Association="SAPSQLOData.ONE_TO_ONE">
                    <End Role="OneToOneEnd2_Dependent" EntitySet="OneToOneEnd2"/>
                    <End Role="OneToOneEnd1_Principal" EntitySet="OneToOneEnd1"/>
                </AssociationSet>
                <AssociationSet Name="ONE_TO_MANY" Association="SAPSQLOData.ONE_TO_MANY">
                    <End Role="OneToManyEnd2_Dependent" EntitySet="OneToManyEnd2"/>
                    <End Role="OneToManyEnd1_Principal" EntitySet="OneToManyEnd1"/>
                </AssociationSet>
                <AssociationSet Name="ONE_TO_ZERO_OR_ONE" Association="SAPSQLOData.ONE_TO_ZERO_OR_ONE">
                    <End Role="OneToZeroOrOneEnd1_Dependent" EntitySet="OneToZeroOrOneEnd1"/>
                    <End Role="OneToZeroOrOneEnd2_Principal" EntitySet="OneToZeroOrOneEnd2"/>
                </AssociationSet>
                <AssociationSet Name="ZERO_OR_ONE_TO_ZERO_OR_ONE" Association="SAPSQLOData.ZERO_OR_ONE_TO_ZERO_OR_ONE">
                    <End Role="ZeroOrOneToZeroOrOneEnd2_Dependent" EntitySet="ZeroOrOneToZeroOrOneEnd2"/>
                    <End Role="ZeroOrOneToZeroOrOneEnd1_Principal" EntitySet="ZeroOrOneToZeroOrOneEnd1"/>
                </AssociationSet>
                <AssociationSet Name="MANY_TO_MANY" Association="SAPSQLOData.MANY_TO_MANY">
                    <End Role="ManyToManyEnd2_Dependent" EntitySet="ManyToManyEnd2"/>
                    <End Role="ManyToManyEnd1_Principal" EntitySet="ManyToManyEnd1"/>
                </AssociationSet>
                <AssociationSet Name="MANY_TO_ZERO_OR_ONE" Association="SAPSQLOData.MANY_TO_ZERO_OR_ONE">
                    <End Role="ManyToZeroOrOneEnd1_Dependent" EntitySet="ManyToZeroOrOneEnd1"/>
                    <End Role="ManyToZeroOrOneEnd2_Principal" EntitySet="ManyToZeroOrOneEnd2"/>
                </AssociationSet>
                <AssociationSet Name="LEVEL1_TO_LEVEL2" Association="SAPSQLOData.LEVEL1_TO_LEVEL2">
                    <End Role="MultiLevel2_Dependent" EntitySet="MultiLevel2"/>
                    <End Role="MultiLevel1_Principal" EntitySet="MultiLevel1"/>
                </AssociationSet>
                <AssociationSet Name="LEVEL2_TO_LEVEL3" Association="SAPSQLOData.LEVEL2_TO_LEVEL3">
                    <End Role="MultiLevel3_Dependent" EntitySet="MultiLevel3"/>
                    <End Role="MultiLevel2_Principal" EntitySet="MultiLevel2"/>
                </AssociationSet>
                <AssociationSet Name="Customer_Orders" Association="SAPSQLOData.Customer_Orders">
                    <End Role="Orders_Dependent" EntitySet="Orders"/>
                    <End Role="Customers_Principal" EntitySet="Customers"/>
                </AssociationSet>
            </EntityContainer>
        </Schema>
    </edmx:DataServices>
</edmx:Edmx>
<edmx:Edmx
    xmlns:edmx="http://schemas.microsoft.com/ado/2007/06/edmx" Version="1.0">
    <edmx:DataServices
        xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" m:DataServiceVersion="1.0">
        <Schema
            xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices"
            xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"
            xmlns="http://schemas.microsoft.com/ado/2008/09/edm" Namespace="SAPSQLOData">
            <EntityType Name="Owners">
                <Key>
                    <PropertyRef Name="ID"/>
                </Key>
                <Property Name="ID" Type="Edm.Int32" Nullable="false"/>
                <Property Name="Name" Type="Edm.String" Nullable="false" MaxLength="20" Unicode="false" Collation="1252LATIN1"/>
                <NavigationProperty Name="Car" Relationship="SAPSQLOData.Owner_Car" FromRole="Owners_Principal" ToRole="Cars_Dependent"/>
            </EntityType>
            <EntityType Name="Cars">
                <Key>
                    <PropertyRef Name="ID"/>
                </Key>
                <Property Name="ID" Type="Edm.Int32" Nullable="false"/>
                <Property Name="OwnerID" Type="Edm.Int32" Nullable="true"/>
                <NavigationProperty Name="Owner" Relationship="SAPSQLOData.Owner_Car" FromRole="Cars_Dependent" ToRole="Owners_Principal"/>
            </EntityType>
            <Association Name="Owner_Car">
                <End Role="Cars_Dependent" Type="SAPSQLOData.Cars" Multiplicity="1"/>
                <End Role="Owners_Principal" Type="SAPSQLOData.Owners" Multiplicity="1"/>
                <ReferentialConstraint>
                    <Principal Role="Owners_Principal">
                        <PropertyRef Name="ID"/>
                    </Principal>
                    <Dependent Role="Cars_Dependent">
                        <PropertyRef Name="OwnerID"/>
                    </Dependent>
                </ReferentialConstraint>
            </Association>
        </Schema>
    </edmx:DataServices>
</edmx:Edmx>

Last update: April 14, 2021