コード例 #1
0
 public static void EnableDatabaseLog(DataContextBase db)
 {
     if (db.Log == null)
     {
         db.Log = _databaseLog;
     }
 }
コード例 #2
0
 public static void DisableDatabaseLog(DataContextBase db)
 {
     if (db.Log != null)
     {
         db.Log.Close();
         db.Log = null;
     }
 }
コード例 #3
0
 public static void InitializeDatabase(DataContextBase db, bool isCreateNew)
 {
     if (File.Exists(db.DataBasePath))
     {
         if (isCreateNew)
         {
             File.Delete(db.DataBasePath);
             CreateDatabase(db);
         }
     }
     else
     {
         CreateDatabase(db);
     }
 }
コード例 #4
0
        private static StreamWriter _databaseLog = new StreamWriter(@"database_log.txt", false); // Append

        #endregion Fields

        #region Methods

        public static void CreateDatabase(DataContextBase db)
        {
            try
            {
                // Generate the database (with structure) from the code-based data context
                db.CreateDatabase();

                // Populate the database with system data
                GenerateDefaultData(db);
            }
            catch (Exception ex)
            {
               Console.WriteLine("Error while creating the DB: " + ex.Message);
            }
        }
コード例 #5
0
 private static void GenerateDefaultData(DataContextBase db)
 {
     //Add Contact
     db.TableContact.InsertOnSubmit(new Contact());
     try
     {
         db.SubmitChanges();
     }
     catch (Exception e)
     {
         Console.WriteLine(e);
         // Make some adjustments.
         // ...
         // Try again.
         //db.SubmitChanges();
     }
 }
コード例 #6
0
ファイル: Program.cs プロジェクト: zhangyinglong/zyl_04401
 static void test_database()
 {
     try
     {
         DataContextBase db = new DataContextBase(@"Data Source=Feiliao.sdf");
         DataBaseHelper.EnableDatabaseLog(db);
         DataBaseHelper.InitializeDatabase(db, true);
         IQueryable<Contact> contactQuery = from contact in db.TableContact select contact;
         Console.WriteLine("show contact table:");
         Console.WriteLine("id\tname");
         foreach (Contact c in contactQuery)
         {
             Console.WriteLine("{0}\t{1}", c.ContactID, c.ContactName);
         }
         DataBaseHelper.DisableDatabaseLog(db);
         db.Dispose();
         Console.Read();
     }
     catch (Exception ex)
     {
         Console.WriteLine("Error while creating the DB: " + ex.Message);
     }
 }