/// <summary>
/// Set up the SQL connections for the table adapters when creating/opening
/// a database.
/// </summary>
private void CreateConnections()
{
localDB = new KPDatabaseDataSet();
localTAManager = new TableAdapterManager();
localTAManager.CombatantsTableAdapter = new CombatantsTableAdapter();
localTAManager.BattlesTableAdapter = new BattlesTableAdapter();
localTAManager.InteractionsTableAdapter = new InteractionsTableAdapter();
localTAManager.ActionsTableAdapter = new ActionsTableAdapter();
localTAManager.LootTableAdapter = new LootTableAdapter();
localTAManager.ItemsTableAdapter = new ItemsTableAdapter();
localTAManager.RecordLogTableAdapter = new RecordLogTableAdapter();
localTAManager.VersionTableAdapter = new VersionTableAdapter();
localTAManager.ChatMessagesTableAdapter = new ChatMessagesTableAdapter();
localTAManager.ChatSpeakersTableAdapter = new ChatSpeakersTableAdapter();
System.Data.SqlServerCe.SqlCeConnection sqlConn =
new System.Data.SqlServerCe.SqlCeConnection(databaseConnectionString);
localTAManager.Connection = sqlConn;
localTAManager.CombatantsTableAdapter.Connection = sqlConn;
localTAManager.BattlesTableAdapter.Connection = sqlConn;
localTAManager.InteractionsTableAdapter.Connection = sqlConn;
localTAManager.ActionsTableAdapter.Connection = sqlConn;
localTAManager.LootTableAdapter.Connection = sqlConn;
localTAManager.ItemsTableAdapter.Connection = sqlConn;
localTAManager.ChatMessagesTableAdapter.Connection = sqlConn;
localTAManager.ChatSpeakersTableAdapter.Connection = sqlConn;
localTAManager.RecordLogTableAdapter.Connection = sqlConn;
localTAManager.VersionTableAdapter.Connection = sqlConn;
// If opening an existing database, need to check version info before filling data
localTAManager.CombatantsTableAdapter.Fill(localDB.Combatants);
localTAManager.BattlesTableAdapter.Fill(localDB.Battles);
localTAManager.InteractionsTableAdapter.Fill(localDB.Interactions);
localTAManager.ActionsTableAdapter.Fill(localDB.Actions);
localTAManager.LootTableAdapter.Fill(localDB.Loot);
localTAManager.ItemsTableAdapter.Fill(localDB.Items);
localTAManager.ChatMessagesTableAdapter.Fill(localDB.ChatMessages);
localTAManager.ChatSpeakersTableAdapter.Fill(localDB.ChatSpeakers);
localTAManager.RecordLogTableAdapter.Fill(localDB.RecordLog);
localTAManager.VersionTableAdapter.Fill(localDB.Version);
}
/// <summary>
/// Close the current database.
/// Saves any pending changes first.
/// </summary>
public void CloseDatabase()
{
databaseEntry.Reset();
UpdateDatabase();
if (localTAManager != null)
{
localTAManager.Dispose();
localTAManager = null;
}
if (localDB != null)
{
localDB.Dispose();
localDB = null;
}
}
