private void btnCreateDataStore_Click(object sender, EventArgs e)
{
try
{
this.lblSize.Text = "0 Kb";
this.lblCreatedOn.Text = "-";
if (this.txtFileName.Text.Length > 0)
{
String path = System.IO.Path.GetDirectoryName(this.txtFileName.Text);
if (path.Length == 0 || System.IO.Directory.Exists(path))
{
if (this._DataStore != null) this._DataStore.Dispose();
this._DataStore = new SQLiteDataStore(this.txtFileName.Text);
if (chkAutoVacuum.Checked)
this._DataStore.SetAutoVacuumBehavior(SQLiteDataStore.AutoVacuum.FULL);
else
this._DataStore.SetAutoVacuumBehavior(SQLiteDataStore.AutoVacuum.OFF);
if (chkTransactionSynchronization.Checked)
this._DataStore.SetTransactionSynchronization(SQLiteDataStore.TransactionSynchronization.FULL);
else
this._DataStore.SetTransactionSynchronization(SQLiteDataStore.TransactionSynchronization.OFF);
this._DataStore.MaxDatabaseSizeInMB = 500;
this._DataStore.ConnectionBehavior = ConnectionBehavior.Persistent;
this._DataStore.DiscoverTypes(System.Reflection.Assembly.GetAssembly(typeof(OpenNETCF.ORM.Model.basictable)));
if (System.IO.File.Exists(this.txtFileName.Text))
{
this._DataStore.CreateOrUpdateStore();
}
else
{
this._DataStore.CreateStore();
}
this.dbtTests.DataStore = this._DataStore;
this.dbsStructure.DataStore = this._DataStore;
if (System.IO.File.Exists(this.txtFileName.Text))
{
var fi = new System.IO.FileInfo(this.txtFileName.Text);
this.lblSize.Text = String.Format("{0} Kb", (fi.Length / 1024));
this.lblCreatedOn.Text = String.Format("{0}", fi.CreationTime.ToString());
}
}
else
{
throw new Exception("Directory Path doesn't exist!");
}
}
}
catch (Exception ex)
{
OpenNETCF.ORM.MainDemo.Logger.LogException(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
}
}
public void InitializeObjects()
{
try
{
this.txtFileName.Text = "demo.db3";
if (System.IO.File.Exists(this.txtFileName.Text))
{
var fi = new System.IO.FileInfo(this.txtFileName.Text);
this.lblSize.Text = String.Format("{0} Kb", (fi.Length / 1024));
this.lblCreatedOn.Text = String.Format("{0}", fi.CreationTime.ToString());
if (this._DataStore != null) this._DataStore.Dispose();
this._DataStore = new SQLiteDataStore(this.txtFileName.Text);
if (chkAutoVacuum.Checked)
this._DataStore.SetAutoVacuumBehavior(SQLiteDataStore.AutoVacuum.FULL);
else
this._DataStore.SetAutoVacuumBehavior(SQLiteDataStore.AutoVacuum.OFF);
if (chkTransactionSynchronization.Checked)
this._DataStore.SetTransactionSynchronization(SQLiteDataStore.TransactionSynchronization.FULL);
else
this._DataStore.SetTransactionSynchronization(SQLiteDataStore.TransactionSynchronization.OFF);
this._DataStore.MaxDatabaseSizeInMB = 500;
this._DataStore.ConnectionBehavior = ConnectionBehavior.Persistent;
this._DataStore.DiscoverTypes(System.Reflection.Assembly.GetAssembly(typeof(OpenNETCF.ORM.Model.basictable)));
this.dbsStructure.DataStore = this._DataStore;
this.dbtTests.DataStore = this._DataStore;
this.deTests.DataStore = this._DataStore;
this.dbsStructure.DataStoreChanged += new EventHandler(dbsStructure_DataStoreChanged);
this.deTests.DataStoreChanged += new EventHandler(deTests_DataStoreChanged);
}
}
catch (Exception ex)
{
OpenNETCF.ORM.MainDemo.Logger.LogException(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
throw ex;
}
}
private void btnDeleteDataStore_Click(object sender, EventArgs e)
{
try
{
this.lblSize.Text = "0 Kb";
this.lblCreatedOn.Text = "-";
this.dbsStructure.DataStore = null;
this.dbtTests.DataStore = null;
if (this._DataStore != null)
{
this._DataStore.Dispose();
this._DataStore = null;
}
if (this.txtFileName.Text.Length > 0 && System.IO.File.Exists(this.txtFileName.Text))
{
System.Threading.Thread.Sleep(500);
System.IO.File.Delete(this.txtFileName.Text);
}
}
catch (Exception ex)
{
OpenNETCF.ORM.MainDemo.Logger.LogException(System.Reflection.MethodBase.GetCurrentMethod().Name, ex);
}
}