123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120 |
- <?xml version="1.0" encoding="utf-8"?>
- <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
- <EntityContainerMapping StorageEntityContainer="Хранилище Session3_4ModelContainer" CdmEntityContainer="Session3_4Entities">
- <EntitySetMapping Name="Aircrafts">
- <EntityTypeMapping TypeName="Session3_4Model.Aircrafts">
- <MappingFragment StoreEntitySet="Aircrafts">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="Name" ColumnName="Name" />
- <ScalarProperty Name="MakeModel" ColumnName="MakeModel" />
- <ScalarProperty Name="TotalSeats" ColumnName="TotalSeats" />
- <ScalarProperty Name="EconomySeats" ColumnName="EconomySeats" />
- <ScalarProperty Name="BusinessSeats" ColumnName="BusinessSeats" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Airports">
- <EntityTypeMapping TypeName="Session3_4Model.Airports">
- <MappingFragment StoreEntitySet="Airports">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="CountryID" ColumnName="CountryID" />
- <ScalarProperty Name="IATACode" ColumnName="IATACode" />
- <ScalarProperty Name="Name" ColumnName="Name" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="CabinTypes">
- <EntityTypeMapping TypeName="Session3_4Model.CabinTypes">
- <MappingFragment StoreEntitySet="CabinTypes">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="Name" ColumnName="Name" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Countries">
- <EntityTypeMapping TypeName="Session3_4Model.Countries">
- <MappingFragment StoreEntitySet="Countries">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="Name" ColumnName="Name" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Offices">
- <EntityTypeMapping TypeName="Session3_4Model.Offices">
- <MappingFragment StoreEntitySet="Offices">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="CountryID" ColumnName="CountryID" />
- <ScalarProperty Name="Title" ColumnName="Title" />
- <ScalarProperty Name="Phone" ColumnName="Phone" />
- <ScalarProperty Name="Contact" ColumnName="Contact" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Roles">
- <EntityTypeMapping TypeName="Session3_4Model.Roles">
- <MappingFragment StoreEntitySet="Roles">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="Title" ColumnName="Title" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Routes">
- <EntityTypeMapping TypeName="Session3_4Model.Routes">
- <MappingFragment StoreEntitySet="Routes">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="DepartureAirportID" ColumnName="DepartureAirportID" />
- <ScalarProperty Name="ArrivalAirportID" ColumnName="ArrivalAirportID" />
- <ScalarProperty Name="Distance" ColumnName="Distance" />
- <ScalarProperty Name="FlightTime" ColumnName="FlightTime" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Schedules">
- <EntityTypeMapping TypeName="Session3_4Model.Schedules">
- <MappingFragment StoreEntitySet="Schedules">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="Date" ColumnName="Date" />
- <ScalarProperty Name="Time" ColumnName="Time" />
- <ScalarProperty Name="AircraftID" ColumnName="AircraftID" />
- <ScalarProperty Name="RouteID" ColumnName="RouteID" />
- <ScalarProperty Name="EconomyPrice" ColumnName="EconomyPrice" />
- <ScalarProperty Name="Confirmed" ColumnName="Confirmed" />
- <ScalarProperty Name="FlightNumber" ColumnName="FlightNumber" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Tickets">
- <EntityTypeMapping TypeName="Session3_4Model.Tickets">
- <MappingFragment StoreEntitySet="Tickets">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="UserID" ColumnName="UserID" />
- <ScalarProperty Name="ScheduleID" ColumnName="ScheduleID" />
- <ScalarProperty Name="CabinTypeID" ColumnName="CabinTypeID" />
- <ScalarProperty Name="Firstname" ColumnName="Firstname" />
- <ScalarProperty Name="Lastname" ColumnName="Lastname" />
- <ScalarProperty Name="Email" ColumnName="Email" />
- <ScalarProperty Name="Phone" ColumnName="Phone" />
- <ScalarProperty Name="PassportNumber" ColumnName="PassportNumber" />
- <ScalarProperty Name="PassportCountryID" ColumnName="PassportCountryID" />
- <ScalarProperty Name="BookingReference" ColumnName="BookingReference" />
- <ScalarProperty Name="Confirmed" ColumnName="Confirmed" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- <EntitySetMapping Name="Users">
- <EntityTypeMapping TypeName="Session3_4Model.Users">
- <MappingFragment StoreEntitySet="Users">
- <ScalarProperty Name="ID" ColumnName="ID" />
- <ScalarProperty Name="RoleID" ColumnName="RoleID" />
- <ScalarProperty Name="Email" ColumnName="Email" />
- <ScalarProperty Name="Password" ColumnName="Password" />
- <ScalarProperty Name="FirstName" ColumnName="FirstName" />
- <ScalarProperty Name="LastName" ColumnName="LastName" />
- <ScalarProperty Name="OfficeID" ColumnName="OfficeID" />
- <ScalarProperty Name="Birthdate" ColumnName="Birthdate" />
- <ScalarProperty Name="Active" ColumnName="Active" />
- </MappingFragment>
- </EntityTypeMapping>
- </EntitySetMapping>
- </EntityContainerMapping>
- </Mapping>
|