MoonPro.net/MigratedCore/MP-MON/Models/MapoModel.edmx

<?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="MoonProModel.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">
        <EntityType Name="MappaStatoExpl">
          <Key>
            <PropertyRef Name="RowNum" />
          </Key>
          <Property Name="RowNum" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="lastUpdate" Type="datetime" />
          <Property Name="IdxMacchina" Type="nvarchar" MaxLength="50" />
          <Property Name="CodMacchina" Type="nvarchar" MaxLength="50" />
          <Property Name="Nome" Type="nvarchar" MaxLength="50" />
          <Property Name="url" Type="nvarchar" MaxLength="250" />
          <Property Name="idxODL" Type="int" />
          <Property Name="CodArticolo" Type="nvarchar" MaxLength="50" />
          <Property Name="Disegno" Type="nvarchar" MaxLength="50" />
          <Property Name="NumPezzi" Type="int" />
          <Property Name="TCAssegnato" Type="decimal" Precision="18" Scale="8" />
          <Property Name="DataInizioODL" Type="datetime" />
          <Property Name="Semaforo" Type="nvarchar" MaxLength="50" />
          <Property Name="idxStato" Type="int" />
          <Property Name="DescrizioneStato" Type="nvarchar" MaxLength="50" />
          <Property Name="durata" Type="float" />
          <Property Name="PezziProd" Type="int" />
          <Property Name="PezziConf" Type="int" />
          <Property Name="TempoOn" Type="decimal" Precision="18" Scale="8" />
          <Property Name="TempoAuto" Type="decimal" Precision="18" Scale="8" />
          <Property Name="TempoRun" Type="decimal" Precision="18" Scale="8" />
          <Property Name="TCMedio" Type="decimal" Precision="18" Scale="8" />
          <Property Name="TCLav" Type="decimal" Precision="18" Scale="8" />
          <Property Name="TCEff" Type="decimal" Precision="18" Scale="8" />
          <Property Name="TCMedioRT" Type="decimal" Precision="18" Scale="8" />
          <Property Name="TCLavRT" Type="decimal" Precision="18" Scale="8" />
          <Property Name="TCEffRT" Type="decimal" Precision="18" Scale="8" />
        </EntityType>
        <Function Name="stp_MSE_getData" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="maxAgeSec" Type="int" Mode="In" />
        </Function>
        <Function Name="stp_MSE_getOffline" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="keepAliveMin" Type="int" Mode="In" />
        </Function>
        <Function Name="stp_MSE_refresh" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="IdxMacchina" Type="nvarchar" Mode="In" />
        </Function>
        <EntityContainer Name="MoonProModelStoreContainer">
          <EntitySet Name="MappaStatoExpl" EntityType="Self.MappaStatoExpl" Schema="dbo" store:Type="Tables" />
        </EntityContainer>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="MoonProModel" 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">
        <EntityType Name="MappaStatoExpl">
          <Key>
            <PropertyRef Name="RowNum" />
          </Key>
          <Property Name="RowNum" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="lastUpdate" Type="DateTime" Precision="3" />
          <Property Name="IdxMacchina" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="CodMacchina" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Nome" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="url" Type="String" MaxLength="250" FixedLength="false" Unicode="true" />
          <Property Name="idxODL" Type="Int32" />
          <Property Name="CodArticolo" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="NumPezzi" Type="Int32" />
          <Property Name="TCAssegnato" Type="Decimal" Precision="18" Scale="8" />
          <Property Name="DataInizioODL" Type="DateTime" Precision="3" />
          <Property Name="Semaforo" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="idxStato" Type="Int32" />
          <Property Name="DescrizioneStato" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="durata" Type="Double" />
          <Property Name="PezziProd" Type="Int32" />
          <Property Name="PezziConf" Type="Int32" />
          <Property Name="TempoOn" Type="Decimal" Precision="18" Scale="8" />
          <Property Name="TempoAuto" Type="Decimal" Precision="18" Scale="8" />
          <Property Name="TempoRun" Type="Decimal" Precision="18" Scale="8" />
          <Property Name="TCMedio" Type="Decimal" Precision="18" Scale="8" />
          <Property Name="TCLav" Type="Decimal" Precision="18" Scale="8" />
          <Property Name="TCEff" Type="Decimal" Precision="18" Scale="8" />
          <Property Name="TCMedioRT" Type="Decimal" Precision="18" Scale="8" />
          <Property Name="TCLavRT" Type="Decimal" Precision="18" Scale="8" />
          <Property Name="TCEffRT" Type="Decimal" Precision="18" Scale="8" />
          <Property Name="Disegno" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityContainer Name="MapoMonEntities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="MappaStatoExpl" EntityType="Self.MappaStatoExpl" />
          <FunctionImport Name="stp_MSE_refresh">
          <Parameter Name="IdxMacchina" Mode="In" Type="String" />
          </FunctionImport>
          <FunctionImport Name="stp_MSE_getData" EntitySet="MappaStatoExpl" ReturnType="Collection(MoonProModel.MappaStatoExpl)">
          <Parameter Name="maxAgeSec" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="stp_MSE_getOffline" EntitySet="MappaStatoExpl" ReturnType="Collection(MoonProModel.MappaStatoExpl)">
          <Parameter Name="keepAliveMin" Mode="In" Type="Int32" />
          </FunctionImport>
        </EntityContainer>
        <ComplexType Name="stp_MSE_getData_Result">
          <Property Type="Int32" Name="RowNum" Nullable="false" />
          <Property Type="DateTime" Name="lastUpdate" Nullable="true" Precision="23" />
          <Property Type="String" Name="IdxMacchina" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="CodMacchina" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Nome" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="url" Nullable="true" MaxLength="250" />
          <Property Type="Int32" Name="idxODL" Nullable="true" />
          <Property Type="String" Name="CodArticolo" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="NumPezzi" Nullable="true" />
          <Property Type="Decimal" Name="TCAssegnato" Nullable="true" Precision="18" Scale="8" />
          <Property Type="DateTime" Name="DataInizioODL" Nullable="true" Precision="23" />
          <Property Type="String" Name="Semaforo" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="idxStato" Nullable="true" />
          <Property Type="String" Name="DescrizioneStato" Nullable="true" MaxLength="50" />
          <Property Type="Double" Name="durata" Nullable="true" />
          <Property Type="Int32" Name="PezziProd" Nullable="true" />
          <Property Type="Int32" Name="PezziConf" Nullable="true" />
          <Property Type="Decimal" Name="TempoOn" Nullable="true" Precision="18" Scale="8" />
          <Property Type="Decimal" Name="TempoAuto" Nullable="true" Precision="18" Scale="8" />
          <Property Type="Decimal" Name="TempoRun" Nullable="true" Precision="18" Scale="8" />
          <Property Type="Decimal" Name="TCMedio" Nullable="true" Precision="18" Scale="8" />
          <Property Type="Decimal" Name="TCLav" Nullable="true" Precision="18" Scale="8" />
          <Property Type="Decimal" Name="TCEff" Nullable="true" Precision="18" Scale="8" />
          <Property Type="Decimal" Name="TCMedioRT" Nullable="true" Precision="18" Scale="8" />
          <Property Type="Decimal" Name="TCLavRT" Nullable="true" Precision="18" Scale="8" />
          <Property Type="Decimal" Name="TCEffRT" Nullable="true" Precision="18" Scale="8" />
        </ComplexType>
        <ComplexType Name="stp_MSE_getOffline_Result">
          <Property Type="Int32" Name="RowNum" Nullable="false" />
          <Property Type="DateTime" Name="lastUpdate" Nullable="true" Precision="23" />
          <Property Type="String" Name="IdxMacchina" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="CodMacchina" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Nome" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="url" Nullable="true" MaxLength="250" />
          <Property Type="Int32" Name="idxODL" Nullable="true" />
          <Property Type="String" Name="CodArticolo" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="NumPezzi" Nullable="true" />
          <Property Type="Decimal" Name="TCAssegnato" Nullable="true" Precision="18" Scale="8" />
          <Property Type="DateTime" Name="DataInizioODL" Nullable="true" Precision="23" />
          <Property Type="String" Name="Semaforo" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="idxStato" Nullable="true" />
          <Property Type="String" Name="DescrizioneStato" Nullable="true" MaxLength="50" />
          <Property Type="Double" Name="durata" Nullable="true" />
          <Property Type="Int32" Name="PezziProd" Nullable="true" />
          <Property Type="Int32" Name="PezziConf" Nullable="true" />
          <Property Type="Decimal" Name="TempoOn" Nullable="true" Precision="18" Scale="8" />
          <Property Type="Decimal" Name="TempoAuto" Nullable="true" Precision="18" Scale="8" />
          <Property Type="Decimal" Name="TempoRun" Nullable="true" Precision="18" Scale="8" />
          <Property Type="Decimal" Name="TCMedio" Nullable="true" Precision="18" Scale="8" />
          <Property Type="Decimal" Name="TCLav" Nullable="true" Precision="18" Scale="8" />
          <Property Type="Decimal" Name="TCEff" Nullable="true" Precision="18" Scale="8" />
          <Property Type="Decimal" Name="TCMedioRT" Nullable="true" Precision="18" Scale="8" />
          <Property Type="Decimal" Name="TCLavRT" Nullable="true" Precision="18" Scale="8" />
          <Property Type="Decimal" Name="TCEffRT" Nullable="true" Precision="18" Scale="8" />
          <Property Type="String" Name="IdxMacchina1" Nullable="false" MaxLength="50" />
          <Property Type="DateTime" Name="DataOraServer" Nullable="true" />
          <Property Type="DateTime" Name="DataOraMacchina" Nullable="true" Precision="23" />
          <Property Type="DateTime" Name="DataOraStart" Nullable="true" Precision="23" />
        </ComplexType>
      </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="MoonProModelStoreContainer" CdmEntityContainer="MapoMonEntities">
          <EntitySetMapping Name="MappaStatoExpl">
            <EntityTypeMapping TypeName="MoonProModel.MappaStatoExpl">
              <MappingFragment StoreEntitySet="MappaStatoExpl">
                <ScalarProperty Name="Disegno" ColumnName="Disegno" />
                <ScalarProperty Name="RowNum" ColumnName="RowNum" />
                <ScalarProperty Name="lastUpdate" ColumnName="lastUpdate" />
                <ScalarProperty Name="IdxMacchina" ColumnName="IdxMacchina" />
                <ScalarProperty Name="CodMacchina" ColumnName="CodMacchina" />
                <ScalarProperty Name="Nome" ColumnName="Nome" />
                <ScalarProperty Name="url" ColumnName="url" />
                <ScalarProperty Name="idxODL" ColumnName="idxODL" />
                <ScalarProperty Name="CodArticolo" ColumnName="CodArticolo" />
                <ScalarProperty Name="NumPezzi" ColumnName="NumPezzi" />
                <ScalarProperty Name="TCAssegnato" ColumnName="TCAssegnato" />
                <ScalarProperty Name="DataInizioODL" ColumnName="DataInizioODL" />
                <ScalarProperty Name="Semaforo" ColumnName="Semaforo" />
                <ScalarProperty Name="idxStato" ColumnName="idxStato" />
                <ScalarProperty Name="DescrizioneStato" ColumnName="DescrizioneStato" />
                <ScalarProperty Name="durata" ColumnName="durata" />
                <ScalarProperty Name="PezziProd" ColumnName="PezziProd" />
                <ScalarProperty Name="PezziConf" ColumnName="PezziConf" />
                <ScalarProperty Name="TempoOn" ColumnName="TempoOn" />
                <ScalarProperty Name="TempoAuto" ColumnName="TempoAuto" />
                <ScalarProperty Name="TempoRun" ColumnName="TempoRun" />
                <ScalarProperty Name="TCMedio" ColumnName="TCMedio" />
                <ScalarProperty Name="TCLav" ColumnName="TCLav" />
                <ScalarProperty Name="TCEff" ColumnName="TCEff" />
                <ScalarProperty Name="TCMedioRT" ColumnName="TCMedioRT" />
                <ScalarProperty Name="TCLavRT" ColumnName="TCLavRT" />
                <ScalarProperty Name="TCEffRT" ColumnName="TCEffRT" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <FunctionImportMapping FunctionImportName="stp_MSE_refresh" FunctionName="MoonProModel.Store.stp_MSE_refresh" />
          <FunctionImportMapping FunctionImportName="stp_MSE_getData" FunctionName="MoonProModel.Store.stp_MSE_getData">
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="stp_MSE_getOffline" FunctionName="MoonProModel.Store.stp_MSE_getOffline">
          </FunctionImportMapping>
        </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="false" />
        <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>