static bool FIREBIRD_3_TRUE() { try { // LoadAll CSharp.FIREBIRD.DIALECT3_TRUE.Employees emps = new CSharp.FIREBIRD.DIALECT3_TRUE.Employees(); emps.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMPTRUE3.FDB;User=SYSDBA;Password=masterkey;Dialect=3;Server=griffo"; if(!emps.LoadAll()) { return false; // ERROR } // LoadByPrimaryKey long id = emps.EmployeeID; emps = new CSharp.FIREBIRD.DIALECT3_TRUE.Employees(); emps.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMPTRUE3.FDB;User=SYSDBA;Password=masterkey;Dialect=3;Server=griffo"; if(!emps.LoadByPrimaryKey(id)) { return false; // ERROR } // AddNew/Save emps = new CSharp.FIREBIRD.DIALECT3_TRUE.Employees(); emps.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMPTRUE3.FDB;User=SYSDBA;Password=masterkey;Dialect=3;Server=griffo"; emps.AddNew(); emps.FirstName = "trella1"; emps.LastName = "trella1"; emps.AddNew(); emps.FirstName = "trella2"; emps.LastName = "trella2"; emps.Save(); // Query.Load/Update/Save emps = new CSharp.FIREBIRD.DIALECT3_TRUE.Employees(); emps.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMPTRUE3.FDB;User=SYSDBA;Password=masterkey;Dialect=3;Server=griffo"; emps.Where.FirstName.Value = "trella%"; emps.Where.FirstName.Operator = WhereParameter.Operand.Like; emps.Where.LastName.Value = "trella%"; emps.Where.LastName.Operator = WhereParameter.Operand.Like; if(!emps.Query.Load()) { return false; // ERROR } do emps.LastName = emps.LastName + ":new"; while(emps.MoveNext()); emps.Save(); // Transaction CSharp.FIREBIRD.DIALECT3_TRUE.Employees emps1 = new CSharp.FIREBIRD.DIALECT3_TRUE.Employees(); emps1.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMPTRUE3.FDB;User=SYSDBA;Password=masterkey;Dialect=3;Server=griffo"; emps1.AddNew(); emps1.FirstName = "trella1_tx1"; emps1.LastName = "trella1_tx1"; CSharp.FIREBIRD.DIALECT3_TRUE.Employees emps2 = new CSharp.FIREBIRD.DIALECT3_TRUE.Employees(); emps2.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMPTRUE3.FDB;User=SYSDBA;Password=masterkey;Dialect=3;Server=griffo"; emps2.AddNew(); emps2.FirstName = "trella1_tx2"; emps2.LastName = "trella1_tx2"; TransactionMgr.ThreadTransactionMgr().BeginTransaction(); emps1.Save(); emps2.Save(); TransactionMgr.ThreadTransactionMgr().CommitTransaction(); // Query.Load/MarkAsDeleted/Save emps = new CSharp.FIREBIRD.DIALECT3_TRUE.Employees(); emps.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMPTRUE3.FDB;User=SYSDBA;Password=masterkey;Dialect=3;Server=griffo"; emps.Where.FirstName.Value = "trella%"; emps.Where.FirstName.Operator = WhereParameter.Operand.Like; emps.Where.LastName.Value = "trella%"; emps.Where.LastName.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_3_TRUE() { try { // LoadAll CSharp.FIREBIRD.DIALECT3_TRUE.Employees emps = new CSharp.FIREBIRD.DIALECT3_TRUE.Employees(); emps.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMPTRUE3.FDB;User=SYSDBA;Password=masterkey;Dialect=3;Server=griffo"; if (!emps.LoadAll()) { return(false); // ERROR } // LoadByPrimaryKey long id = emps.EmployeeID; emps = new CSharp.FIREBIRD.DIALECT3_TRUE.Employees(); emps.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMPTRUE3.FDB;User=SYSDBA;Password=masterkey;Dialect=3;Server=griffo"; if (!emps.LoadByPrimaryKey(id)) { return(false); // ERROR } // AddNew/Save emps = new CSharp.FIREBIRD.DIALECT3_TRUE.Employees(); emps.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMPTRUE3.FDB;User=SYSDBA;Password=masterkey;Dialect=3;Server=griffo"; emps.AddNew(); emps.FirstName = "trella1"; emps.LastName = "trella1"; emps.AddNew(); emps.FirstName = "trella2"; emps.LastName = "trella2"; emps.Save(); // Query.Load/Update/Save emps = new CSharp.FIREBIRD.DIALECT3_TRUE.Employees(); emps.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMPTRUE3.FDB;User=SYSDBA;Password=masterkey;Dialect=3;Server=griffo"; emps.Where.FirstName.Value = "trella%"; emps.Where.FirstName.Operator = WhereParameter.Operand.Like; emps.Where.LastName.Value = "trella%"; emps.Where.LastName.Operator = WhereParameter.Operand.Like; if (!emps.Query.Load()) { return(false); // ERROR } do { emps.LastName = emps.LastName + ":new"; }while(emps.MoveNext()); emps.Save(); // Transaction CSharp.FIREBIRD.DIALECT3_TRUE.Employees emps1 = new CSharp.FIREBIRD.DIALECT3_TRUE.Employees(); emps1.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMPTRUE3.FDB;User=SYSDBA;Password=masterkey;Dialect=3;Server=griffo"; emps1.AddNew(); emps1.FirstName = "trella1_tx1"; emps1.LastName = "trella1_tx1"; CSharp.FIREBIRD.DIALECT3_TRUE.Employees emps2 = new CSharp.FIREBIRD.DIALECT3_TRUE.Employees(); emps2.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMPTRUE3.FDB;User=SYSDBA;Password=masterkey;Dialect=3;Server=griffo"; emps2.AddNew(); emps2.FirstName = "trella1_tx2"; emps2.LastName = "trella1_tx2"; TransactionMgr.ThreadTransactionMgr().BeginTransaction(); emps1.Save(); emps2.Save(); TransactionMgr.ThreadTransactionMgr().CommitTransaction(); // Query.Load/MarkAsDeleted/Save emps = new CSharp.FIREBIRD.DIALECT3_TRUE.Employees(); emps.ConnectionString = @"Database=C:\dOOdad_UnitTesting\EMPTRUE3.FDB;User=SYSDBA;Password=masterkey;Dialect=3;Server=griffo"; emps.Where.FirstName.Value = "trella%"; emps.Where.FirstName.Operator = WhereParameter.Operand.Like; emps.Where.LastName.Value = "trella%"; emps.Where.LastName.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); }