F. Using an .edmx File
An .edmx file is an XML file that defines an Entity Data Model (EDM), describes the target database schema, and defines the mapping between the EDM and the database. An .edmx file also contains information that is used by the ADO.NET Entity Data Model Designer (Entity Designer) to render a model graphically.
The following code examples illustrate the necessary changes to the .edmx file in order to provide Extended Entity Framework functionality to the EDM layer.
The Entity Framework includes a set of methods similar to those of ADO.NET. These methods have been tailored to be useful for the new Entity Framework consumers – LINQ, EntitySQL, and ObjectServices.
The ADO.NET Entity Framework data provider models this functionality in the EDM by surfacing the PsqlStatus and PsqlConnectionStatistics entities, allowing you to model this functionality using standard tools in Visual Studio.
Code Examples
The following code fragment is an example of the SSDL model.
<!--
SSDL content
-->
<edmx:StorageModels>
<Schema Namespace="DDTek.Store" Alias="Self" Provider="DDTek.Oracle" ProviderManifestToken="11g"
xmlns:store="https://schemas.microsoft.com/ado/2007/12/edm/ EntityStoreSchemaGenerator"
xmlns= "https://schemas.microsoft.com/ado/2006/04/edm/ssdl">
<EntityContainer Name="DDTek_Connection">
<EntitySet Name="Connection_Statistics" EntityType="DDTek.Store.Connection_Statistics" />
<EntitySet Name="Status" EntityType="DDTek.Store.Status" />
</EntityContainer>
<Function Name="RetrieveStatistics" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" StoreFunctionName=""DDTek_Connection_RetrieveStatistics"" />
<Function Name="EnableStatistics" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" StoreFunctionName=""DDTek_Connection_EnableStatistics"" />
<Function Name="DisableStatistics" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" StoreFunctionName=""DDTek_Connection_DisableStatistics"" />
<Function Name="ResetStatistics" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" StoreFunctionName=""DDTek_Connection_ResetStatistics"" />
<!--
<Function Name="Reauthenticate" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" StoreFunctionName=""DDTek_Connection_Reauthenticate""> -->
<!-- <Parameter Name="CurrentUser" Type="varchar2" Mode="In" /> -->
<!-- <Parameter Name="CurrentPassword" Type="varchar2" Mode="In" /> -->
<!-- <Parameter Name="CurrentUserAffinityTimeout" Type="number" Precision="10" Mode="In" /> --></Function>
-->
<EntityType Name="Connection_Statistics">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="SocketReadTime" Type="binary_double" Nullable="false" />
<Property Name="MaxSocketReadTime" Type="binary_double" Nullable="false" />
<Property Name="SocketReads" Type="number" Precision="20" Nullable="false" />
<Property Name="BytesReceived" Type="number" Precision="20" Nullable="false" />
<Property Name="MaxBytesPerSocketRead" Type="number" Precision="20" Nullable="false" />
<Property Name="SocketWriteTime" Type="binary_double" Nullable="false" />
<Property Name="MaxSocketWriteTime" Type="binary_double" Nullable="false" />
<Property Name="SocketWrites" Type="number" Precision="20" Nullable="false" />
<Property Name="BytesSent" Type="number" Precision="20" Nullable="false" />
<Property Name="MaxBytesPerSocketWrite" Type="number" Precision="20" Nullable="false" />
<Property Name="TimeToDisposeOfUnreadRows" Type="binary_double" Nullable="false" />
<Property Name="SocketReadsToDisposeUnreadRows" Type="number" Precision="20" Nullable="false" />
<Property Name="BytesRecvToDisposeUnreadRows" Type="number" Precision="20" Nullable="false" />
<Property Name="IDUCount" Type="number" Precision="20" Nullable="false" />
<Property Name="SelectCount" Type="number" Precision="20" Nullable="false" />
<Property Name="StoredProcedureCount" Type="number" Precision="20" Nullable="false" />
<Property Name="DDLCount" Type="number" Precision="20" Nullable="false" />
<Property Name="PacketsReceived" Type="number" Precision="20" Nullable="false" />
<Property Name="PacketsSent" Type="number" Precision="20" Nullable="false" />
<Property Name="ServerRoundTrips" Type="number" Precision="20" Nullable="false" />
<Property Name="SelectRowsRead" Type="number" Precision="20" Nullable="false" />
<Property Name="StatementCacheHits" Type="number" Precision="20" Nullable="false" />
<Property Name="StatementCacheMisses" Type="number" Precision="20" Nullable="false" />
<Property Name="StatementCacheReplaces" Type="number" Precision="20" Nullable="false" />
<Property Name="StatementCacheTopHit1" Type="number" Precision="20" Nullable="false" />
<Property Name="StatementCacheTopHit2" Type="number" Precision="20" Nullable="false" />
<Property Name="StatementCacheTopHit3" Type="number" Precision="20" Nullable="false" />
<Property Name="PacketsReceivedPerSocketRead" Type="binary_double" Nullable="false" />
<Property Name="BytesReceivedPerSocketRead" Type="binary_double" Nullable="false" />
<Property Name="PacketsSentPerSocketWrite" Type="binary_double" Nullable="false" />
<Property Name="BytesSentPerSocketWrite" Type="binary_double" Nullable="false" />
<Property Name="PacketsSentPerRoundTrip" Type="binary_double" Nullable="false" />
<Property Name="PacketsReceivedPerRoundTrip" Type="binary_double" Nullable="false" />
<Property Name="BytesSentPerRoundTrip" Type="binary_double" Nullable="false" />
<Property Name="BytesReceivedPerRoundTrip" Type="binary_double" Nullable="false" />
<!--
Oracle specific
-->
<Property Name="PartialPacketShifts" Type="number" Precision="20" Nullable="false" />
<Property Name="PartialPacketShiftBytes" Type="number" Precision="20" Nullable="false" />
<Property Name="MaxReplyBytes" Type="number" Precision="20" Nullable="false" />
<Property Name="MaxReplyPacketChainCount" Type="number" Precision="20" Nullable="false" />
<Property Name="Id" Type="number" Precision="10" Nullable="false" />
</EntityType>
<EntityType Name="Status">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="ServerVersion" Type="varchar2" Nullable="false" />
<Property Name="Host" Type="varchar2" Nullable="false" />
<Property Name="Port" Type="number" Precision="10" Nullable="false" />
<Property Name="SID" Type="varchar2" Nullable="false" />
<!-- <Property Name="CurrentUser" Type="varchar2" Nullable="false" /> -->
<!-- <Property Name="CurrentUserAffinityTimeout" Type="number" Precision="10" Nullable="false" /> -->
<!-- <Property Name="SessionId" Type="number" Precision="10" Nullable="false" /> -->
<Property Name="StatisticsEnabled" Type="number" Precision="1" Nullable="false" />
<Property Name="Id" Type="number" Precision="10" Nullable="false" />
</EntityType>
</Schema>
</edmx:StorageModels>
Breaking the model down further, we establish a CSDL model at the conceptual layer. This layer is what is exposed to the EDM.
<edmx:ConceptualModels>
<Schema Namespace="DDTek" Alias="Self"
xmlns="https://schemas.microsoft.com/ado/ 2006/04/edm">
<EntityContainer Name="DDTekConnectionContext">
<EntitySet Name="DDTekConnectionStatistics" EntityType="DDTek.DDTekConnectionStatistics" />
<EntitySet Name="DDTekStatus" EntityType="DDTek.DDTekStatus" />
<FunctionImport Name="RetrieveStatistics" EntitySet="DDTekConnectionStatistics" ReturnType= "Collection(DDTek.DDTekConnectionStatistics)" />
<FunctionImport Name="EnableStatistics" EntitySet="DDTekStatus" ReturnType="Collection(DDTek.DDTekStatus)" />
<FunctionImport Name="DisableStatistics" EntitySet="DDTekStatus" ReturnType= "Collection(DDTek.DDTekStatus)" />
<FunctionImport Name="ResetStatistics" EntitySet="DDTekStatus" ReturnType="Collection(DDTek.DDTekStatus)" />
<FunctionImport Name="Reauthenticate" EntitySet="DDTekStatus" ReturnType= "Collection(DDTek.DDTekStatus)">
<Parameter Name="CurrentUser" Type="String" />
<Parameter Name="CurrentPassword" Type="String" />
<Parameter Name="CurrentUserAffinityTimeout" Type="Int32" />
</FunctionImport>
</EntityContainer>
<EntityType Name="DDTekConnectionStatistics">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="SocketReadTime" Type="Double" Nullable="false" />
<Property Name="MaxSocketReadTime" Type="Double" Nullable="false" />
<Property Name="SocketReads" Type="Int64" Nullable="false" />
<Property Name="BytesReceived" Type="Int64" Nullable="false" />
<Property Name="MaxBytesPerSocketRead" Type="Int64" Nullable="false" />
<Property Name="SocketWriteTime" Type="Double" Nullable="false" />
<Property Name="MaxSocketWriteTime" Type="Double" Nullable="false" />
<Property Name="SocketWrites" Type="Int64" Nullable="false" />
<Property Name="BytesSent" Type="Int64" Nullable="false" />
<Property Name="MaxBytesPerSocketWrite" Type="Int64" Nullable="false" />
<Property Name="TimeToDisposeOfUnreadRows" Type="Double" Nullable="false" />
<Property Name="SocketReadsToDisposeUnreadRows" Type="Int64" Nullable="false" />
<Property Name="BytesRecvToDisposeUnreadRows" Type="Int64" Nullable="false" />
<Property Name="IDUCount" Type="Int64" Nullable="false" />
<Property Name="SelectCount" Type="Int64" Nullable="false" />
<Property Name="StoredProcedureCount" Type="Int64" Nullable="false" />
<Property Name="DDLCount" Type="Int64" Nullable="false" />
<Property Name="PacketsReceived" Type="Int64" Nullable="false" />
<Property Name="PacketsSent" Type="Int64" Nullable="false" />
<Property Name="ServerRoundTrips" Type="Int64" Nullable="false" />
<Property Name="SelectRowsRead" Type="Int64" Nullable="false" />
<Property Name="StatementCacheHits" Type="Int64" Nullable="false" />
<Property Name="StatementCacheMisses" Type="Int64" Nullable="false" />
<Property Name="StatementCacheReplaces" Type="Int64" Nullable="false" />
<Property Name="StatementCacheTopHit1" Type="Int64" Nullable="false" />
<Property Name="StatementCacheTopHit2" Type="Int64" Nullable="false" />
<Property Name="StatementCacheTopHit3" Type="Int64" Nullable="false" />
<Property Name="PacketsReceivedPerSocketRead" Type="Double" Nullable="false" />
<Property Name="BytesReceivedPerSocketRead" Type="Double" Nullable="false" />
<Property Name="PacketsSentPerSocketWrite" Type="Double" Nullable="false" />
<Property Name="BytesSentPerSocketWrite" Type="Double" Nullable="false" />
<Property Name="PacketsSentPerRoundTrip" Type="Double" Nullable="false" />
<Property Name="PacketsReceivedPerRoundTrip" Type="Double" Nullable="false" />
<Property Name="BytesSentPerRoundTrip" Type="Double" Nullable="false" />
<Property Name="BytesReceivedPerRoundTrip" Type="Double" Nullable="false" />
<Property Name="PartialPacketShifts" Type="Int64" Nullable="false" />
<Property Name="PartialPacketShiftBytes" Type="Int64" Nullable="false" />
<Property Name="MaxReplyBytes" Type="Int64" Nullable="false" />
<Property Name="MaxReplyPacketChainCount" Type="Int64" Nullable="false" />
<Property Name="Id" Type="Int32" Nullable="false" />
</EntityType>
<EntityType Name="DDTekStatus">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="ServerVersion" Type="String" Nullable="false" />
<Property Name="Host" Type="String" Nullable="false" />
<Property Name="Port" Type="Int32" Nullable="false" />
<Property Name="SID" Type="String" Nullable="false" />
<Property Name="CurrentUser" Type="String" Nullable="false" />
<Property Name="CurrentUserAffinityTimeout" Type="Int32" Nullable="false" />
<Property Name="SessionId" Type="Int32" Nullable="false" />
<Property Name="StatisticsEnabled" Type="Boolean" Nullable="false" />
<Property Name="Id" Type="Int32" Nullable="false" />
</EntityType>
</Schema>
</edmx:ConceptualModels>
The following simple mapping binds the pieces together.
<!--
C-S mapping content
-->
<edmx:Mappings>
<Mapping Space="C-S"
xmlns="urn:schemas-microsoft- com:windows:storage:mapping:CS">
<EntityContainerMapping StorageEntityContainer="DDTek_Connection" CdmEntityContainer="DDTekConnectionContext">
<EntitySetMapping Name="DDTekConnectionStatistics">
<EntityTypeMapping TypeName="DDTek.DDTekConnectionStatistics">
<MappingFragment StoreEntitySet="Connection_Statistics">
<!--
StoreEntitySet="Connection_Statistics" TypeName="DDTek.DDTekConnectionStatistics">
-->
<ScalarProperty Name="SocketReadTime" ColumnName="SocketReadTime" />
<ScalarProperty Name="MaxSocketReadTime" ColumnName="MaxSocketReadTime" />
<ScalarProperty Name="SocketReads" ColumnName="SocketReads" />
<ScalarProperty Name="BytesReceived" ColumnName="BytesReceived" />
<ScalarProperty Name="MaxBytesPerSocketRead" ColumnName="MaxBytesPerSocketRead" />
<ScalarProperty Name="SocketWriteTime" ColumnName="SocketWriteTime" />
<ScalarProperty Name="MaxSocketWriteTime" ColumnName="MaxSocketWriteTime" />
<ScalarProperty Name="SocketWrites" ColumnName="SocketWrites" />
<ScalarProperty Name="BytesSent" ColumnName="BytesSent" />
<ScalarProperty Name="MaxBytesPerSocketWrite" ColumnName="MaxBytesPerSocketWrite" />
<ScalarProperty Name="TimeToDisposeOfUnreadRows" ColumnName="TimeToDisposeOfUnreadRows" />
<ScalarProperty Name="SocketReadsToDisposeUnreadRows" ColumnName= "SocketReadsToDisposeUnreadRows" />
<ScalarProperty Name="BytesRecvToDisposeUnreadRows" ColumnName="BytesRecvToDisposeUnreadRows" />
<ScalarProperty Name="IDUCount" ColumnName="IDUCount" />
<ScalarProperty Name="SelectCount" ColumnName="SelectCount" />
<ScalarProperty Name="StoredProcedureCount" ColumnName="StoredProcedureCount" />
<ScalarProperty Name="DDLCount" ColumnName="DDLCount" />
<ScalarProperty Name="PacketsReceived" ColumnName="PacketsReceived" />
<ScalarProperty Name="PacketsSent" ColumnName="PacketsSent" />
<ScalarProperty Name="ServerRoundTrips" ColumnName="ServerRoundTrips" />
<ScalarProperty Name="SelectRowsRead" ColumnName="SelectRowsRead" />
<ScalarProperty Name="StatementCacheHits" ColumnName="StatementCacheHits" />
<ScalarProperty Name="StatementCacheMisses" ColumnName="StatementCacheMisses" />
<ScalarProperty Name="StatementCacheReplaces" ColumnName="StatementCacheReplaces" />
<ScalarProperty Name="StatementCacheTopHit1" ColumnName="StatementCacheTopHit1" />
<ScalarProperty Name="StatementCacheTopHit2" ColumnName="StatementCacheTopHit2" />
<ScalarProperty Name="StatementCacheTopHit3" ColumnName="StatementCacheTopHit3" />
<ScalarProperty Name="PacketsReceivedPerSocketRead" ColumnName="PacketsReceivedPerSocketRead" />
<ScalarProperty Name="BytesReceivedPerSocketRead" ColumnName="BytesReceivedPerSocketRead" />
<ScalarProperty Name="PacketsSentPerSocketWrite" ColumnName="PacketsSentPerSocketWrite" />
<ScalarProperty Name="BytesSentPerSocketWrite" ColumnName="BytesSentPerSocketWrite" />
<ScalarProperty Name="PacketsSentPerRoundTrip" ColumnName="PacketsSentPerRoundTrip" />
<ScalarProperty Name="PacketsReceivedPerRoundTrip" ColumnName="PacketsReceivedPerRoundTrip" />
<ScalarProperty Name="BytesSentPerRoundTrip" ColumnName="BytesSentPerRoundTrip" />
<ScalarProperty Name="BytesReceivedPerRoundTrip" ColumnName="BytesReceivedPerRoundTrip" />
<ScalarProperty Name="PartialPacketShifts" ColumnName="PartialPacketShifts" />
<ScalarProperty Name="PartialPacketShiftBytes" ColumnName="PartialPacketShiftBytes" />
<ScalarProperty Name="MaxReplyBytes" ColumnName="MaxReplyBytes" />
<ScalarProperty Name="MaxReplyPacketChainCount" ColumnName="MaxReplyPacketChainCount" />
<ScalarProperty Name="Id" ColumnName="Id" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<EntitySetMapping Name="DDTekStatus">
<EntityTypeMapping TypeName="DDTek.DDTekStatus">
<MappingFragment StoreEntitySet="Status">
<ScalarProperty Name="ServerVersion" ColumnName="ServerVersion" />
<ScalarProperty Name="Host" ColumnName="Host" />
<ScalarProperty Name="Port" ColumnName="Port" />
<ScalarProperty Name="SID" ColumnName="SID" />
<!-- <ScalarProperty Name="CurrentUser" ColumnName="CurrentUser" /> -->
<!-- <ScalarProperty Name="CurrentUserAffinityTimeout" ColumnName="CurrentUserAffinityTimeout" /> -->
<!-- <ScalarProperty Name="SessionId" ColumnName="SessionId" /> -->
<ScalarProperty Name="StatisticsEnabled" ColumnName="StatisticsEnabled" />
<ScalarProperty Name="Id" ColumnName="Id" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<FunctionImportMapping FunctionImportName="RetrieveStatistics" FunctionName= "DDTek.Store.RetrieveStatistics" />
<FunctionImportMapping FunctionImportName="EnableStatistics" FunctionName="DDTek.Store.EnableStatistics" />
<FunctionImportMapping FunctionImportName="DisableStatistics" FunctionName= "DDTek.Store.DisableStatistics" />
<FunctionImportMapping FunctionImportName="ResetStatistics" FunctionName="DDTek.Store.ResetStatistics" />
<FunctionImportMapping FunctionImportName="Reauthenticate" FunctionName= "DDTek.Store.Reauthenticate" />
</EntityContainerMapping>
</Mapping>
</edmx:Mappings>