Fixed issue with local sync SQL Logic error.

Added some missing columns to SQLite db.
Direct Remote Sync is fully working !!!

7 files changed, 48 insertions, 0 deletions

diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/FIBER_SHAPES.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/FIBER_SHAPES.cs
index b90db2f5d..5dd3efc31 100644
--- a/Software/Visual_Studio/Tango.DAL.Local/DB/FIBER_SHAPES.cs
+++ b/Software/Visual_Studio/Tango.DAL.Local/DB/FIBER_SHAPES.cs
@@ -18,5 +18,7 @@ namespace Tango.DAL.Local.DB
         public string GUID { get; set; }
         public System.DateTime LAST_UPDATED { get; set; }
         public bool DELETED { get; set; }
+        public string NAME { get; set; }
+        public long CODE { get; set; }
     }
 }
diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/FIBER_SYNTHS.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/FIBER_SYNTHS.cs
index 668872f68..27a67a9fa 100644
--- a/Software/Visual_Studio/Tango.DAL.Local/DB/FIBER_SYNTHS.cs
+++ b/Software/Visual_Studio/Tango.DAL.Local/DB/FIBER_SYNTHS.cs
@@ -18,5 +18,7 @@ namespace Tango.DAL.Local.DB
         public string GUID { get; set; }
         public System.DateTime LAST_UPDATED { get; set; }
         public bool DELETED { get; set; }
+        public string NAME { get; set; }
+        public long CODE { get; set; }
     }
 }
diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/LINEAR_MASS_DENSITY_UNITS.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/LINEAR_MASS_DENSITY_UNITS.cs
index 84cd28833..c0c5ff8c6 100644
--- a/Software/Visual_Studio/Tango.DAL.Local/DB/LINEAR_MASS_DENSITY_UNITS.cs
+++ b/Software/Visual_Studio/Tango.DAL.Local/DB/LINEAR_MASS_DENSITY_UNITS.cs
@@ -18,5 +18,7 @@ namespace Tango.DAL.Local.DB
         public string GUID { get; set; }
         public System.DateTime LAST_UPDATED { get; set; }
         public bool DELETED { get; set; }
+        public string NAME { get; set; }
+        public long CODE { get; set; }
     }
 }
diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx
index 444822fe1..bd3f0e69c 100644
--- a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx
+++ b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx
@@ -235,6 +235,8 @@
           <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="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" />
+          <Property Name="CODE" Type="integer" Nullable="false" />
         </EntityType>
         <EntityType Name="FIBER_SYNTHS">
           <Key>
@@ -244,6 +246,8 @@
           <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="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" />
+          <Property Name="CODE" Type="integer" Nullable="false" />
         </EntityType>
         <EntityType Name="HARDWARE_VERSIONS">
           <Key>
@@ -277,6 +281,8 @@
           <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="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" />
+          <Property Name="CODE" Type="integer" Nullable="false" />
         </EntityType>
         <EntityType Name="LIQUID_TYPES">
           <Key>
@@ -372,6 +378,8 @@
           <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="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" />
+          <Property Name="CODE" Type="integer" Nullable="false" />
         </EntityType>
         <EntityType Name="MEDIA_MATERIALS">
           <Key>
@@ -381,6 +389,8 @@
           <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="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" />
+          <Property Name="CODE" Type="integer" Nullable="false" />
         </EntityType>
         <EntityType Name="MEDIA_PURPOSES">
           <Key>
@@ -390,6 +400,8 @@
           <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="NAME" Type="nvarchar" MaxLength="2147483647" Nullable="false" />
+          <Property Name="CODE" Type="integer" Nullable="false" />
         </EntityType>
         <EntityType Name="ORGANIZATIONS">
           <Key>
@@ -819,6 +831,8 @@
           <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="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" />
+          <Property Name="CODE" Type="Int64" Nullable="false" />
         </EntityType>
         <EntityType Name="FIBER_SYNTHS">
           <Key>
@@ -828,6 +842,8 @@
           <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="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" />
+          <Property Name="CODE" Type="Int64" Nullable="false" />
         </EntityType>
         <EntityType Name="HARDWARE_VERSIONS">
           <Key>
@@ -861,6 +877,8 @@
           <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="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" />
+          <Property Name="CODE" Type="Int64" Nullable="false" />
         </EntityType>
         <EntityType Name="LIQUID_TYPES">
           <Key>
@@ -956,6 +974,8 @@
           <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="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" />
+          <Property Name="CODE" Type="Int64" Nullable="false" />
         </EntityType>
         <EntityType Name="MEDIA_MATERIALS">
           <Key>
@@ -965,6 +985,8 @@
           <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="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" />
+          <Property Name="CODE" Type="Int64" Nullable="false" />
         </EntityType>
         <EntityType Name="MEDIA_PURPOSES">
           <Key>
@@ -974,6 +996,8 @@
           <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="NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" />
+          <Property Name="CODE" Type="Int64" Nullable="false" />
         </EntityType>
         <EntityType Name="ORGANIZATION">
           <Key>
@@ -1332,6 +1356,8 @@
           <EntitySetMapping Name="FIBER_SHAPES">
             <EntityTypeMapping TypeName="LocalModel.FIBER_SHAPES">
               <MappingFragment StoreEntitySet="FIBER_SHAPES">
+                <ScalarProperty Name="CODE" ColumnName="CODE" />
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
                 <ScalarProperty Name="DELETED" ColumnName="DELETED" />
                 <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
                 <ScalarProperty Name="GUID" ColumnName="GUID" />
@@ -1342,6 +1368,8 @@
           <EntitySetMapping Name="FIBER_SYNTHS">
             <EntityTypeMapping TypeName="LocalModel.FIBER_SYNTHS">
               <MappingFragment StoreEntitySet="FIBER_SYNTHS">
+                <ScalarProperty Name="CODE" ColumnName="CODE" />
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
                 <ScalarProperty Name="DELETED" ColumnName="DELETED" />
                 <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
                 <ScalarProperty Name="GUID" ColumnName="GUID" />
@@ -1378,6 +1406,8 @@
           <EntitySetMapping Name="LINEAR_MASS_DENSITY_UNITS">
             <EntityTypeMapping TypeName="LocalModel.LINEAR_MASS_DENSITY_UNITS">
               <MappingFragment StoreEntitySet="LINEAR_MASS_DENSITY_UNITS">
+                <ScalarProperty Name="CODE" ColumnName="CODE" />
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
                 <ScalarProperty Name="DELETED" ColumnName="DELETED" />
                 <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
                 <ScalarProperty Name="GUID" ColumnName="GUID" />
@@ -1481,6 +1511,8 @@
           <EntitySetMapping Name="MEDIA_CONDITIONS">
             <EntityTypeMapping TypeName="LocalModel.MEDIA_CONDITIONS">
               <MappingFragment StoreEntitySet="MEDIA_CONDITIONS">
+                <ScalarProperty Name="CODE" ColumnName="CODE" />
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
                 <ScalarProperty Name="DELETED" ColumnName="DELETED" />
                 <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
                 <ScalarProperty Name="GUID" ColumnName="GUID" />
@@ -1491,6 +1523,8 @@
           <EntitySetMapping Name="MEDIA_MATERIALS">
             <EntityTypeMapping TypeName="LocalModel.MEDIA_MATERIALS">
               <MappingFragment StoreEntitySet="MEDIA_MATERIALS">
+                <ScalarProperty Name="CODE" ColumnName="CODE" />
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
                 <ScalarProperty Name="DELETED" ColumnName="DELETED" />
                 <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
                 <ScalarProperty Name="GUID" ColumnName="GUID" />
@@ -1501,6 +1535,8 @@
           <EntitySetMapping Name="MEDIA_PURPOSES">
             <EntityTypeMapping TypeName="LocalModel.MEDIA_PURPOSES">
               <MappingFragment StoreEntitySet="MEDIA_PURPOSES">
+                <ScalarProperty Name="CODE" ColumnName="CODE" />
+                <ScalarProperty Name="NAME" ColumnName="NAME" />
                 <ScalarProperty Name="DELETED" ColumnName="DELETED" />
                 <ScalarProperty Name="LAST_UPDATED" ColumnName="LAST_UPDATED" />
                 <ScalarProperty Name="GUID" ColumnName="GUID" />
diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/MEDIA_CONDITIONS.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/MEDIA_CONDITIONS.cs
index 43a07a2a8..368913189 100644
--- a/Software/Visual_Studio/Tango.DAL.Local/DB/MEDIA_CONDITIONS.cs
+++ b/Software/Visual_Studio/Tango.DAL.Local/DB/MEDIA_CONDITIONS.cs
@@ -18,5 +18,7 @@ namespace Tango.DAL.Local.DB
         public string GUID { get; set; }
         public System.DateTime LAST_UPDATED { get; set; }
         public bool DELETED { get; set; }
+        public string NAME { get; set; }
+        public long CODE { get; set; }
     }
 }
diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/MEDIA_MATERIALS.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/MEDIA_MATERIALS.cs
index d2726980e..fdf51b12e 100644
--- a/Software/Visual_Studio/Tango.DAL.Local/DB/MEDIA_MATERIALS.cs
+++ b/Software/Visual_Studio/Tango.DAL.Local/DB/MEDIA_MATERIALS.cs
@@ -18,5 +18,7 @@ namespace Tango.DAL.Local.DB
         public string GUID { get; set; }
         public System.DateTime LAST_UPDATED { get; set; }
         public bool DELETED { get; set; }
+        public string NAME { get; set; }
+        public long CODE { get; set; }
     }
 }
diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/MEDIA_PURPOSES.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/MEDIA_PURPOSES.cs
index f335c2949..15ea7c140 100644
--- a/Software/Visual_Studio/Tango.DAL.Local/DB/MEDIA_PURPOSES.cs
+++ b/Software/Visual_Studio/Tango.DAL.Local/DB/MEDIA_PURPOSES.cs
@@ -18,5 +18,7 @@ namespace Tango.DAL.Local.DB
         public string GUID { get; set; }
         public System.DateTime LAST_UPDATED { get; set; }
         public bool DELETED { get; set; }
+        public string NAME { get; set; }
+        public long CODE { get; set; }
     }
 }