public void TestConnection()
{
using (IDbConnection conn = new OraConnection())
{
Debug.Assert(!conn.IsOpenConnection, "IsConnect1");
Debug.Assert(!conn.CheckConnection(), "CheckConnection1");
conn.OpenConnection("chipanddale", "chipanddale", "xe");
Debug.Assert(conn.CheckConnection(), "CheckConnection2");
Debug.Assert(conn.IsOpenConnection, "IsConnect2");
conn.TestConnection();
Debug.Assert(conn.CheckConnection(), "CheckConnection3");
Debug.Assert(conn.IsOpenConnection, "IsConnect3");
conn.CloseConnection();
Debug.Assert(!conn.IsOpenConnection, "IsConnect4");
Debug.Assert(!conn.CheckConnection(), "CheckConnection4");
conn.ReConnect();
Debug.Assert(conn.IsOpenConnection, "IsConnect5");
Debug.Assert(conn.CheckConnection(), "CheckConnection5");
conn.OpenConnection("chipanddale", "chipanddale", "xe");
conn.OpenConnection("chipanddale", "chipanddale", "xe");
Debug.Assert(conn.CheckConnection(), "CheckConnection6");
Debug.Assert(conn.IsOpenConnection, "IsConnect6");
conn.OpenConnection("chipanddale", "chipanddale", "xe");
conn.ReConnect();
conn.OpenConnection("chipanddale", "chipanddale", "xe");
Debug.Assert(conn.CheckConnection(), "CheckConnection7");
Debug.Assert(conn.IsOpenConnection, "IsConnect7");
conn.ReConnect();
conn.ReConnect();
conn.OpenConnection("chipanddale", "chipanddale", "xe");
conn.CloseConnection();
conn.CloseConnection();
conn.ReConnect();
Debug.Assert(conn.CheckConnection(), "CheckConnection8");
Debug.Assert(conn.IsOpenConnection, "IsConnect8");
}
}
private void ButtonRun_Click(object sender, EventArgs e)
{
var conn = new OraConnection();
conn.CreateNewConnection("Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=11.22.33.44)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=CUSTOMDB)));User Id=system;Password=System01;");
var obj = conn.GetScalar(@"select {0} from dual", string.Empty);
//var date = conn.TestMethod();
//textBoxResult.Text = date.ToString();
//textBoxResult.Text += Environment.NewLine;
//textBoxResult.Text += conn.TestMethodTwo(514);
conn.CloseConnection();
}
