Changeset 3943 for branches/HeuristicLab.Services.Authentication Prototype/Persistence/DatabaseUtil.cs

Timestamp:

06/24/10 00:23:16 (14 years ago)

Author:

hmayr

Message:

following changes (#1046):

• extended DatabaseUtil.cs
• extended HeuristicLabUser.cs
• created HeuristicLabUserTest.cs
• created AbstractHeuristicLabTest.cs
• implemented a demo method in HeuristicLabMembershipProvider.cs to show usage of HeuristicLabUser.cs and DatabaseUtil.cs

File:

• branches/HeuristicLab.Services.Authentication Prototype/Persistence/DatabaseUtil.cs (modified) (1 diff)

branches/HeuristicLab.Services.Authentication Prototype/Persistence/DatabaseUtil.cs

@@ -1 @@
-namespace Persistence {
+using System;
+
+namespace Persistence {
   /// <summary>
-  /// 
+  /// combines multiple used static methods into one class
   /// </summary>
   public class DatabaseUtil {
     /// <summary>
-    /// 
+    /// creates and returns a database connection, if possible
     /// </summary>
-    /// <returns></returns>
+    /// <returns>database connection (could be null)</returns>
     public static DataClassesDataContext createDataClassesDataContext() {
-      return new Persistence.DataClassesDataContext(@"C:\TEMP\HeuristicLabTemp.mdf");
+      DataClassesDataContext db;
+      try {
+        db = new Persistence.DataClassesDataContext(@"C:\TEMP\HeuristicLabTemp.mdf");
+      }
+      catch (Exception) {
+        return null;
+      }
+      return db;
+    }
+
+    /// <summary>
+    /// creates a new database out of the LINQ to SQL classes
+    /// </summary>
+    /// <param name="db">DataClassesDataContext</param>
+    public static void createDatabase(DataClassesDataContext db) {
+      if (db == null) {
+        throw new ArgumentNullException("db");
+      }
+      
+      if (db.DatabaseExists()) {
+        Console.WriteLine("Deleting old database...");
+        db.DeleteDatabase();
+        Console.WriteLine("Deleted old database!");
+      }
+
+      Console.WriteLine("Creating new database...");
+      db.CreateDatabase();
+      Console.WriteLine("Created new database!");
     }
   }