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(); }