CourseProject/Logistics application/TableDatabase.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="Хранилище gr682_ggi3Model" 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="Car">
          <Key>
            <PropertyRef Name="ID_Car" />
          </Key>
          <Property Name="ID_Car" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="MachineType" Type="nvarchar" MaxLength="15" />
          <Property Name="MachineBrand" Type="nvarchar" MaxLength="15" />
        </EntityType>
        <EntityType Name="Driver">
          <Key>
            <PropertyRef Name="ID_Driver" />
          </Key>
          <Property Name="ID_Driver" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Login" Type="nvarchar" MaxLength="10" Nullable="false" />
          <Property Name="Password" Type="nvarchar" MaxLength="10" Nullable="false" />
          <Property Name="Surname" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="Name" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="MiddleName" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="ID_Car" Type="int" Nullable="false" />
          <Property Name="BrigadeNumber" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Operator">
          <Key>
            <PropertyRef Name="ID_Operator" />
          </Key>
          <Property Name="ID_Operator" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="Login" Type="nvarchar" MaxLength="10" Nullable="false" />
          <Property Name="Password" Type="nvarchar" MaxLength="10" Nullable="false" />
          <Property Name="Surname" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="Name" Type="nvarchar" MaxLength="15" Nullable="false" />
          <Property Name="MiddleName" Type="nvarchar" MaxLength="15" Nullable="false" />
        </EntityType>
        <EntityType Name="Order">
          <Key>
            <PropertyRef Name="ID_Order" />
          </Key>
          <Property Name="ID_Order" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="OrderNumber" Type="int" Nullable="false" />
          <Property Name="ID_Driver" Type="int" Nullable="false" />
          <Property Name="ID_Car" Type="int" Nullable="false" />
          <Property Name="Sender" Type="nvarchar" MaxLength="50" />
          <Property Name="Departure_Date" Type="date" />
          <Property Name="Sender_Phone_Number" Type="int" />
          <Property Name="Recipient" Type="nvarchar" MaxLength="50" />
          <Property Name="Date_Of_Receiving" Type="date" />
          <Property Name="Recipient_Phone_Number" Type="int" />
        </EntityType>
        <EntityType Name="Route">
          <Key>
            <PropertyRef Name="ID_Route" />
          </Key>
          <Property Name="ID_Route" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
          <Property Name="OrderNumber" Type="int" Nullable="false" />
          <Property Name="Sender_City" Type="nvarchar" MaxLength="15" />
          <Property Name="Recipirnt_City" Type="nvarchar" MaxLength="15" />
          <Property Name="Shord_Route" Type="nchar" MaxLength="10" />
        </EntityType>
        <EntityContainer Name="Хранилище gr682_ggi3ModelContainer">
          <EntitySet Name="Car" EntityType="Self.Car" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Driver" EntityType="Self.Driver" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Operator" EntityType="Self.Operator" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Order" EntityType="Self.Order" Schema="dbo" store:Type="Tables" />
          <EntitySet Name="Route" EntityType="Self.Route" Schema="dbo" store:Type="Tables" />
        </EntityContainer>
      </Schema>
    </edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="gr682_ggi3Model" 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="Car">
          <Key>
            <PropertyRef Name="ID_Car" />
          </Key>
          <Property Name="ID_Car" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="MachineType" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="MachineBrand" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="Driver">
          <Key>
            <PropertyRef Name="ID_Driver" />
          </Key>
          <Property Name="ID_Driver" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Login" Type="String" MaxLength="10" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Password" Type="String" MaxLength="10" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Surname" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Name" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="MiddleName" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="ID_Car" Type="Int32" Nullable="false" />
          <Property Name="BrigadeNumber" Type="Int32" Nullable="false" />
        </EntityType>
        <EntityType Name="Operator">
          <Key>
            <PropertyRef Name="ID_Operator" />
          </Key>
          <Property Name="ID_Operator" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Login" Type="String" MaxLength="10" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Password" Type="String" MaxLength="10" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Surname" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="Name" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
          <Property Name="MiddleName" Type="String" MaxLength="15" FixedLength="false" Unicode="true" Nullable="false" />
        </EntityType>
        <EntityType Name="Order">
          <Key>
            <PropertyRef Name="ID_Order" />
          </Key>
          <Property Name="ID_Order" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="OrderNumber" Type="Int32" Nullable="false" />
          <Property Name="ID_Driver" Type="Int32" Nullable="false" />
          <Property Name="ID_Car" Type="Int32" Nullable="false" />
          <Property Name="Sender" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Departure_Date" Type="DateTime" Precision="0" />
          <Property Name="Sender_Phone_Number" Type="Int32" />
          <Property Name="Recipient" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Name="Date_Of_Receiving" Type="DateTime" Precision="0" />
          <Property Name="Recipient_Phone_Number" Type="Int32" />
        </EntityType>
        <EntityType Name="Route">
          <Key>
            <PropertyRef Name="ID_Route" />
          </Key>
          <Property Name="ID_Route" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="OrderNumber" Type="Int32" Nullable="false" />
          <Property Name="Sender_City" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="Recipirnt_City" Type="String" MaxLength="15" FixedLength="false" Unicode="true" />
          <Property Name="Shord_Route" Type="String" MaxLength="10" FixedLength="true" Unicode="true" />
        </EntityType>
        <EntityContainer Name="gr682_ggi3Entities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="Car" EntityType="Self.Car" />
          <EntitySet Name="Driver" EntityType="Self.Driver" />
          <EntitySet Name="Operator" EntityType="Self.Operator" />
          <EntitySet Name="Order" EntityType="Self.Order" />
          <EntitySet Name="Route" EntityType="Self.Route" />
        </EntityContainer>
      </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="Хранилище gr682_ggi3ModelContainer" CdmEntityContainer="gr682_ggi3Entities">
          <EntitySetMapping Name="Car">
            <EntityTypeMapping TypeName="gr682_ggi3Model.Car">
              <MappingFragment StoreEntitySet="Car">
                <ScalarProperty Name="ID_Car" ColumnName="ID_Car" />
                <ScalarProperty Name="MachineType" ColumnName="MachineType" />
                <ScalarProperty Name="MachineBrand" ColumnName="MachineBrand" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Driver">
            <EntityTypeMapping TypeName="gr682_ggi3Model.Driver">
              <MappingFragment StoreEntitySet="Driver">
                <ScalarProperty Name="ID_Driver" ColumnName="ID_Driver" />
                <ScalarProperty Name="Login" ColumnName="Login" />
                <ScalarProperty Name="Password" ColumnName="Password" />
                <ScalarProperty Name="Surname" ColumnName="Surname" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
                <ScalarProperty Name="ID_Car" ColumnName="ID_Car" />
                <ScalarProperty Name="BrigadeNumber" ColumnName="BrigadeNumber" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Operator">
            <EntityTypeMapping TypeName="gr682_ggi3Model.Operator">
              <MappingFragment StoreEntitySet="Operator">
                <ScalarProperty Name="ID_Operator" ColumnName="ID_Operator" />
                <ScalarProperty Name="Login" ColumnName="Login" />
                <ScalarProperty Name="Password" ColumnName="Password" />
                <ScalarProperty Name="Surname" ColumnName="Surname" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="MiddleName" ColumnName="MiddleName" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Order">
            <EntityTypeMapping TypeName="gr682_ggi3Model.Order">
              <MappingFragment StoreEntitySet="Order">
                <ScalarProperty Name="ID_Order" ColumnName="ID_Order" />
                <ScalarProperty Name="OrderNumber" ColumnName="OrderNumber" />
                <ScalarProperty Name="ID_Driver" ColumnName="ID_Driver" />
                <ScalarProperty Name="ID_Car" ColumnName="ID_Car" />
                <ScalarProperty Name="Sender" ColumnName="Sender" />
                <ScalarProperty Name="Departure_Date" ColumnName="Departure_Date" />
                <ScalarProperty Name="Sender_Phone_Number" ColumnName="Sender_Phone_Number" />
                <ScalarProperty Name="Recipient" ColumnName="Recipient" />
                <ScalarProperty Name="Date_Of_Receiving" ColumnName="Date_Of_Receiving" />
                <ScalarProperty Name="Recipient_Phone_Number" ColumnName="Recipient_Phone_Number" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Route">
            <EntityTypeMapping TypeName="gr682_ggi3Model.Route">
              <MappingFragment StoreEntitySet="Route">
                <ScalarProperty Name="ID_Route" ColumnName="ID_Route" />
                <ScalarProperty Name="OrderNumber" ColumnName="OrderNumber" />
                <ScalarProperty Name="Sender_City" ColumnName="Sender_City" />
                <ScalarProperty Name="Recipirnt_City" ColumnName="Recipirnt_City" />
                <ScalarProperty Name="Shord_Route" ColumnName="Shord_Route" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
        </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="Нет" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams></Diagrams>
  </Designer>
</edmx:Edmx>