public static void EnableDatabaseLog(DataContextBase db) { if (db.Log == null) { db.Log = _databaseLog; } }
public static void DisableDatabaseLog(DataContextBase db) { if (db.Log != null) { db.Log.Close(); db.Log = null; } }
public static void InitializeDatabase(DataContextBase db, bool isCreateNew) { if (File.Exists(db.DataBasePath)) { if (isCreateNew) { File.Delete(db.DataBasePath); CreateDatabase(db); } } else { CreateDatabase(db); } }
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); } }
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(); } }
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); } }