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, 22 insertions, 0 deletions

diff --git a/Software/Visual_Studio/Tango.DAL.Local/Partials/LocalDB.cs b/Software/Visual_Studio/Tango.DAL.Local/Partials/LocalDB.cs
new file mode 100644
index 000000000..2ad765a2b
--- /dev/null
+++ b/Software/Visual_Studio/Tango.DAL.Local/Partials/LocalDB.cs
@@ -0,0 +1,22 @@
+using System;
+using System.Collections.Generic;
+using System.Data.Entity;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+
+namespace Tango.DAL.Local.DB
+{
+    public partial class LocalDB : DbContext
+    {
+        public LocalDB(String filePath) : base(ComposeConnectionString(filePath))
+        {
+
+        }
+
+        private static String ComposeConnectionString(String filePath)
+        {
+            return String.Format("metadata=res://*/DB.LocalADO.csdl|res://*/DB.LocalADO.ssdl|res://*/DB.LocalADO.msl;provider=System.Data.SQLite.EF6;provider connection string=\"data source={0}\"", filePath);
+        }
+    }
+}