static bool FIREBIRD_1() { try { // LoadAll CSharp.FIREBIRD.DIALECT1.EMPLOYEES emps = new CSharp.FIREBIRD.DIALECT1.EMPLOYEES(); emps.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMP1.FBD;User=SYSDBA;Password=masterkey;Dialect=1;Server=griffo"; if(!emps.LoadAll()) { return false; // ERROR } // LoadByPrimaryKey int id = emps.EMPLOYEE_ID; emps = new CSharp.FIREBIRD.DIALECT1.EMPLOYEES(); emps.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMP1.FBD;User=SYSDBA;Password=masterkey;Dialect=1;Server=griffo"; if(!emps.LoadByPrimaryKey(id)) { return false; // ERROR } // AddNew/Save emps = new CSharp.FIREBIRD.DIALECT1.EMPLOYEES(); emps.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMP1.FBD;User=SYSDBA;Password=masterkey;Dialect=1;Server=griffo"; emps.AddNew(); emps.FIRST_NAME = "trella1"; emps.LAST_NAME = "trella1"; emps.AddNew(); emps.FIRST_NAME = "trella2"; emps.LAST_NAME = "trella2"; emps.Save(); // Query.Load/Update/Save emps = new CSharp.FIREBIRD.DIALECT1.EMPLOYEES(); emps.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMP1.FBD;User=SYSDBA;Password=masterkey;Dialect=1;Server=griffo"; emps.Where.FIRST_NAME.Value = "trella%"; emps.Where.FIRST_NAME.Operator = WhereParameter.Operand.Like; emps.Where.LAST_NAME.Value = "trella%"; emps.Where.LAST_NAME.Operator = WhereParameter.Operand.Like; if(!emps.Query.Load()) { return false; // ERROR } do emps.LAST_NAME = emps.LAST_NAME + ":new"; while(emps.MoveNext()); emps.Save(); // Transaction CSharp.FIREBIRD.DIALECT1.EMPLOYEES emps1 = new CSharp.FIREBIRD.DIALECT1.EMPLOYEES(); emps1.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMP1.FBD;User=SYSDBA;Password=masterkey;Dialect=1;Server=griffo"; emps1.AddNew(); emps1.FIRST_NAME = "trella1_tx1"; emps1.LAST_NAME = "trella1_tx1"; CSharp.FIREBIRD.DIALECT1.EMPLOYEES emps2 = new CSharp.FIREBIRD.DIALECT1.EMPLOYEES(); emps2.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMP1.FBD;User=SYSDBA;Password=masterkey;Dialect=1;Server=griffo"; emps2.AddNew(); emps2.FIRST_NAME = "trella1_tx2"; emps2.LAST_NAME = "trella1_tx2"; TransactionMgr.ThreadTransactionMgr().BeginTransaction(); emps1.Save(); emps2.Save(); TransactionMgr.ThreadTransactionMgr().CommitTransaction(); // Query.Load/MarkAsDeleted/Save emps = new CSharp.FIREBIRD.DIALECT1.EMPLOYEES(); emps.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMP1.FBD;User=SYSDBA;Password=masterkey;Dialect=1;Server=griffo"; emps.Where.FIRST_NAME.Value = "trella%"; emps.Where.FIRST_NAME.Operator = WhereParameter.Operand.Like; emps.Where.LAST_NAME.Value = "trella%"; emps.Where.LAST_NAME.Operator = WhereParameter.Operand.Like; if(!emps.Query.Load()) { return false; // ERROR } emps.DeleteAll(); emps.Save(); } catch(Exception ex) { Console.WriteLine(ex.Message); return false; } finally { TransactionMgr.ThreadTransactionMgrReset(); } return true; }
static bool FIREBIRD_1() { try { // LoadAll CSharp.FIREBIRD.DIALECT1.EMPLOYEES emps = new CSharp.FIREBIRD.DIALECT1.EMPLOYEES(); emps.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMP1.FBD;User=SYSDBA;Password=masterkey;Dialect=1;Server=griffo"; if (!emps.LoadAll()) { return(false); // ERROR } // LoadByPrimaryKey int id = emps.EMPLOYEE_ID; emps = new CSharp.FIREBIRD.DIALECT1.EMPLOYEES(); emps.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMP1.FBD;User=SYSDBA;Password=masterkey;Dialect=1;Server=griffo"; if (!emps.LoadByPrimaryKey(id)) { return(false); // ERROR } // AddNew/Save emps = new CSharp.FIREBIRD.DIALECT1.EMPLOYEES(); emps.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMP1.FBD;User=SYSDBA;Password=masterkey;Dialect=1;Server=griffo"; emps.AddNew(); emps.FIRST_NAME = "trella1"; emps.LAST_NAME = "trella1"; emps.AddNew(); emps.FIRST_NAME = "trella2"; emps.LAST_NAME = "trella2"; emps.Save(); // Query.Load/Update/Save emps = new CSharp.FIREBIRD.DIALECT1.EMPLOYEES(); emps.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMP1.FBD;User=SYSDBA;Password=masterkey;Dialect=1;Server=griffo"; emps.Where.FIRST_NAME.Value = "trella%"; emps.Where.FIRST_NAME.Operator = WhereParameter.Operand.Like; emps.Where.LAST_NAME.Value = "trella%"; emps.Where.LAST_NAME.Operator = WhereParameter.Operand.Like; if (!emps.Query.Load()) { return(false); // ERROR } do { emps.LAST_NAME = emps.LAST_NAME + ":new"; }while(emps.MoveNext()); emps.Save(); // Transaction CSharp.FIREBIRD.DIALECT1.EMPLOYEES emps1 = new CSharp.FIREBIRD.DIALECT1.EMPLOYEES(); emps1.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMP1.FBD;User=SYSDBA;Password=masterkey;Dialect=1;Server=griffo"; emps1.AddNew(); emps1.FIRST_NAME = "trella1_tx1"; emps1.LAST_NAME = "trella1_tx1"; CSharp.FIREBIRD.DIALECT1.EMPLOYEES emps2 = new CSharp.FIREBIRD.DIALECT1.EMPLOYEES(); emps2.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMP1.FBD;User=SYSDBA;Password=masterkey;Dialect=1;Server=griffo"; emps2.AddNew(); emps2.FIRST_NAME = "trella1_tx2"; emps2.LAST_NAME = "trella1_tx2"; TransactionMgr.ThreadTransactionMgr().BeginTransaction(); emps1.Save(); emps2.Save(); TransactionMgr.ThreadTransactionMgr().CommitTransaction(); // Query.Load/MarkAsDeleted/Save emps = new CSharp.FIREBIRD.DIALECT1.EMPLOYEES(); emps.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMP1.FBD;User=SYSDBA;Password=masterkey;Dialect=1;Server=griffo"; emps.Where.FIRST_NAME.Value = "trella%"; emps.Where.FIRST_NAME.Operator = WhereParameter.Operand.Like; emps.Where.LAST_NAME.Value = "trella%"; emps.Where.LAST_NAME.Operator = WhereParameter.Operand.Like; if (!emps.Query.Load()) { return(false); // ERROR } emps.DeleteAll(); emps.Save(); } catch (Exception ex) { Console.WriteLine(ex.Message); return(false); } finally { TransactionMgr.ThreadTransactionMgrReset(); } return(true); }