If it helps, here is the generated .edmx (as is: no modifications from me)
Thierry
<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="1.0"
xmlns:edmx="http://schemas.microsoft.com/ado/2007/06/edmx";>
<!-- EF Runtime content -->
<edmx:Runtime>
<!-- SSDL content -->
<edmx:StorageModels>
<Schema Namespace="Model.Store" Alias="Self"
Provider="FirebirdSql.Data.FirebirdClient"
ProviderManifestToken="WI-V2.1.1.17910 Firebird 2.1"
xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator";
xmlns="http://schemas.microsoft.com/ado/2006/04/edm/ssdl";>
<EntityContainer Name="ModelStoreContainer">
<EntitySet Name="LABO" EntityType="Model.Store.LABO"
store:Type="Tables" Schema="Firebird" />
<EntitySet Name="TRANSFERT_TUBES"
EntityType="Model.Store.TRANSFERT_TUBES" store:Type="Tables" Schema="Firebird"
/>
</EntityContainer>
<EntityType Name="LABO">
<Key>
<PropertyRef Name="NUM_LAB" />
<PropertyRef Name="NOM_LABO" />
<PropertyRef Name="NOM_LIVR" />
<PropertyRef Name="ADR_LIVRAISON" />
<PropertyRef Name="ADR_FACTURATION" />
<PropertyRef Name="CODE_POSTAL_LIVRAISON" />
<PropertyRef Name="CODE_POSTAL_FACTURATION" />
<PropertyRef Name="VILLE_LIVRAISON" />
<PropertyRef Name="VILLE_FACTURATION" />
<PropertyRef Name="ANCIEN_LABO" />
<PropertyRef Name="ADR_LIVR2" />
<PropertyRef Name="ADR_FACTU2" />
<PropertyRef Name="CODE_LABO" />
<PropertyRef Name="TEL_LABO" />
<PropertyRef Name="FAX_LABO" />
<PropertyRef Name="CODESFRL" />
<PropertyRef Name="NUM_PLATEAU" />
<PropertyRef Name="NUM_COLLONE_ANALYSE" />
<PropertyRef Name="NOM_COLLONE_ANALYSE" />
<PropertyRef Name="MAGH2" />
</Key>
<Property Name="NUM_LAB" Type="int" Nullable="false" />
<Property Name="NOM_LABO" Type="varchar" Nullable="false"
MaxLength="50" />
<Property Name="NOM_LIVR" Type="varchar" MaxLength="50" />
<Property Name="ADR_LIVRAISON" Type="varchar" MaxLength="50" />
<Property Name="ADR_FACTURATION" Type="varchar" MaxLength="50" />
<Property Name="CODE_POSTAL_LIVRAISON" Type="varchar" MaxLength="5" />
<Property Name="CODE_POSTAL_FACTURATION" Type="varchar" MaxLength="5"
/>
<Property Name="VILLE_LIVRAISON" Type="varchar" MaxLength="50" />
<Property Name="VILLE_FACTURATION" Type="varchar" MaxLength="50" />
<Property Name="ANCIEN_LABO" Type="varchar" MaxLength="1" />
<Property Name="ADR_LIVR2" Type="varchar" MaxLength="50" />
<Property Name="ADR_FACTU2" Type="varchar" MaxLength="50" />
<Property Name="CODE_LABO" Type="varchar" MaxLength="6" />
<Property Name="TEL_LABO" Type="varchar" MaxLength="15" />
<Property Name="FAX_LABO" Type="varchar" MaxLength="15" />
<Property Name="CODESFRL" Type="varchar" MaxLength="35" />
<Property Name="NUM_PLATEAU" Type="int" />
<Property Name="NUM_COLLONE_ANALYSE" Type="int" />
<Property Name="NOM_COLLONE_ANALYSE" Type="varchar" MaxLength="20" />
<Property Name="MAGH2" Type="varchar" Nullable="false" MaxLength="1"
/>
</EntityType>
<EntityType Name="TRANSFERT_TUBES">
<Key>
<PropertyRef Name="NUM_TRANSFERT" />
<PropertyRef Name="NUM_LOT" />
<PropertyRef Name="NUM_LAB_ORIG" />
<PropertyRef Name="REF_OPE_ORIG" />
<PropertyRef Name="SERVEUR_OPE_ORIG" />
<PropertyRef Name="NUM_LAB_DEST" />
<PropertyRef Name="REF_OPE_DEST" />
<PropertyRef Name="SERVEUR_OPE_DEST" />
<PropertyRef Name="DATE_ENVOI" />
<PropertyRef Name="DATE_ARRIVE" />
<PropertyRef Name="DATE_DOSSIER" />
<PropertyRef Name="DOSSIER" />
<PropertyRef Name="CODEBARRE" />
</Key>
<Property Name="NUM_TRANSFERT" Type="int" Nullable="false" />
<Property Name="NUM_LOT" Type="int" Nullable="false" />
<Property Name="NUM_LAB_ORIG" Type="int" />
<Property Name="REF_OPE_ORIG" Type="int" />
<Property Name="SERVEUR_OPE_ORIG" Type="int" />
<Property Name="NUM_LAB_DEST" Type="int" />
<Property Name="REF_OPE_DEST" Type="int" />
<Property Name="SERVEUR_OPE_DEST" Type="int" />
<Property Name="DATE_ENVOI" Type="timestamp" />
<Property Name="DATE_ARRIVE" Type="timestamp" />
<Property Name="DATE_DOSSIER" Type="timestamp" />
<Property Name="DOSSIER" Type="varchar" MaxLength="20" />
<Property Name="CODEBARRE" Type="varchar" MaxLength="20" />
</EntityType>
</Schema>
</edmx:StorageModels>
<!-- CSDL content -->
<edmx:ConceptualModels>
<Schema Namespace="Model" Alias="Self"
xmlns="http://schemas.microsoft.com/ado/2006/04/edm";>
<EntityContainer Name="Entities4">
<EntitySet Name="LABO" EntityType="Model.LABO" />
<EntitySet Name="TRANSFERT_TUBES" EntityType="Model.TRANSFERT_TUBES"
/>
</EntityContainer>
<EntityType Name="LABO">
<Key>
<PropertyRef Name="NUM_LAB" />
<PropertyRef Name="NOM_LABO" />
<PropertyRef Name="NOM_LIVR" />
<PropertyRef Name="ADR_LIVRAISON" />
<PropertyRef Name="ADR_FACTURATION" />
<PropertyRef Name="CODE_POSTAL_LIVRAISON" />
<PropertyRef Name="CODE_POSTAL_FACTURATION" />
<PropertyRef Name="VILLE_LIVRAISON" />
<PropertyRef Name="VILLE_FACTURATION" />
<PropertyRef Name="ANCIEN_LABO" />
<PropertyRef Name="ADR_LIVR2" />
<PropertyRef Name="ADR_FACTU2" />
<PropertyRef Name="CODE_LABO" />
<PropertyRef Name="TEL_LABO" />
<PropertyRef Name="FAX_LABO" />
<PropertyRef Name="CODESFRL" />
<PropertyRef Name="NUM_PLATEAU" />
<PropertyRef Name="NUM_COLLONE_ANALYSE" />
<PropertyRef Name="NOM_COLLONE_ANALYSE" />
<PropertyRef Name="MAGH2" />
</Key>
<Property Name="NUM_LAB" Type="Int32" Nullable="false" />
<Property Name="NOM_LABO" Type="String" Nullable="false"
MaxLength="50" Unicode="true" FixedLength="false" />
<Property Name="NOM_LIVR" Type="String" MaxLength="50" Unicode="true"
FixedLength="false" />
<Property Name="ADR_LIVRAISON" Type="String" MaxLength="50"
Unicode="true" FixedLength="false" />
<Property Name="ADR_FACTURATION" Type="String" MaxLength="50"
Unicode="true" FixedLength="false" />
<Property Name="CODE_POSTAL_LIVRAISON" Type="String" MaxLength="5"
Unicode="true" FixedLength="false" />
<Property Name="CODE_POSTAL_FACTURATION" Type="String" MaxLength="5"
Unicode="true" FixedLength="false" />
<Property Name="VILLE_LIVRAISON" Type="String" MaxLength="50"
Unicode="true" FixedLength="false" />
<Property Name="VILLE_FACTURATION" Type="String" MaxLength="50"
Unicode="true" FixedLength="false" />
<Property Name="ANCIEN_LABO" Type="String" MaxLength="1"
Unicode="true" FixedLength="false" />
<Property Name="ADR_LIVR2" Type="String" MaxLength="50"
Unicode="true" FixedLength="false" />
<Property Name="ADR_FACTU2" Type="String" MaxLength="50"
Unicode="true" FixedLength="false" />
<Property Name="CODE_LABO" Type="String" MaxLength="6" Unicode="true"
FixedLength="false" />
<Property Name="TEL_LABO" Type="String" MaxLength="15" Unicode="true"
FixedLength="false" />
<Property Name="FAX_LABO" Type="String" MaxLength="15" Unicode="true"
FixedLength="false" />
<Property Name="CODESFRL" Type="String" MaxLength="35" Unicode="true"
FixedLength="false" />
<Property Name="NUM_PLATEAU" Type="Int32" />
<Property Name="NUM_COLLONE_ANALYSE" Type="Int32" />
<Property Name="NOM_COLLONE_ANALYSE" Type="String" MaxLength="20"
Unicode="true" FixedLength="false" />
<Property Name="MAGH2" Type="String" Nullable="false" MaxLength="1"
Unicode="true" FixedLength="false" />
</EntityType>
<EntityType Name="TRANSFERT_TUBES">
<Key>
<PropertyRef Name="NUM_TRANSFERT" />
<PropertyRef Name="NUM_LOT" />
<PropertyRef Name="NUM_LAB_ORIG" />
<PropertyRef Name="REF_OPE_ORIG" />
<PropertyRef Name="SERVEUR_OPE_ORIG" />
<PropertyRef Name="NUM_LAB_DEST" />
<PropertyRef Name="REF_OPE_DEST" />
<PropertyRef Name="SERVEUR_OPE_DEST" />
<PropertyRef Name="DATE_ENVOI" />
<PropertyRef Name="DATE_ARRIVE" />
<PropertyRef Name="DATE_DOSSIER" />
<PropertyRef Name="DOSSIER" />
<PropertyRef Name="CODEBARRE" />
</Key>
<Property Name="NUM_TRANSFERT" Type="Int32" Nullable="false" />
<Property Name="NUM_LOT" Type="Int32" Nullable="false" />
<Property Name="NUM_LAB_ORIG" Type="Int32" />
<Property Name="REF_OPE_ORIG" Type="Int32" />
<Property Name="SERVEUR_OPE_ORIG" Type="Int32" />
<Property Name="NUM_LAB_DEST" Type="Int32" />
<Property Name="REF_OPE_DEST" Type="Int32" />
<Property Name="SERVEUR_OPE_DEST" Type="Int32" />
<Property Name="DATE_ENVOI" Type="DateTime" />
<Property Name="DATE_ARRIVE" Type="DateTime" />
<Property Name="DATE_DOSSIER" Type="DateTime" />
<Property Name="DOSSIER" Type="String" MaxLength="20" Unicode="true"
FixedLength="false" />
<Property Name="CODEBARRE" Type="String" MaxLength="20"
Unicode="true" FixedLength="false" />
</EntityType>
</Schema>
</edmx:ConceptualModels>
<!-- C-S mapping content -->
<edmx:Mappings>
<Mapping Space="C-S"
xmlns="urn:schemas-microsoft-com:windows:storage:mapping:CS">
<EntityContainerMapping StorageEntityContainer="ModelStoreContainer"
CdmEntityContainer="Entities4">
<EntitySetMapping Name="LABO">
<EntityTypeMapping TypeName="IsTypeOf(Model.LABO)">
<MappingFragment StoreEntitySet="LABO">
<ScalarProperty Name="NUM_LAB" ColumnName="NUM_LAB" />
<ScalarProperty Name="NOM_LABO" ColumnName="NOM_LABO" />
<ScalarProperty Name="NOM_LIVR" ColumnName="NOM_LIVR" />
<ScalarProperty Name="ADR_LIVRAISON" ColumnName="ADR_LIVRAISON"
/>
<ScalarProperty Name="ADR_FACTURATION"
ColumnName="ADR_FACTURATION" />
<ScalarProperty Name="CODE_POSTAL_LIVRAISON"
ColumnName="CODE_POSTAL_LIVRAISON" />
<ScalarProperty Name="CODE_POSTAL_FACTURATION"
ColumnName="CODE_POSTAL_FACTURATION" />
<ScalarProperty Name="VILLE_LIVRAISON"
ColumnName="VILLE_LIVRAISON" />
<ScalarProperty Name="VILLE_FACTURATION"
ColumnName="VILLE_FACTURATION" />
<ScalarProperty Name="ANCIEN_LABO" ColumnName="ANCIEN_LABO" />
<ScalarProperty Name="ADR_LIVR2" ColumnName="ADR_LIVR2" />
<ScalarProperty Name="ADR_FACTU2" ColumnName="ADR_FACTU2" />
<ScalarProperty Name="CODE_LABO" ColumnName="CODE_LABO" />
<ScalarProperty Name="TEL_LABO" ColumnName="TEL_LABO" />
<ScalarProperty Name="FAX_LABO" ColumnName="FAX_LABO" />
<ScalarProperty Name="CODESFRL" ColumnName="CODESFRL" />
<ScalarProperty Name="NUM_PLATEAU" ColumnName="NUM_PLATEAU" />
<ScalarProperty Name="NUM_COLLONE_ANALYSE"
ColumnName="NUM_COLLONE_ANALYSE" />
<ScalarProperty Name="NOM_COLLONE_ANALYSE"
ColumnName="NOM_COLLONE_ANALYSE" />
<ScalarProperty Name="MAGH2" ColumnName="MAGH2" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
<EntitySetMapping Name="TRANSFERT_TUBES">
<EntityTypeMapping TypeName="IsTypeOf(Model.TRANSFERT_TUBES)">
<MappingFragment StoreEntitySet="TRANSFERT_TUBES">
<ScalarProperty Name="NUM_TRANSFERT" ColumnName="NUM_TRANSFERT"
/>
<ScalarProperty Name="NUM_LOT" ColumnName="NUM_LOT" />
<ScalarProperty Name="NUM_LAB_ORIG" ColumnName="NUM_LAB_ORIG" />
<ScalarProperty Name="REF_OPE_ORIG" ColumnName="REF_OPE_ORIG" />
<ScalarProperty Name="SERVEUR_OPE_ORIG"
ColumnName="SERVEUR_OPE_ORIG" />
<ScalarProperty Name="NUM_LAB_DEST" ColumnName="NUM_LAB_DEST" />
<ScalarProperty Name="REF_OPE_DEST" ColumnName="REF_OPE_DEST" />
<ScalarProperty Name="SERVEUR_OPE_DEST"
ColumnName="SERVEUR_OPE_DEST" />
<ScalarProperty Name="DATE_ENVOI" ColumnName="DATE_ENVOI" />
<ScalarProperty Name="DATE_ARRIVE" ColumnName="DATE_ARRIVE" />
<ScalarProperty Name="DATE_DOSSIER" ColumnName="DATE_DOSSIER" />
<ScalarProperty Name="DOSSIER" ColumnName="DOSSIER" />
<ScalarProperty Name="CODEBARRE" ColumnName="CODEBARRE" />
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
</EntityContainerMapping>
</Mapping>
</edmx:Mappings>
</edmx:Runtime>
<!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
<edmx:Designer xmlns="http://schemas.microsoft.com/ado/2007/06/edmx";>
<edmx:Connection>
<DesignerInfoPropertySet>
<DesignerProperty Name="MetadataArtifactProcessing"
Value="EmbedInOutputAssembly" />
</DesignerInfoPropertySet>
</edmx:Connection>
<edmx:Options>
<DesignerInfoPropertySet>
<DesignerProperty Name="ValidateOnBuild" Value="true" />
</DesignerInfoPropertySet>
</edmx:Options>
<!-- Diagram content (shape and connector positions) -->
<edmx:Diagrams>
<Diagram Name="Model6">
<EntityTypeShape EntityType="Model.LABO" Width="1.5" PointX="0.75"
PointY="0.75" Height="4.2218636067708326" IsExpanded="true" />
<EntityTypeShape EntityType="Model.TRANSFERT_TUBES" Width="1.5"
PointX="2.75" PointY="0.75" Height="3.0714322916666665" IsExpanded="true"
/></Diagram></edmx:Diagrams>
</edmx:Designer>
</edmx:Edmx>-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
