Recently, a general database sequence class (c #) is written. oledbsqloracleodbc data connection is supported,
Sysbase and db2 interfaces are supported,
If there are any errors, comments, or suggestions. Please contact me yu_nan88@126.com
Http://mail.gongyi.gov.cn/netdisk/download.php? User = zhaobin@gongyi.gov.cn & id = 2712a90f0de399014bfbea6e697381a3 & filename = L7mk1/cvTXlQRE8ucmFy & language = gb
Incomplete tests:
Test code:
Using System;
Using System. Collections;
Using System. IO;
Using NUnit. Framework;
Using MyPDO. DataAccess;
Namespace DataAccessTest
{
/// <Summary>
/// Summary of Class1.
/// </Summary>
[TestFixture]
Public class DataAccessTest
{
Public DataAccessTest ()
{
//
// TODO: add the constructor logic here
//
}
Private MyPDO. DataAccess. DataAccessor DBA;
[SetUp]
Public void SetUp ()
{
DBA = new DataAccessor ();
DBA. ConnectString = "Provider = SQLOLEDB; data source = 10.10.25.63; initial catalog = Master; user id = zha; Password = 123 ;";
DBA. ConnectType = MyPDO. ConnectType. OleDbDataDriver;
DBA. Open ();
Assert. IsTrue (DBA. IsOpen, "DBA closed ");
}
[Test]
Public void ExecuteNonQueryTest ()
{
Hashtable hsTable = new Hashtable ();
HsTable. Add ("A", "select * from myfiles ");
DBA.
Assert. IsTrue (DBA. IsOpen, "DBA closed ");
If (DBA. IsOpen = true)
{
DBA. ExecuteNonQuery (hsTable );}
}
[Test]
Public void GetDataSetTest ()