Split DAL to DAl.Local & DAL.Remote due to ambiguity of table names in EF.

Implemented Unit testing for SQLite & SQL Server connections.

1 files changed, 222 insertions, 0 deletions

diff --git a/Software/Visual_Studio/Tango.DAL.Local/Tango.DAL.Local.csproj b/Software/Visual_Studio/Tango.DAL.Local/Tango.DAL.Local.csproj
new file mode 100644
index 000000000..6ea3badfc
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Local/Tango.DAL.Local.csproj
@@ -0,0 +1,222 @@
+<?xml version="1.0" encoding="utf-8"?>
+<Project ToolsVersion="15.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
+  <Import Project="$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props" Condition="Exists('$(MSBuildExtensionsPath)\$(MSBuildToolsVersion)\Microsoft.Common.props')" />
+  <PropertyGroup>
+    <Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
+    <Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
+    <ProjectGuid>{0E0EEF3E-8F4E-4F23-9D19-479FD8D76C12}</ProjectGuid>
+    <OutputType>Library</OutputType>
+    <AppDesignerFolder>Properties</AppDesignerFolder>
+    <RootNamespace>Tango.DAL.Local</RootNamespace>
+    <AssemblyName>Tango.DAL.Local</AssemblyName>
+    <TargetFrameworkVersion>v4.6</TargetFrameworkVersion>
+    <FileAlignment>512</FileAlignment>
+    <NuGetPackageImportStamp>
+    </NuGetPackageImportStamp>
+  </PropertyGroup>
+  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
+    <DebugSymbols>true</DebugSymbols>
+    <DebugType>full</DebugType>
+    <Optimize>false</Optimize>
+    <OutputPath>..\Build\Debug\</OutputPath>
+    <DefineConstants>DEBUG;TRACE</DefineConstants>
+    <ErrorReport>prompt</ErrorReport>
+    <WarningLevel>4</WarningLevel>
+  </PropertyGroup>
+  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
+    <DebugType>pdbonly</DebugType>
+    <Optimize>true</Optimize>
+    <OutputPath>bin\Release\</OutputPath>
+    <DefineConstants>TRACE</DefineConstants>
+    <ErrorReport>prompt</ErrorReport>
+    <WarningLevel>4</WarningLevel>
+  </PropertyGroup>
+  <ItemGroup>
+    <Reference Include="EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, processorArchitecture=MSIL">
+      <HintPath>..\packages\EntityFramework.6.0.0\lib\net45\EntityFramework.dll</HintPath>
+    </Reference>
+    <Reference Include="EntityFramework.SqlServer, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, processorArchitecture=MSIL">
+      <HintPath>..\packages\EntityFramework.6.0.0\lib\net45\EntityFramework.SqlServer.dll</HintPath>
+    </Reference>
+    <Reference Include="System" />
+    <Reference Include="System.ComponentModel.DataAnnotations" />
+    <Reference Include="System.Core" />
+    <Reference Include="System.Data.SQLite, Version=1.0.106.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=MSIL">
+      <HintPath>..\packages\System.Data.SQLite.Core.1.0.106.0\lib\net46\System.Data.SQLite.dll</HintPath>
+    </Reference>
+    <Reference Include="System.Data.SQLite.EF6, Version=1.0.106.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=MSIL">
+      <HintPath>..\packages\System.Data.SQLite.EF6.1.0.106.0\lib\net46\System.Data.SQLite.EF6.dll</HintPath>
+      <Private>True</Private>
+    </Reference>
+    <Reference Include="System.Data.SQLite.Linq, Version=1.0.106.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139, processorArchitecture=MSIL">
+      <HintPath>..\packages\System.Data.SQLite.Linq.1.0.106.0\lib\net46\System.Data.SQLite.Linq.dll</HintPath>
+      <Private>True</Private>
+    </Reference>
+    <Reference Include="System.Runtime.Serialization" />
+    <Reference Include="System.Security" />
+    <Reference Include="System.Xml.Linq" />
+    <Reference Include="System.Data.DataSetExtensions" />
+    <Reference Include="Microsoft.CSharp" />
+    <Reference Include="System.Data" />
+    <Reference Include="System.Net.Http" />
+    <Reference Include="System.Xml" />
+  </ItemGroup>
+  <ItemGroup>
+    <Compile Include="..\Versioning\GlobalVersionInfo.cs">
+      <Link>GlobalVersionInfo.cs</Link>
+    </Compile>
+    <Compile Include="DB\ACTION.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\ADDRESS.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\APPLICATION_FIRMWARE_VERSIONS.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\APPLICATION_OS_VERSIONS.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\APPLICATION_VERSION.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\CONFIGURATION.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\CONFIGURATIONS_DISPENSERS.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\CONTACT.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\DISPENSER.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\EMBEDDED_FIRMWARE_VERSIONS.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\EMBEDDED_SOFTWARE_VERSIONS.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\EVENT.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\EVENTS_ACTIONS.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\FIBER_SHAPES.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\FIBER_SYNTHESIS.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\HARDWARE_VERSIONS.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\LINEAR_MASS_DENSITY_UNITS.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\LIQUID.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\LIQUIDS_RML.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\LIQUID_TYPES.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\LocalADO.Context.cs">
+      <AutoGen>True</AutoGen>
+      <DesignTime>True</DesignTime>
+      <DependentUpon>LocalADO.Context.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\LocalADO.cs">
+      <AutoGen>True</AutoGen>
+      <DesignTime>True</DesignTime>
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\LocalADO.Designer.cs">
+      <AutoGen>True</AutoGen>
+      <DesignTime>True</DesignTime>
+      <DependentUpon>LocalADO.edmx</DependentUpon>
+    </Compile>
+    <Compile Include="DB\MACHINE.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\MACHINES_EVENTS.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\MACHINE_VERSIONS.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\MEDIA_COLORS.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\MEDIA_CONDITIONS.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\MEDIA_MATERIALS.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\MEDIA_PURPOSES.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\ORGANIZATION.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\PERMISSION.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\RML.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\ROLE.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\ROLES_PERMISSIONS.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\USER.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="DB\USERS_ROLES.cs">
+      <DependentUpon>LocalADO.tt</DependentUpon>
+    </Compile>
+    <Compile Include="Partials\LocalDB.cs" />
+    <Compile Include="Properties\AssemblyInfo.cs" />
+  </ItemGroup>
+  <ItemGroup>
+    <None Include="App.config" />
+    <EntityDeploy Include="DB\LocalADO.edmx">
+      <Generator>EntityModelCodeGenerator</Generator>
+      <LastGenOutput>LocalADO.Designer.cs</LastGenOutput>
+    </EntityDeploy>
+    <None Include="DB\LocalADO.edmx.diagram">
+      <DependentUpon>LocalADO.edmx</DependentUpon>
+    </None>
+    <None Include="packages.config" />
+  </ItemGroup>
+  <ItemGroup>
+    <Service Include="{508349B6-6B84-4DF5-91F0-309BEEBAD82D}" />
+  </ItemGroup>
+  <ItemGroup>
+    <Content Include="DB\LocalADO.Context.tt">
+      <Generator>TextTemplatingFileGenerator</Generator>
+      <DependentUpon>LocalADO.edmx</DependentUpon>
+      <LastGenOutput>LocalADO.Context.cs</LastGenOutput>
+    </Content>
+    <Content Include="DB\LocalADO.tt">
+      <Generator>TextTemplatingFileGenerator</Generator>
+      <DependentUpon>LocalADO.edmx</DependentUpon>
+      <LastGenOutput>LocalADO.cs</LastGenOutput>
+    </Content>
+  </ItemGroup>
+  <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
+  <Import Project="..\packages\System.Data.SQLite.Core.1.0.106.0\build\net46\System.Data.SQLite.Core.targets" Condition="Exists('..\packages\System.Data.SQLite.Core.1.0.106.0\build\net46\System.Data.SQLite.Core.targets')" />
+  <Target Name="EnsureNuGetPackageBuildImports" BeforeTargets="PrepareForBuild">
+    <PropertyGroup>
+      <ErrorText>This project references NuGet package(s) that are missing on this computer. Use NuGet Package Restore to download them.  For more information, see http://go.microsoft.com/fwlink/?LinkID=322105. The missing file is {0}.</ErrorText>
+    </PropertyGroup>
+    <Error Condition="!Exists('..\packages\System.Data.SQLite.Core.1.0.106.0\build\net46\System.Data.SQLite.Core.targets')" Text="$([System.String]::Format('$(ErrorText)', '..\packages\System.Data.SQLite.Core.1.0.106.0\build\net46\System.Data.SQLite.Core.targets'))" />
+  </Target>
+</Project>
\ No newline at end of file