Re-factored DAL Observables using EF Code First !!!!!!

1 files changed, 60 insertions, 0 deletions

diff --git a/Software/Visual_Studio/Tango.CodeGeneration/Templates/ObservablesContextCodeFile.cshtml b/Software/Visual_Studio/Tango.CodeGeneration/Templates/ObservablesContextCodeFile.cshtml
new file mode 100644
index 000000000..43330235c
--- /dev/null
+++ b/Software/Visual_Studio/Tango.CodeGeneration/Templates/ObservablesContextCodeFile.cshtml
@@ -0,0 +1,60 @@
+using System;
+using System.Collections.Generic;
+using System.Data.Entity;
+using System.Linq;
+using System.Text;
+using System.Threading.Tasks;
+using Tango.Settings;
+
+namespace Tango.DAL.Observables
+{
+    public class ObservablesContext : DbContext
+    {
+        /// <summary>
+        /// Initializes a new instance of the <see cref="ObservablesContext" /> class.
+        /// </summary>
+        /// <param name="path">The server file path.</param>
+        /// <param name="isFile">if set to <c>true</c> will try to connect to an .mdf file.</param>
+        public ObservablesContext(String path, bool isFile) : base(ComposeConnectionString(path, isFile))
+        {
+
+        }
+
+        /// <summary>
+        /// Composes the connection string.
+        ///</summary>
+        /// <param name="source">The source.</param>
+        /// <param name="isFile">if set to <c>true</c> [is file].</param>
+        /// <returns></returns>
+        private static String ComposeConnectionString(String source, bool isFile)
+        {
+            if (!isFile)
+            {
+                return String.Format("Data Source={0};Initial Catalog=Tango;Integrated Security=true", source);
+            }
+            else
+            {
+                return null;
+            }
+        }
+
+        /// <summary>
+        /// Creates a default remote database context by the address specified in <see cref="SettingsManager.Default.DataBase.SQLServerAddress" />.
+        /// </summary>
+        /// <returns></returns>
+        public static ObservablesContext CreateDefault()
+        {
+            return new ObservablesContext(SettingsManager.Default.DataBase.SQLServerAddress, false);
+        }
+
+        @foreach (var prop in Model.Properties)
+        {
+            <div>
+                /// <summary>
+                /// Gets or sets the @(prop.Name).
+                /// </summary>
+                public @(prop.Type) @(prop.Name) { get; set; }
+            </div>
+        }
+    }
+}