public static void Init(TestContext testContext)
{
var connetionString =
@"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orcl)));User ID=landuseconfig;Password=landuseconfig;";
oracleAccess = new OracleAccess(connetionString);
oracleAccess.Open();
}
public static void Test()
{
//var conn = "DATA SOURCE=10.2.6.9:1601/whls;PASSWORD=whlss01;PERSIST SECURITY INFO=True;USER ID=whls";
var conn = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.2.6.9)(PORT=1601)))(CONNECT_DATA=(SERVER=DEDICATED)(SID=TEST)));User Id=whls;Password=whlss01;";
using (var c = new OracleAccess())
{
c.Open(conn);
var result = c.Query("select * from CUX.CUX_B2B_CUST_RECIPT_CLAIM_INT;", new EFFC.Frame.Net.Unit.DB.Parameters.DBOParameterCollection());
}
}
private static void Test()
{
var oracleAccess = new OracleAccess();
oracleAccess.Open();
var tableNames = oracleAccess.GetAllTableNames();
foreach (var tableName in tableNames)
{
Console.WriteLine(tableName);
}
Console.ReadLine();
}