aboutsummaryrefslogtreecommitdiffstats
path: root/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx
diff options
context:
space:
mode:
Diffstat (limited to 'Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx')
-rw-r--r--Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx72
1 files changed, 69 insertions, 3 deletions
diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx
index 1bd77ac1d..67e38b06d 100644
--- a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx
+++ b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx
@@ -25,7 +25,7 @@
<Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" />
<Property Name="LAST_UPDATED" Type="datetime" Nullable="false" />
<Property Name="DELETED" Type="bit" Nullable="false" />
- <Property Name="ADDRESS" Type="nvarchar" MaxLength="2147483647" Nullable="false" />
+ <Property Name="ADDRESS_STRING" Type="nvarchar" MaxLength="2147483647" Nullable="false" />
<Property Name="LOCALITY" Type="nvarchar" MaxLength="2147483647" />
<Property Name="COUNTRY" Type="nvarchar" MaxLength="2147483647" />
<Property Name="CITY" Type="nvarchar" MaxLength="2147483647" />
@@ -69,6 +69,15 @@
<Property Name="LAST_UPDATED" Type="datetime" Nullable="false" />
<Property Name="DELETED" Type="bit" Nullable="false" />
</EntityType>
+ <EntityType Name="CARTRIDGE_TYPES">
+ <Key>
+ <PropertyRef Name="ID" />
+ </Key>
+ <Property Name="ID" Type="integer" Nullable="false" />
+ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" />
+ <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" />
+ <Property Name="DELETED" Type="bit" Nullable="false" />
+ </EntityType>
<EntityType Name="CARTRIDGES">
<Key>
<PropertyRef Name="ID" />
@@ -77,6 +86,7 @@
<Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" />
<Property Name="LAST_UPDATED" Type="datetime" Nullable="false" />
<Property Name="DELETED" Type="bit" Nullable="false" />
+ <Property Name="CARTRIDGE_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" />
</EntityType>
<EntityType Name="CONFIGURATIONS">
<Key>
@@ -123,6 +133,15 @@
<Property Name="PHONE_NUMBER" Type="nvarchar" MaxLength="2147483647" Nullable="false" />
<Property Name="FAX" Type="nvarchar" MaxLength="2147483647" Nullable="false" />
</EntityType>
+ <EntityType Name="DISPENSER_TYPES">
+ <Key>
+ <PropertyRef Name="ID" />
+ </Key>
+ <Property Name="ID" Type="integer" Nullable="false" />
+ <Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" />
+ <Property Name="LAST_UPDATED" Type="datetime" Nullable="false" />
+ <Property Name="DELETED" Type="bit" Nullable="false" />
+ </EntityType>
<EntityType Name="DISPENSERS">
<Key>
<PropertyRef Name="ID" />
@@ -131,6 +150,7 @@
<Property Name="GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" />
<Property Name="LAST_UPDATED" Type="datetime" Nullable="false" />
<Property Name="DELETED" Type="bit" Nullable="false" />
+ <Property Name="DISPENSER_TYPE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" />
</EntityType>
<EntityType Name="EMBEDDED_FIRMWARE_VERSIONS">
<Key>
@@ -441,10 +461,12 @@
<EntitySet Name="APPLICATION_FIRMWARE_VERSIONS" EntityType="Self.APPLICATION_FIRMWARE_VERSIONS" store:Type="Tables" />
<EntitySet Name="APPLICATION_OS_VERSIONS" EntityType="Self.APPLICATION_OS_VERSIONS" store:Type="Tables" />
<EntitySet Name="APPLICATION_VERSIONS" EntityType="Self.APPLICATION_VERSIONS" store:Type="Tables" />
+ <EntitySet Name="CARTRIDGE_TYPES" EntityType="Self.CARTRIDGE_TYPES" store:Type="Tables" />
<EntitySet Name="CARTRIDGES" EntityType="Self.CARTRIDGES" store:Type="Tables" />
<EntitySet Name="CONFIGURATIONS" EntityType="Self.CONFIGURATIONS" store:Type="Tables" />
<EntitySet Name="CONFIGURATIONS_DISPENSERS" EntityType="Self.CONFIGURATIONS_DISPENSERS" store:Type="Tables" />
<EntitySet Name="CONTACTS" EntityType="Self.CONTACTS" store:Type="Tables" />
+ <EntitySet Name="DISPENSER_TYPES" EntityType="Self.DISPENSER_TYPES" store:Type="Tables" />
<EntitySet Name="DISPENSERS" EntityType="Self.DISPENSERS" store:Type="Tables" />
<EntitySet Name="EMBEDDED_FIRMWARE_VERSIONS" EntityType="Self.EMBEDDED_FIRMWARE_VERSIONS" store:Type="Tables" />
<EntitySet Name="EMBEDDED_SOFTWARE_VERSIONS" EntityType="Self.EMBEDDED_SOFTWARE_VERSIONS" store:Type="Tables" />
@@ -485,10 +507,12 @@
<EntitySet Name="APPLICATION_FIRMWARE_VERSIONS" EntityType="LocalModel.APPLICATION_FIRMWARE_VERSIONS" />
<EntitySet Name="APPLICATION_OS_VERSIONS" EntityType="LocalModel.APPLICATION_OS_VERSIONS" />
<EntitySet Name="APPLICATION_VERSIONS" EntityType="LocalModel.APPLICATION_VERSIONS" />
+ <EntitySet Name="CARTRIDGE_TYPES" EntityType="LocalModel.CARTRIDGE_TYPES" />
<EntitySet Name="CARTRIDGES" EntityType="LocalModel.CARTRIDGE" />
<EntitySet Name="CONFIGURATIONS" EntityType="LocalModel.CONFIGURATION" />
<EntitySet Name="CONFIGURATIONS_DISPENSERS" EntityType="LocalModel.CONFIGURATIONS_DISPENSERS" />
<EntitySet Name="CONTACTS" EntityType="LocalModel.CONTACT" />
+ <EntitySet Name="DISPENSER_TYPES" EntityType="LocalModel.DISPENSER_TYPES" />
<EntitySet Name="DISPENSERS" EntityType="LocalModel.DISPENSER" />
<EntitySet Name="EMBEDDED_FIRMWARE_VERSIONS" EntityType="LocalModel.EMBEDDED_FIRMWARE_VERSIONS" />
<EntitySet Name="EMBEDDED_SOFTWARE_VERSIONS" EntityType="LocalModel.EMBEDDED_SOFTWARE_VERSIONS" />
@@ -538,7 +562,7 @@
<Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" />
<Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" />
<Property Name="DELETED" Type="Boolean" Nullable="false" />
- <Property Name="ADDRESS1" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" />
+ <Property Name="ADDRESS_STRING" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" />
<Property Name="LOCALITY" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" />
<Property Name="COUNTRY" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" />
<Property Name="CITY" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" />
@@ -582,6 +606,15 @@
<Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" />
<Property Name="DELETED" Type="Boolean" Nullable="false" />
</EntityType>
+ <EntityType Name="CARTRIDGE_TYPES">
+ <Key>
+ <PropertyRef Name="ID" />
+ </Key>
+ <Property Name="ID" Type="Int64" Nullable="false" />
+ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" />
+ <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" />
+ <Property Name="DELETED" Type="Boolean" Nullable="false" />
+ </EntityType>
<EntityType Name="CARTRIDGE">
<Key>
<PropertyRef Name="ID" />
@@ -590,6 +623,7 @@
<Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" />
<Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" />
<Property Name="DELETED" Type="Boolean" Nullable="false" />
+ <Property Name="CARTRIDGE_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" />
</EntityType>
<EntityType Name="CONFIGURATION">
<Key>
@@ -636,6 +670,15 @@
<Property Name="PHONE_NUMBER" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" />
<Property Name="FAX" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" />
</EntityType>
+ <EntityType Name="DISPENSER_TYPES">
+ <Key>
+ <PropertyRef Name="ID" />
+ </Key>
+ <Property Name="ID" Type="Int64" Nullable="false" />
+ <Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" />
+ <Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" />
+ <Property Name="DELETED" Type="Boolean" Nullable="false" />
+ </EntityType>
<EntityType Name="DISPENSER">
<Key>
<PropertyRef Name="ID" />
@@ -644,6 +687,7 @@
<Property Name="GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" />
<Property Name="LAST_UPDATED" Type="DateTime" Nullable="false" />
<Property Name="DELETED" Type="Boolean" Nullable="false" />
+ <Property Name="DISPENSER_TYPE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" />
</EntityType>
<EntityType Name="EMBEDDED_FIRMWARE_VERSIONS">
<Key>
@@ -975,7 +1019,7 @@
<ScalarProperty Name="CITY" ColumnName="CITY" />
<ScalarProperty Name="COUNTRY" ColumnName="COUNTRY" />
<ScalarProperty Name="LOCALITY" ColumnName="LOCALITY" />
- <ScalarProperty Name="ADDRESS1" ColumnName="ADDRESS" />
+ <ScalarProperty Name="ADDRESS_STRING" ColumnName="ADDRESS_STRING" />
<ScalarProperty Name="DELETED" ColumnName="DELETED" />
<ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
<ScalarProperty Name="GUID" ColumnName="GUID" />
@@ -1023,9 +1067,20 @@
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
+ <EntitySetMapping Name="CARTRIDGE_TYPES">
+ <EntityTypeMapping TypeName="LocalModel.CARTRIDGE_TYPES">
+ <MappingFragment StoreEntitySet="CARTRIDGE_TYPES">
+ <ScalarProperty Name="DELETED" ColumnName="DELETED" />
+ <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+ <ScalarProperty Name="GUID" ColumnName="GUID" />
+ <ScalarProperty Name="ID" ColumnName="ID" />
+ </MappingFragment>
+ </EntityTypeMapping>
+ </EntitySetMapping>
<EntitySetMapping Name="CARTRIDGES">
<EntityTypeMapping TypeName="LocalModel.CARTRIDGE">
<MappingFragment StoreEntitySet="CARTRIDGES">
+ <ScalarProperty Name="CARTRIDGE_TYPE_GUID" ColumnName="CARTRIDGE_TYPE_GUID" />
<ScalarProperty Name="DELETED" ColumnName="DELETED" />
<ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
<ScalarProperty Name="GUID" ColumnName="GUID" />
@@ -1081,9 +1136,20 @@
</MappingFragment>
</EntityTypeMapping>
</EntitySetMapping>
+ <EntitySetMapping Name="DISPENSER_TYPES">
+ <EntityTypeMapping TypeName="LocalModel.DISPENSER_TYPES">
+ <MappingFragment StoreEntitySet="DISPENSER_TYPES">
+ <ScalarProperty Name="DELETED" ColumnName="DELETED" />
+ <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
+ <ScalarProperty Name="GUID" ColumnName="GUID" />
+ <ScalarProperty Name="ID" ColumnName="ID" />
+ </MappingFragment>
+ </EntityTypeMapping>
+ </EntitySetMapping>
<EntitySetMapping Name="DISPENSERS">
<EntityTypeMapping TypeName="LocalModel.DISPENSER">
<MappingFragment StoreEntitySet="DISPENSERS">
+ <ScalarProperty Name="DISPENSER_TYPE_GUID" ColumnName="DISPENSER_TYPE_GUID" />
<ScalarProperty Name="DELETED" ColumnName="DELETED" />
<ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
<ScalarProperty Name="GUID" ColumnName="GUID" />