private DbConnection CreateConnection()
{
DbConnection conn = m_conn.CreateSystemConnection();
conn.ConnectionString = m_conn.GenerateConnectionString(true);
return(conn);
}
private void btok_Click(object sender, EventArgs e)
{
m_frame.SaveConnection();
m_common.SaveConnection();
try
{
DbConnection conn = m_conn.CreateSystemConnection();
try
{
Async.InvokeFromGui(conn.Open);
Async.InvokeFromGui(conn.Close);
}
catch (Exception err)
{
throw new ConnectionFailedError("DAE-00162", err);
}
DialogResult = DialogResult.OK;
Close();
}
catch (Exception err)
{
Errors.Report(err);
return;
}
DialogResult = DialogResult.OK;
Close();
}
public static void DropDbs()
{
foreach (var con in Config.Instance.Connections)
{
string fn = Path.Combine(Config.Instance.AppDataDirectory, "data/" + con.ConFileName);
IStoredConnection sc = StoredConnection.LoadFromFile(fn);
if (sc == null)
{
TestLog.Info("Cannot connect to database " + con.ConFileName);
continue;
}
using (DbConnection dbconn = sc.CreateSystemConnection())
{
dbconn.Open();
try
{
TestLog.Info("Deleting testing database");
dbconn.ExecuteNonQuery("DROP DATABASE testingdb", new GenericDialect());
}
catch (Exception e)
{
TestLog.Error("Error creating database", e);
}
}
}
}