Changeset 2452 for trunk/sources/HeuristicLab.Modeling.Database.SQLServerCompact/3.2/DatabaseService.cs

Timestamp:

10/27/09 14:31:03 (15 years ago)

Author:

mkommend

Message:

added context usings to correct bug while persisting models (ticket #792)

File:

• trunk/sources/HeuristicLab.Modeling.Database.SQLServerCompact/3.2/DatabaseService.cs (modified) (2 diffs)

trunk/sources/HeuristicLab.Modeling.Database.SQLServerCompact/3.2/DatabaseService.cs

@@ -160 +160 @@
 
     public void PersistModel(IModel model) {
-      Model m = (Model)model;
-      //check if model has to be updated or inserted
-      if (ctx.Models.Any(x => x.Id == model.Id)) {
-        Model orginal = ctx.Models.GetOriginalEntityState(m);
-        if (orginal == null)
-          ctx.Models.Attach(m);
-        ctx.Refresh(RefreshMode.KeepCurrentValues, m);
-      } else
-        ctx.Models.InsertOnSubmit(m);
-      ctx.SubmitChanges();
+      using (ModelingDataContext ctx = new ModelingDataContext(this.ConnectionString)) {
+        Model m = (Model)model;
+        //check if model has to be updated or inserted
+        if (ctx.Models.Any(x => x.Id == model.Id)) {
+          Model orginal = ctx.Models.GetOriginalEntityState(m);
+          if (orginal == null)
+            ctx.Models.Attach(m);
+          ctx.Refresh(RefreshMode.KeepCurrentValues, m);
+        } else
+          ctx.Models.InsertOnSubmit(m);
+        ctx.SubmitChanges();
+      }
     }
 
@@ -225 +227 @@
 
     public void PersistPredictor(IModel model, IPredictor predictor) {
-      Model m = (Model)model;
-      ctx.ModelData.DeleteAllOnSubmit(ctx.ModelData.Where(x => x.Model == m));
-      ctx.ModelResults.DeleteAllOnSubmit(ctx.ModelResults.Where(x => x.Model == m));
-      ctx.InputVariableResults.DeleteAllOnSubmit(ctx.InputVariableResults.Where(x => x.Model == m));
-      ctx.InputVariables.DeleteAllOnSubmit(ctx.InputVariables.Where(x => x.Model == m));
-
-      ctx.ModelData.InsertOnSubmit(new ModelData(m, PersistenceManager.SaveToGZip(predictor)));
-      foreach (string variableName in predictor.GetInputVariables())
-        ctx.InputVariables.InsertOnSubmit(new InputVariable(m, (Variable)GetVariable(variableName)));
-
-      ctx.SubmitChanges();
+      using (ModelingDataContext ctx = new ModelingDataContext(this.ConnectionString)) {
+        Model m = (Model)model;
+        ctx.ModelData.DeleteAllOnSubmit(ctx.ModelData.Where(x => x.Model == m));
+        ctx.ModelResults.DeleteAllOnSubmit(ctx.ModelResults.Where(x => x.Model == m));
+        ctx.InputVariableResults.DeleteAllOnSubmit(ctx.InputVariableResults.Where(x => x.Model == m));
+        ctx.InputVariables.DeleteAllOnSubmit(ctx.InputVariables.Where(x => x.Model == m));
+
+        ctx.ModelData.InsertOnSubmit(new ModelData(m, PersistenceManager.SaveToGZip(predictor)));
+        foreach (string variableName in predictor.GetInputVariables())
+          ctx.InputVariables.InsertOnSubmit(new InputVariable(m, (Variable)GetVariable(variableName)));
+
+        ctx.SubmitChanges();
+      }
     }