Started working on Sql Dependency and EF Cache.

17 files changed, 161 insertions, 268 deletions

diff --git a/Software/Visual_Studio/Build/Shortcuts/Machine Emulator.lnk b/Software/Visual_Studio/Build/Shortcuts/Machine Emulator.lnk
index da66ca4e4..c1a7c4645 100644
--- a/Software/Visual_Studio/Build/Shortcuts/Machine Emulator.lnk
+++ b/Software/Visual_Studio/Build/Shortcuts/Machine Emulator.lnk
diff --git a/Software/Visual_Studio/Build/Shortcuts/Machine Studio.lnk b/Software/Visual_Studio/Build/Shortcuts/Machine Studio.lnk
index 456dac5c1..6351490f4 100644
--- a/Software/Visual_Studio/Build/Shortcuts/Machine Studio.lnk
+++ b/Software/Visual_Studio/Build/Shortcuts/Machine Studio.lnk
diff --git a/Software/Visual_Studio/Build/Shortcuts/Proto Compiler GUI.lnk b/Software/Visual_Studio/Build/Shortcuts/Proto Compiler GUI.lnk
index df5f34b99..01ddb6f1d 100644
--- a/Software/Visual_Studio/Build/Shortcuts/Proto Compiler GUI.lnk
+++ b/Software/Visual_Studio/Build/Shortcuts/Proto Compiler GUI.lnk
diff --git a/Software/Visual_Studio/Build/Shortcuts/Stubs Execution GUI.lnk b/Software/Visual_Studio/Build/Shortcuts/Stubs Execution GUI.lnk
index 41d0606ed..ad04a1368 100644
--- a/Software/Visual_Studio/Build/Shortcuts/Stubs Execution GUI.lnk
+++ b/Software/Visual_Studio/Build/Shortcuts/Stubs Execution GUI.lnk
diff --git a/Software/Visual_Studio/Build/Shortcuts/Transport Router.lnk b/Software/Visual_Studio/Build/Shortcuts/Transport Router.lnk
index a4d815d5a..20367c999 100644
--- a/Software/Visual_Studio/Build/Shortcuts/Transport Router.lnk
+++ b/Software/Visual_Studio/Build/Shortcuts/Transport Router.lnk
diff --git a/Software/Visual_Studio/Notes/Tango.Notes/DB/SQL Dependency.txt b/Software/Visual_Studio/Notes/Tango.Notes/DB/SQL Dependency.txt
new file mode 100644
index 000000000..d46f10bd7
--- /dev/null
+++ b/Software/Visual_Studio/Notes/Tango.Notes/DB/SQL Dependency.txt
@@ -0,0 +1,18 @@
+-- Set user as db owner --
+USE Tango
+GO
+SP_DROPUSER Developer
+GO
+SP_CHANGEDBOWNER Developer
+
+
+-- Maybe this one also ? --
+ALTER AUTHORIZATION ON DATABASE::Tango TO Developer;
+
+
+-- Get state of broker service on each database --
+SELECT NAME, IS_BROKER_ENABLED FROM SYS.DATABASES
+
+
+-- Enable broker service --
+ALTER DATABASE Tango SET ENABLE_BROKER;
\ No newline at end of file
diff --git a/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj b/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj
index e2f081fd0..2ce33c1c4 100644
--- a/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj
+++ b/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj
@@ -46,6 +46,7 @@
     <Content Include="Advanced Installer\License.txt" />
     <Content Include="Azure\Test User Credentials.txt" />
     <Content Include="Azure\SQL Database.txt" />
+    <Content Include="DB\SQL Dependency.txt" />
     <Content Include="PPC\Remote Debugging.txt" />
     <Content Include="PPC\Virtual Flash Drive.txt" />
     <Content Include="PPC\Windows 10 LTSB.txt" />
@@ -56,7 +57,7 @@
   <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
   <ProjectExtensions>
     <VisualStudio>
-      <UserProperties BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UseGlobalSettings="False" BuildVersion_StartDate="2000/1/1" />
+      <UserProperties BuildVersion_StartDate="2000/1/1" BuildVersion_UseGlobalSettings="False" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" />
     </VisualStudio>
   </ProjectExtensions>
 </Project>
\ No newline at end of file
diff --git a/Software/Visual_Studio/PPC/Tango.PPC.UI/app.manifest b/Software/Visual_Studio/PPC/Tango.PPC.UI/app.manifest
index d72e75011..efc5f8179 100644
--- a/Software/Visual_Studio/PPC/Tango.PPC.UI/app.manifest
+++ b/Software/Visual_Studio/PPC/Tango.PPC.UI/app.manifest
@@ -16,7 +16,7 @@
             Remove this element if your application requires this virtualization for backwards
             compatibility.
         -->
-        <requestedExecutionLevel level="requireAdministrator" uiAccess="false" />
+        <!--<requestedExecutionLevel level="requireAdministrator" uiAccess="false" />-->
       </requestedPrivileges>
     </security>
   </trustInfo>
diff --git a/Software/Visual_Studio/Tango.BL/Enumerations/FiberSynthes.cs b/Software/Visual_Studio/Tango.BL/Enumerations/FiberSynthes.cs
deleted file mode 100644
index 4bc13b83a..000000000
--- a/Software/Visual_Studio/Tango.BL/Enumerations/FiberSynthes.cs
+++ /dev/null
@@ -1,12 +0,0 @@
-using System;
-using System.Collections.Generic;
-using System.Collections.ObjectModel;
-using System.Linq;
-using System.ComponentModel;
-
-namespace Tango.DAL.Observables
-{
-    public enum FiberSynthes
-    {
-    }
-}
diff --git a/Software/Visual_Studio/Tango.BL/Enumerations/FiberSynthesises.cs b/Software/Visual_Studio/Tango.BL/Enumerations/FiberSynthesises.cs
deleted file mode 100644
index 04b6033ae..000000000
--- a/Software/Visual_Studio/Tango.BL/Enumerations/FiberSynthesises.cs
+++ /dev/null
@@ -1,12 +0,0 @@
-using System;
-using System.Collections.Generic;
-using System.Collections.ObjectModel;
-using System.Linq;
-using System.ComponentModel;
-
-namespace Tango.BL.Entities
-{
-    public enum FiberSynthesises
-    {
-    }
-}
diff --git a/Software/Visual_Studio/Tango.BL/Enumerations/Graphs.cs b/Software/Visual_Studio/Tango.BL/Enumerations/Graphs.cs
deleted file mode 100644
index 798844351..000000000
--- a/Software/Visual_Studio/Tango.BL/Enumerations/Graphs.cs
+++ /dev/null
@@ -1,181 +0,0 @@
-using System;
-using System.Collections.Generic;
-using System.Collections.ObjectModel;
-using System.Linq;
-using System.ComponentModel;
-
-namespace Tango.Integration.Observables
-{
-    public enum Graphs
-    {
-
-        /// <summary>
-        /// (Dancer 1)
-        /// </summary>
-        [Description("Dancer 1")]
-        Dancer1Angle = 0,
-
-        /// <summary>
-        /// (Dancer 2)
-        /// </summary>
-        [Description("Dancer 2")]
-        Dancer2Angle = 1,
-
-        /// <summary>
-        /// (Dancer 3)
-        /// </summary>
-        [Description("Dancer 3")]
-        Dancer3Angle = 2,
-
-        /// <summary>
-        /// (Feeder Motor)
-        /// </summary>
-        [Description("Feeder Motor")]
-        FeederMotorFrequency = 3,
-
-        /// <summary>
-        /// (Dryer Motor)
-        /// </summary>
-        [Description("Dryer Motor")]
-        DryerMotor = 4,
-
-        /// <summary>
-        /// (Poller Motor)
-        /// </summary>
-        [Description("Poller Motor")]
-        PollerMotor = 5,
-
-        /// <summary>
-        /// (Winder Motor)
-        /// </summary>
-        [Description("Winder Motor")]
-        WinderMotor = 6,
-
-        /// <summary>
-        /// (Screw Motor)
-        /// </summary>
-        [Description("Screw Motor")]
-        ScrewMotor = 7,
-
-        /// <summary>
-        /// (Thread Speed)
-        /// </summary>
-        [Description("Thread Speed")]
-        ThreadSpeed = 8,
-
-        /// <summary>
-        /// (Mixer)
-        /// </summary>
-        [Description("Mixer")]
-        MixerTemperature = 9,
-
-        /// <summary>
-        /// (Head Zone 1)
-        /// </summary>
-        [Description("Head Zone 1")]
-        HeadZone1Temperature = 10,
-
-        /// <summary>
-        /// (Head Zone 2)
-        /// </summary>
-        [Description("Head Zone 2")]
-        HeadZone2Temperature = 11,
-
-        /// <summary>
-        /// (Head Zone 3)
-        /// </summary>
-        [Description("Head Zone 3")]
-        HeadZone3Temperature = 12,
-
-        /// <summary>
-        /// (Head Air Flow)
-        /// </summary>
-        [Description("Head Air Flow")]
-        HeadAirFlow = 13,
-
-        /// <summary>
-        /// (Feeder Tension)
-        /// </summary>
-        [Description("Feeder Tension")]
-        FeederTension = 14,
-
-        /// <summary>
-        /// (Puller Tension)
-        /// </summary>
-        [Description("Puller Tension")]
-        PullerTension = 15,
-
-        /// <summary>
-        /// (Dryer Zone 1)
-        /// </summary>
-        [Description("Dryer Zone 1")]
-        DryerZone1Temperature = 16,
-
-        /// <summary>
-        /// (Dryer Zone 2)
-        /// </summary>
-        [Description("Dryer Zone 2")]
-        DryerZone2Temperature = 17,
-
-        /// <summary>
-        /// (Dryer Zone 3)
-        /// </summary>
-        [Description("Dryer Zone 3")]
-        DryerZone3Temperature = 18,
-
-        /// <summary>
-        /// (Dryer Air Flow)
-        /// </summary>
-        [Description("Dryer Air Flow")]
-        DryerAirFlow = 19,
-
-        /// <summary>
-        /// (Winder Tension)
-        /// </summary>
-        [Description("Winder Tension")]
-        WinderTension = 20,
-
-        /// <summary>
-        /// (Dispensers Motors)
-        /// </summary>
-        [Description("Dispensers Motors")]
-        DispensersMotorsFrequency = 21,
-
-        /// <summary>
-        /// (Dispensers Angular Encoders)
-        /// </summary>
-        [Description("Dispensers Angular Encoders")]
-        DispensersAngularEncoders = 22,
-
-        /// <summary>
-        /// (Dispensers Linear Positions)
-        /// </summary>
-        [Description("Dispensers Linear Positions")]
-        DispensersLinearPositions = 23,
-
-        /// <summary>
-        /// (Dispensers Pressure)
-        /// </summary>
-        [Description("Dispensers Pressure")]
-        DispensersPressure = 24,
-
-        /// <summary>
-        /// (Mid Tank Pressure)
-        /// </summary>
-        [Description("Mid Tank Pressure")]
-        MidTankPressure = 25,
-
-        /// <summary>
-        /// (Filter Delta Pressure)
-        /// </summary>
-        [Description("Filter Delta Pressure")]
-        FilterDeltaPressure = 26,
-
-        /// <summary>
-        /// (Chiller Temperature)
-        /// </summary>
-        [Description("Chiller Temperature")]
-        ChillerTemperature = 27,
-
-    }
-}
diff --git a/Software/Visual_Studio/Tango.BL/Enumerations/HtmlPages.cs b/Software/Visual_Studio/Tango.BL/Enumerations/HtmlPages.cs
deleted file mode 100644
index b2104990a..000000000
--- a/Software/Visual_Studio/Tango.BL/Enumerations/HtmlPages.cs
+++ /dev/null
@@ -1,29 +0,0 @@
-//------------------------------------------------------------------------------
-// <auto-generated>
-// This code was generated by a tool.
-// Tango Observables Generator
-// 
-// Changes to this file may cause incorrect behavior and will be lost if
-// the code is regenerated. Do not modify!
-// </auto-generated>
-//------------------------------------------------------------------------------
-
-using System;
-using System.Collections.Generic;
-using System.Collections.ObjectModel;
-using System.Linq;
-using System.ComponentModel;
-
-namespace Tango.BL.Enumerations
-{
-    public enum HtmlPages
-    {
-
-        /// <summary>
-        /// (Some Test Guide)
-        /// </summary>
-        [Description("Some Test Guide")]
-        Test = 0,
-
-    }
-}
diff --git a/Software/Visual_Studio/Tango.BL/Tango.BL.csproj b/Software/Visual_Studio/Tango.BL/Tango.BL.csproj
index c08729ef9..61118b6b0 100644
--- a/Software/Visual_Studio/Tango.BL/Tango.BL.csproj
+++ b/Software/Visual_Studio/Tango.BL/Tango.BL.csproj
@@ -349,10 +349,8 @@
     <Compile Include="Enumerations\EventTypes.cs" />
     <Compile Include="Enumerations\EventTypeCategories.cs" />
     <Compile Include="Enumerations\EventTypeGroups.cs" />
-    <Compile Include="Enumerations\FiberSynthes.cs" />
     <Compile Include="Enumerations\FiberSynths.cs" />
     <Compile Include="Enumerations\FineTuningStatuses.cs" />
-    <Compile Include="Enumerations\Graphs.cs" />
     <Compile Include="Enumerations\HardwareBlowerTypes.cs" />
     <Compile Include="Enumerations\HardwareBreakSensorTypes.cs" />
     <Compile Include="Enumerations\HardwareDancerTypes.cs" />
@@ -360,7 +358,6 @@
     <Compile Include="Enumerations\HardwarePidControlTypes.cs" />
     <Compile Include="Enumerations\HardwareSpeedSensorTypes.cs" />
     <Compile Include="Enumerations\HardwareWinderTypes.cs" />
-    <Compile Include="Enumerations\HtmlPages.cs" />
     <Compile Include="Enumerations\Ios.cs" />
     <Compile Include="Enumerations\JobDesignations.cs" />
     <Compile Include="Enumerations\JobRunStatus.cs" />
@@ -445,7 +442,6 @@
     <Compile Include="Enumerations\DispenserTypes.cs" />
     <Compile Include="Enumerations\Events.cs" />
     <Compile Include="Enumerations\FiberShapes.cs" />
-    <Compile Include="Enumerations\FiberSynthesises.cs" />
     <Compile Include="Enumerations\IdsPackFormulas.cs" />
     <Compile Include="Enumerations\IOType.cs" />
     <Compile Include="Enumerations\LinearMassDensityUnits.cs" />
@@ -549,7 +545,7 @@
   </Target>
   <ProjectExtensions>
     <VisualStudio>
-      <UserProperties BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UseGlobalSettings="False" BuildVersion_StartDate="2000/1/1" />
+      <UserProperties BuildVersion_StartDate="2000/1/1" BuildVersion_UseGlobalSettings="False" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" />
     </VisualStudio>
   </ProjectExtensions>
 </Project>
\ No newline at end of file
diff --git a/Software/Visual_Studio/Utilities/Tango.UITests/MainWindow.xaml b/Software/Visual_Studio/Utilities/Tango.UITests/MainWindow.xaml
index d9180c4dd..6c1f5ed51 100644
--- a/Software/Visual_Studio/Utilities/Tango.UITests/MainWindow.xaml
+++ b/Software/Visual_Studio/Utilities/Tango.UITests/MainWindow.xaml
@@ -21,6 +21,7 @@
             <TextBlock HorizontalAlignment="Center" Margin="0 0 0 10" x:Name="txtStatus"></TextBlock>
             <ProgressBar x:Name="prog" VerticalAlignment="Center" Height="15" Width="700"></ProgressBar>
             <Button x:Name="btnStart" Click="btnStart_Click" HorizontalAlignment="Center" Padding="30 10" Margin="0 10 0 0">START</Button>
+            <Button x:Name="btnChange" Click="btnChange_Click" HorizontalAlignment="Center" Padding="30 10" Margin="0 10 0 0">CHANGE</Button>
         </StackPanel>
     </Grid>
 </Window>
diff --git a/Software/Visual_Studio/Utilities/Tango.UITests/MainWindow.xaml.cs b/Software/Visual_Studio/Utilities/Tango.UITests/MainWindow.xaml.cs
index e2b4586db..4ac7bffa2 100644
--- a/Software/Visual_Studio/Utilities/Tango.UITests/MainWindow.xaml.cs
+++ b/Software/Visual_Studio/Utilities/Tango.UITests/MainWindow.xaml.cs
@@ -1,4 +1,5 @@
-using Microsoft.Win32;
+using EFCache;
+using Microsoft.Win32;
 using System;
 using System.Collections.Generic;
 using System.Collections.ObjectModel;
@@ -28,6 +29,13 @@ using Tango.FirmwareUpdateLib;
 using Tango.FirmwareUpdateLib.WPF;
 using Tango.Logging;
 using Tango.SharedUI;
+using Tango.Web;
+using System.Data;
+using System.Data.SqlClient;
+using System.Security.Permissions;
+using TableDependency.SqlClient.Base;
+using TableDependency.SqlClient;
+using TableDependency.SqlClient.Base.EventArgs;
 
 namespace Tango.UITests
 {
@@ -36,45 +44,120 @@ namespace Tango.UITests
     /// </summary>
     public partial class MainWindow : Window
     {
-        private FirmwareUpgradeManager manager;
-
         public MainWindow()
         {
             InitializeComponent();
+            EntityFrameworkCache.Initialize(new InMemoryCache());
 
-            LogManager.Default.RegisterLogger(new VSOutputLogger());
 
-            manager = new FirmwareUpgradeManager();
-            manager.UpgradeProgress += Manager_UpgradeProgress;
         }
 
-        private void Manager_UpgradeProgress(object sender, FirmwareUpgradeProgressEventArgs e)
+        private static string _con = "data source=localhost\\SQLEXPRESS; initial catalog=Tango; integrated security=False;User Id=SqlDependency;Password=Aa123456";
+
+
+        private void btnStart_Click(object sender, RoutedEventArgs e)
         {
-            Dispatcher.Invoke(new Action(() =>
-            {
-                txtStatus.Text = e.State.ToDescription();
-                prog.Maximum = e.Total;
-                prog.Value = e.Progress;
-            }));
+            //var dataSource = new DataSource()
+            //{
+            //    Address = "localhost\\SQLEXPRESS",
+            //    Catalog = "Tango",
+            //    Type = DataSourceType.SQLServer,
+            //    IntegratedSecurity = false,
+            //    UserName = "Developer",
+            //    Password = "Aa123456",
+            //};
+
+            //var connection = dataSource.ToConnection();
+
+            String str = _con;
+
+            //var mapper = new ModelToTableMapper<User>();
+            //mapper.AddMapping(c => c.ID, "ID");
+            //mapper.AddMapping(c => c.Email, "EMAIL");
+
+            var dep = new SqlTableDependency<DAL.Remote.DB.USER>(str, "USERS", "dbo");
+            dep.TraceLevel = TraceLevel.Verbose;
+            dep.TraceListener = new TextWriterTraceListener(Console.Out); 
+
+            dep.OnChanged += Changed;
+            dep.Start();
+
+            //SqlClientPermission clientPermission =
+            //       new SqlClientPermission(PermissionState.Unrestricted);
+            //clientPermission.Demand();
+
+            //System.Data.SqlClient.SqlDependency.Start(str);
+
+            //String commandText = "SELECT [dbo].[USERS].[EMAIL] FROM [dbo].[USERS];";
+            //SqlCommand command = new SqlCommand(commandText, connection as SqlConnection);
+            //command.Notification = null;
+            //command.CommandType = CommandType.Text;
+
+            //command.Connection.Open();
 
-            Application.Current.Dispatcher.Invoke(DispatcherPriority.Background,
-                                                 new Action(delegate { }));
+            //SqlDependency dependency = new SqlDependency(command);
+            //dependency.OnChange += (s, args) =>
+            //{
+
+            //};
+
+            //command.ExecuteReader();
+            //String a = "!23";
+
+            //Stopwatch watch = Stopwatch.StartNew();
+
+            //using (ObservablesContext db = ObservablesContext.CreateDefault(new DataSource()
+            //{
+            //    Address = "localhost\\SQLEXPRESS",
+            //    Catalog = "Tango",
+            //    Type = DataSourceType.SQLServer,
+            //    UserName = "Roy",
+            //    Password = "Aa123456",
+            //    IntegratedSecurity = true,
+            //}))
+            //{
+            //    var users = db.Users.ToList();
+            //    var jobs = new JobsCollectionBuilder(db).SetAll().WithSegments().WithBrushStops().Build();
+            //    var first_job = jobs.First();
+
+            //    if (first_job.Name == "Changed Name 2")
+            //    {
+            //        Debug.WriteLine("Changed and cached !!!");
+            //    }
+            //    else
+            //    {
+            //        Debug.WriteLine("Not working.");
+            //    }
+            //}
+
+            //Debug.WriteLine($"Time to complete: {watch.Elapsed.TotalSeconds} seconds");
         }
 
-        private async void btnStart_Click(object sender, RoutedEventArgs e)
+        private void Changed(object sender, RecordChangedEventArgs<DAL.Remote.DB.USER> e)
         {
-            try
+            var changedEntity = e.Entity;
+
+            Console.WriteLine("DML operation: " + e.ChangeType);
+
+            Console.WriteLine(changedEntity.ToJsonString());
+        }
+
+        private void btnChange_Click(object sender, RoutedEventArgs e)
+        {
+            using (ObservablesContext db = ObservablesContext.CreateDefault(new DataSource()
             {
-                OpenFileDialog dlg = new OpenFileDialog();
-                if (dlg.ShowDialog().Value)
-                {
-                    //await manager.PerformUpgrade(dlg.FileName);
-                    MessageBox.Show("Completed !");
-                }
-            }
-            catch (Exception ex)
+                Address = "twine.database.windows.net",
+                Catalog = "Tango_DEV",
+                Type = DataSourceType.SQLServer,
+                UserName = "Roy",
+                Password = "Aa123456",
+                IntegratedSecurity = false,
+            }))
             {
-                MessageBox.Show(ex.ToString());
+                var jobs = new JobsCollectionBuilder(db).SetAll().WithSegments().WithBrushStops().Build();
+                var first_job = jobs.First();
+                first_job.Name = "Changed Name 2";
+                db.SaveChanges();
             }
         }
     }
diff --git a/Software/Visual_Studio/Utilities/Tango.UITests/Tango.UITests.csproj b/Software/Visual_Studio/Utilities/Tango.UITests/Tango.UITests.csproj
index dd160e480..7daf19294 100644
--- a/Software/Visual_Studio/Utilities/Tango.UITests/Tango.UITests.csproj
+++ b/Software/Visual_Studio/Utilities/Tango.UITests/Tango.UITests.csproj
@@ -34,6 +34,9 @@
     <WarningLevel>4</WarningLevel>
   </PropertyGroup>
   <ItemGroup>
+    <Reference Include="EFCache, Version=1.1.3.0, Culture=neutral, PublicKeyToken=46c4868af4307d2c, processorArchitecture=MSIL">
+      <HintPath>..\..\packages\EntityFramework.Cache.1.1.3\lib\net45\EFCache.dll</HintPath>
+    </Reference>
     <Reference Include="EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, processorArchitecture=MSIL">
       <HintPath>..\..\packages\EntityFramework.6.2.0\lib\net45\EntityFramework.dll</HintPath>
     </Reference>
@@ -47,8 +50,17 @@
       <HintPath>..\..\packages\MahApps.Metro.1.5.0\lib\net45\MahApps.Metro.dll</HintPath>
     </Reference>
     <Reference Include="System" />
+    <Reference Include="System.ComponentModel.Annotations, Version=4.2.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL">
+      <HintPath>..\..\packages\System.ComponentModel.Annotations.4.4.0\lib\net461\System.ComponentModel.Annotations.dll</HintPath>
+    </Reference>
     <Reference Include="System.ComponentModel.DataAnnotations" />
     <Reference Include="System.Data" />
+    <Reference Include="System.Data.Common, Version=4.1.1.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL">
+      <HintPath>..\..\packages\System.Data.Common.4.3.0\lib\net451\System.Data.Common.dll</HintPath>
+    </Reference>
+    <Reference Include="System.Data.SqlClient, Version=4.1.1.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a, processorArchitecture=MSIL">
+      <HintPath>..\..\packages\System.Data.SqlClient.4.3.0\lib\net46\System.Data.SqlClient.dll</HintPath>
+    </Reference>
     <Reference Include="System.Windows.Interactivity, Version=4.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35, processorArchitecture=MSIL">
       <HintPath>..\..\packages\MahApps.Metro.1.5.0\lib\net45\System.Windows.Interactivity.dll</HintPath>
     </Reference>
@@ -61,6 +73,9 @@
     <Reference Include="System.Xaml">
       <RequiredTargetFramework>4.0</RequiredTargetFramework>
     </Reference>
+    <Reference Include="TableDependency.SqlClient, Version=8.5.3.0, Culture=neutral, processorArchitecture=MSIL">
+      <HintPath>..\..\packages\SqlTableDependency.8.5.3\lib\net451\TableDependency.SqlClient.dll</HintPath>
+    </Reference>
     <Reference Include="WindowsBase" />
     <Reference Include="PresentationCore" />
     <Reference Include="PresentationFramework" />
@@ -131,6 +146,10 @@
       <Project>{A34EE0F0-649D-41C8-8489-B6F1CC6924EE}</Project>
       <Name>Tango.Core</Name>
     </ProjectReference>
+    <ProjectReference Include="..\..\Tango.DAL.Remote\Tango.DAL.Remote.csproj">
+      <Project>{38197109-8610-4d3f-92b9-16d48df94d7c}</Project>
+      <Name>Tango.DAL.Remote</Name>
+    </ProjectReference>
     <ProjectReference Include="..\..\Tango.DragAndDrop\Tango.DragAndDrop.csproj">
       <Project>{b112d89a-a106-41ae-a0c1-4abc84c477f5}</Project>
       <Name>Tango.DragAndDrop</Name>
@@ -155,11 +174,15 @@
       <Project>{fd86424c-6e84-491b-8df9-3d0f5c236a2a}</Project>
       <Name>Tango.Touch</Name>
     </ProjectReference>
+    <ProjectReference Include="..\..\Tango.Web\Tango.Web.csproj">
+      <Project>{5001990F-977B-48FF-B217-0236A5022AD8}</Project>
+      <Name>Tango.Web</Name>
+    </ProjectReference>
   </ItemGroup>
   <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
   <ProjectExtensions>
     <VisualStudio>
-      <UserProperties BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UseGlobalSettings="False" BuildVersion_StartDate="2000/1/1" />
+      <UserProperties BuildVersion_StartDate="2000/1/1" BuildVersion_UseGlobalSettings="False" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" />
     </VisualStudio>
   </ProjectExtensions>
 </Project>
\ No newline at end of file
diff --git a/Software/Visual_Studio/Utilities/Tango.UITests/packages.config b/Software/Visual_Studio/Utilities/Tango.UITests/packages.config
index caf5d7712..449b1224d 100644
--- a/Software/Visual_Studio/Utilities/Tango.UITests/packages.config
+++ b/Software/Visual_Studio/Utilities/Tango.UITests/packages.config
@@ -1,7 +1,12 @@
 <?xml version="1.0" encoding="utf-8"?>
 <packages>
   <package id="EntityFramework" version="6.2.0" targetFramework="net461" />
+  <package id="EntityFramework.Cache" version="1.1.3" targetFramework="net461" />
   <package id="Expression.Blend.Sdk" version="1.0.2" targetFramework="net46" />
   <package id="FontAwesome.WPF" version="4.7.0.9" targetFramework="net46" />
   <package id="MahApps.Metro" version="1.5.0" targetFramework="net46" />
+  <package id="SqlTableDependency" version="8.5.3" targetFramework="net461" />
+  <package id="System.ComponentModel.Annotations" version="4.4.0" targetFramework="net461" />
+  <package id="System.Data.Common" version="4.3.0" targetFramework="net461" />
+  <package id="System.Data.SqlClient" version="4.3.0" targetFramework="net461" />
 </packages>
\ No newline at end of file