public void Test_CloseConnection_WithNoConnection_ShouldThrow()
{
var oraConn = new OracleConnection("conn_string", new TimeSpan(0, 0, 10));
Assert.That(oraConn.IsConnected, Is.False);
Assert.Throws <InvalidOperationException>(() => oraConn.CloseConnection());
}
public void Test_CloseConnection()
{
var oraConn = new OracleConnection("conn_string", new TimeSpan(0, 0, 10));
oraConn.OpenConnection();
Assert.That(oraConn.IsConnected, Is.True);
oraConn.CloseConnection();
Assert.That(oraConn.IsConnected, Is.False);
}
static void Main(string[] args)
{
Console.WriteLine("DBCONNECTION - ABSTRACT");
while (true)
{
System.Console.WriteLine("Enter 1 if you wish to continue else any other number to exit!");
int Contin = Convert.ToInt32(Console.ReadLine());
if (Contin.Equals(1))
{
//break;
}
else
{
break;
}
System.Console.WriteLine("Enter which DB to connect 1.SQL, 2.ORACLE");
string Dbchoice = Console.ReadLine();
//var ObjDb = new DbConnection();
System.Console.WriteLine("ENter the Connection string");
string ConnectionString = Console.ReadLine();
try
{
if (Dbchoice == "1")
{
var ObjDb = new SqlConnection(ConnectionString);
ObjDb.OpenConnection();
ObjDb.CloseConnection();
}
else if (Dbchoice == "2")
{
var ObjDb = new OracleConnection(ConnectionString);
ObjDb.OpenConnection();
ObjDb.CloseConnection();
}
else
{
System.Console.WriteLine("Enter a valid DB connection!");
continue;
}
}
catch (System.Exception e)
{
System.Console.WriteLine(e.Message);
continue;
//throw;
}
//ObjDb.OpenConnection();
//ObjDb.CloseConnection();
}
}
private static void Main()
{
var sql = new SqlConnection("1");
var oracle = new OracleConnection("2");
sql.OpenConnection();
oracle.OpenConnection();
oracle.CloseConnection();
sql.CloseConnection();
var command1 = new DbCommand(new SqlConnection("1"), "Adam is the best SQL");
var command2 = new DbCommand(new OracleConnection("2"), "Adam is the best Oracle");
command1.Execute();
command2.Execute();
}
private static void TimeoutTester(OracleConnection connection, Operation op)
{
var startTime = DateTime.Now;
try
{
while (true)
{
switch (op)
{
case Operation.Open:
connection.OpenConnection();
break;
case Operation.Close:
connection.CloseConnection();
break;
default:
break;
}
if (DateTime.Now.Subtract(startTime).TotalSeconds > connection.Timeout.TotalSeconds)
{
connection.LogConnectionStatus(connection, false, op);
throw new TimeoutException();
}
else
{
connection.LogConnectionStatus(connection, true, op);
break;
}
}
}
catch (ArgumentException)
{
throw;
}
}
