/// <summary>
/// Set up the SQL connections for the table adapters when creating/opening
/// a database.
/// </summary>
private void CreateConnections()
{
localDB = new KPDatabaseReadOnly();
localTAManager = new KPDatabaseReadOnlyTableAdapters.TableAdapterManager();
localTAManager.RecordLogTableAdapter = new KPDatabaseReadOnlyTableAdapters.RecordLogTableAdapter();
localTAManager.VersionTableAdapter = new KPDatabaseReadOnlyTableAdapters.VersionTableAdapter();
localTAManager.CombatantsTableAdapter = new KPDatabaseReadOnlyTableAdapters.CombatantsTableAdapter();
System.Data.SqlServerCe.SqlCeConnection sqlConn =
new System.Data.SqlServerCe.SqlCeConnection(databaseConnectionString);
localTAManager.Connection = sqlConn;
localTAManager.RecordLogTableAdapter.Connection = sqlConn;
localTAManager.VersionTableAdapter.Connection = sqlConn;
localTAManager.CombatantsTableAdapter.Connection = sqlConn;
// If opening an existing database, need to check version info before filling data
localTAManager.RecordLogTableAdapter.Fill(localDB.RecordLog);
localTAManager.VersionTableAdapter.Fill(localDB.Version);
localTAManager.CombatantsTableAdapter.Fill(localDB.Combatants);
}
public void CloseDatabase()
{
if (localTAManager != null)
{
localTAManager.Dispose();
localTAManager = null;
}
if (localDB != null)
{
localDB.Dispose();
localDB = null;
}
}
