Fixed an issue with boolean values on local DB sync.

Added support for SYNC_CONFIGURATION table on for local DB sync.
Fixed an issue with multiple row updates on remote DB sync.
Added warning for missing destination property on remote DB sync.
Throw exception when no remote machine found on remote DB sync.

4 files changed, 52 insertions, 2 deletions

diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.Context.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.Context.cs
index 272713cc6..f27e0af4d 100644
--- a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.Context.cs
+++ b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.Context.cs
@@ -60,6 +60,7 @@ namespace Tango.DAL.Local.DB
         public virtual DbSet<RML> RMLS { get; set; }
         public virtual DbSet<ROLE> ROLES { get; set; }
         public virtual DbSet<ROLES_PERMISSIONS> ROLES_PERMISSIONS { get; set; }
+        public virtual DbSet<SYNC_CONFIGURATION> SYNC_CONFIGURATION { get; set; }
         public virtual DbSet<USER> USERS { get; set; }
         public virtual DbSet<USERS_ROLES> USERS_ROLES { 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 87d14f58b..1bd77ac1d 100644
--- a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx
+++ b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx
@@ -401,6 +401,14 @@
           <Property Name="ROLE_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" />
           <Property Name="PERMISSION_GUID" Type="nvarchar" MaxLength="2147483647" Nullable="false" />
         </EntityType>
+        <EntityType Name="SYNC_CONFIGURATION">
+          <Key>
+            <PropertyRef Name="ID" />
+          </Key>
+          <Property Name="ID" Type="integer" Nullable="false" />
+          <Property Name="TABLE_NAME" Type="varchar" MaxLength="2147483647" Nullable="false" />
+          <Property Name="SYNC_TYPE" Type="integer" Nullable="false" />
+        </EntityType>
         <EntityType Name="USERS">
           <Key>
             <PropertyRef Name="ID" />
@@ -462,6 +470,7 @@
           <EntitySet Name="RMLS" EntityType="Self.RMLS" store:Type="Tables" />
           <EntitySet Name="ROLES" EntityType="Self.ROLES" store:Type="Tables" />
           <EntitySet Name="ROLES_PERMISSIONS" EntityType="Self.ROLES_PERMISSIONS" store:Type="Tables" />
+          <EntitySet Name="SYNC_CONFIGURATION" EntityType="Self.SYNC_CONFIGURATION" store:Type="Tables" />
           <EntitySet Name="USERS" EntityType="Self.USERS" store:Type="Tables" />
           <EntitySet Name="USERS_ROLES" EntityType="Self.USERS_ROLES" store:Type="Tables" />
         </EntityContainer>
@@ -505,6 +514,7 @@
           <EntitySet Name="RMLS" EntityType="LocalModel.RML" />
           <EntitySet Name="ROLES" EntityType="LocalModel.ROLE" />
           <EntitySet Name="ROLES_PERMISSIONS" EntityType="LocalModel.ROLES_PERMISSIONS" />
+          <EntitySet Name="SYNC_CONFIGURATION" EntityType="LocalModel.SYNC_CONFIGURATION" />
           <EntitySet Name="USERS" EntityType="LocalModel.USER" />
           <EntitySet Name="USERS_ROLES" EntityType="LocalModel.USERS_ROLES" />
         </EntityContainer>
@@ -904,6 +914,14 @@
           <Property Name="ROLE_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" />
           <Property Name="PERMISSION_GUID" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="true" />
         </EntityType>
+        <EntityType Name="SYNC_CONFIGURATION">
+          <Key>
+            <PropertyRef Name="ID" />
+          </Key>
+          <Property Name="ID" Type="Int64" Nullable="false" />
+          <Property Name="TABLE_NAME" Type="String" Nullable="false" MaxLength="2147483647" FixedLength="false" Unicode="false" />
+          <Property Name="SYNC_TYPE" Type="Int64" Nullable="false" />
+        </EntityType>
         <EntityType Name="USER">
           <Key>
             <PropertyRef Name="ID" />
@@ -1366,6 +1384,15 @@
               </MappingFragment>
             </EntityTypeMapping>
           </EntitySetMapping>
+          <EntitySetMapping Name="SYNC_CONFIGURATION">
+            <EntityTypeMapping TypeName="LocalModel.SYNC_CONFIGURATION">
+              <MappingFragment StoreEntitySet="SYNC_CONFIGURATION">
+                <ScalarProperty Name="SYNC_TYPE" ColumnName="SYNC_TYPE" />
+                <ScalarProperty Name="TABLE_NAME" ColumnName="TABLE_NAME" />
+                <ScalarProperty Name="ID" ColumnName="ID" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
           <EntitySetMapping Name="USERS">
             <EntityTypeMapping TypeName="LocalModel.USER">
               <MappingFragment StoreEntitySet="USERS">
diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx.diagram b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx.diagram
index b814cf058..1062722a0 100644
--- a/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx.diagram
+++ b/Software/Visual_Studio/Tango.DAL.Local/DB/LocalADO.edmx.diagram
@@ -40,8 +40,9 @@
         <EntityTypeShape EntityType="LocalModel.RML" Width="1.5" PointX="14.75" PointY="6.75" />
         <EntityTypeShape EntityType="LocalModel.ROLE" Width="1.5" PointX="10.75" PointY="14.75" />
         <EntityTypeShape EntityType="LocalModel.ROLES_PERMISSIONS" Width="1.5" PointX="14.75" PointY="12.75" />
-        <EntityTypeShape EntityType="LocalModel.USER" Width="1.5" PointX="2.75" PointY="15.75" />
-        <EntityTypeShape EntityType="LocalModel.USERS_ROLES" Width="1.5" PointX="12.75" PointY="15.75" />
+        <EntityTypeShape EntityType="LocalModel.SYNC_CONFIGURATION" Width="1.5" PointX="2.75" PointY="15.75" />
+        <EntityTypeShape EntityType="LocalModel.USER" Width="1.5" PointX="12.75" PointY="15.75" />
+        <EntityTypeShape EntityType="LocalModel.USERS_ROLES" Width="1.5" PointX="14.75" PointY="15.75" />
       </Diagram>
     </edmx:Diagrams>
   </edmx:Designer>
diff --git a/Software/Visual_Studio/Tango.DAL.Local/DB/SYNC_CONFIGURATION.cs b/Software/Visual_Studio/Tango.DAL.Local/DB/SYNC_CONFIGURATION.cs
new file mode 100644
index 000000000..ab7b23673
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Local/DB/SYNC_CONFIGURATION.cs
@@ -0,0 +1,21 @@
+//------------------------------------------------------------------------------
+// <auto-generated>
+//     This code was generated from a template.
+//
+//     Manual changes to this file may cause unexpected behavior in your application.
+//     Manual changes to this file will be overwritten if the code is regenerated.
+// </auto-generated>
+//------------------------------------------------------------------------------
+
+namespace Tango.DAL.Local.DB
+{
+    using System;
+    using System.Collections.Generic;
+    
+    public partial class SYNC_CONFIGURATION
+    {
+        public long ID { get; set; }
+        public string TABLE_NAME { get; set; }
+        public long SYNC_TYPE { get; set; }
+    }
+}