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);
}
}
