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