public void Concurrency() { int primaryKey = 1; Assert.IsTrue(aggTest.LoadByPrimaryKey(primaryKey)); aggTest.s_HIREDATE = "2000-02-16 00:00:00"; AggregateTest obj = new AggregateTest(); obj.DatabaseInstanceName = "OracleUnitTests"; obj.DynamicQueryInstanceName = "Default Oracle"; obj.DefaultCommandType = CommandType.StoredProcedure; Assert.IsTrue(obj.LoadByPrimaryKey(primaryKey)); obj.HIREDATE = DateTime.Now; obj.Save(); aggTest.Save(); }
public static void RefreshDatabase() { AggregateTest testData = new AggregateTest(); testData.DatabaseInstanceName = "OracleUnitTests"; testData.DynamicQueryInstanceName = "Default Oracle"; testData.LoadAll(); testData.DeleteAll(); testData.Save(); int i = 1; testData.IdentityInsert = true; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "3"; testData.s_FIRSTNAME = "David"; testData.s_LASTNAME = "Doe"; testData.s_AGE = "16"; testData.s_HIREDATE = "2000-02-16 00:00:00"; testData.s_SALARY = "34.71"; testData.s_ISACTIVE = "1"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "1"; testData.s_FIRSTNAME = "Sarah"; testData.s_LASTNAME = "McDonald"; testData.s_AGE = "28"; testData.s_HIREDATE = "1999-03-25 00:00:00"; testData.s_SALARY = "11.06"; testData.s_ISACTIVE = "1"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "3"; testData.s_FIRSTNAME = "David"; testData.s_LASTNAME = "Vincent"; testData.s_AGE = "43"; testData.s_HIREDATE = "2000-10-17 00:00:00"; testData.s_SALARY = "10.27"; testData.s_ISACTIVE = "0"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "2"; testData.s_FIRSTNAME = "Fred"; testData.s_LASTNAME = "Smith"; testData.s_AGE = "15"; testData.s_HIREDATE = "1999-03-15 00:00:00"; testData.s_SALARY = "15.15"; testData.s_ISACTIVE = "1"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "3"; testData.s_FIRSTNAME = "Sally"; testData.s_LASTNAME = "Johnson"; testData.s_AGE = "30"; testData.s_HIREDATE = "2000-10-07 00:00:00"; testData.s_SALARY = "14.36"; testData.s_ISACTIVE = "1"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "5"; testData.s_FIRSTNAME = "Jane"; testData.s_LASTNAME = "Rapaport"; testData.s_AGE = "44"; testData.s_HIREDATE = "2002-05-02 00:00:00"; testData.s_SALARY = "13.56"; testData.s_ISACTIVE = "0"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "4"; testData.s_FIRSTNAME = "Paul"; testData.s_LASTNAME = "Gellar"; testData.s_AGE = "16"; testData.s_HIREDATE = "2000-09-27 00:00:00"; testData.s_SALARY = "18.44"; testData.s_ISACTIVE = "1"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "2"; testData.s_FIRSTNAME = "John"; testData.s_LASTNAME = "Jones"; testData.s_AGE = "31"; testData.s_HIREDATE = "2002-04-22 00:00:00"; testData.s_SALARY = "17.65"; testData.s_ISACTIVE = "1"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "3"; testData.s_FIRSTNAME = "Michelle"; testData.s_LASTNAME = "Johnson"; testData.s_AGE = "45"; testData.s_HIREDATE = "2003-11-14 00:00:00"; testData.s_SALARY = "16.86"; testData.s_ISACTIVE = "0"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "2"; testData.s_FIRSTNAME = "David"; testData.s_LASTNAME = "Costner"; testData.s_AGE = "17"; testData.s_HIREDATE = "2002-04-11 00:00:00"; testData.s_SALARY = "21.74"; testData.s_ISACTIVE = "1"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "4"; testData.s_FIRSTNAME = "William"; testData.s_LASTNAME = "Gellar"; testData.s_AGE = "32"; testData.s_HIREDATE = "2003-11-04 00:00:00"; testData.s_SALARY = "20.94"; testData.s_ISACTIVE = "0"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "3"; testData.s_FIRSTNAME = "Sally"; testData.s_LASTNAME = "Rapaport"; testData.s_AGE = "39"; testData.s_HIREDATE = "2002-04-01 00:00:00"; testData.s_SALARY = "25.82"; testData.s_ISACTIVE = "1"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "5"; testData.s_FIRSTNAME = "Jane"; testData.s_LASTNAME = "Vincent"; testData.s_AGE = "18"; testData.s_HIREDATE = "2003-10-25 00:00:00"; testData.s_SALARY = "25.03"; testData.s_ISACTIVE = "1"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "2"; testData.s_FIRSTNAME = "Fred"; testData.s_LASTNAME = "Costner"; testData.s_AGE = "33"; testData.s_HIREDATE = "1998-05-20 00:00:00"; testData.s_SALARY = "24.24"; testData.s_ISACTIVE = "0"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "1"; testData.s_FIRSTNAME = "John"; testData.s_LASTNAME = "Johnson"; testData.s_AGE = "40"; testData.s_HIREDATE = "2003-10-15 00:00:00"; testData.s_SALARY = "29.12"; testData.s_ISACTIVE = "1"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "3"; testData.s_FIRSTNAME = "Michelle"; testData.s_LASTNAME = "Rapaport"; testData.s_AGE = "19"; testData.s_HIREDATE = "1998-05-10 00:00:00"; testData.s_SALARY = "28.32"; testData.s_ISACTIVE = "1"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "4"; testData.s_FIRSTNAME = "Sarah"; testData.s_LASTNAME = "Doe"; testData.s_AGE = "34"; testData.s_HIREDATE = "1999-12-03 00:00:00"; testData.s_SALARY = "27.53"; testData.s_ISACTIVE = "0"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "4"; testData.s_FIRSTNAME = "William"; testData.s_LASTNAME = "Jones"; testData.s_AGE = "41"; testData.s_HIREDATE = "1998-04-30 00:00:00"; testData.s_SALARY = "32.41"; testData.s_ISACTIVE = "1"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "1"; testData.s_FIRSTNAME = "Sarah"; testData.s_LASTNAME = "McDonald"; testData.s_AGE = "21"; testData.s_HIREDATE = "1999-11-23 00:00:00"; testData.s_SALARY = "31.62"; testData.s_ISACTIVE = "0"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "4"; testData.s_FIRSTNAME = "Jane"; testData.s_LASTNAME = "Costner"; testData.s_AGE = "28"; testData.s_HIREDATE = "1998-04-20 00:00:00"; testData.s_SALARY = "36.50"; testData.s_ISACTIVE = "1"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "2"; testData.s_FIRSTNAME = "Fred"; testData.s_LASTNAME = "Douglas"; testData.s_AGE = "42"; testData.s_HIREDATE = "1999-11-13 00:00:00"; testData.s_SALARY = "35.71"; testData.s_ISACTIVE = "1"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "3"; testData.s_FIRSTNAME = "Paul"; testData.s_LASTNAME = "Jones"; testData.s_AGE = "22"; testData.s_HIREDATE = "2001-06-07 00:00:00"; testData.s_SALARY = "34.91"; testData.s_ISACTIVE = "0"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "3"; testData.s_FIRSTNAME = "Michelle"; testData.s_LASTNAME = "Doe"; testData.s_AGE = "29"; testData.s_HIREDATE = "1999-11-03 00:00:00"; testData.s_SALARY = "39.79"; testData.s_ISACTIVE = "1"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "4"; testData.s_FIRSTNAME = "Paul"; testData.s_LASTNAME = "Costner"; testData.s_AGE = "43"; testData.s_HIREDATE = "2001-05-28 00:00:00"; testData.s_SALARY = "39.00"; testData.s_ISACTIVE = "1"; testData.AddNew(); testData.s_ID = i++.ToString(); testData.AddNew(); testData.s_ID = i++.ToString(); testData.AddNew(); testData.s_ID = i++.ToString(); testData.AddNew(); testData.s_ID = i++.ToString(); testData.AddNew(); testData.s_ID = i++.ToString(); testData.AddNew(); testData.s_ID = i++.ToString(); testData.s_DEPARTMENTID = "0"; testData.s_FIRSTNAME = ""; testData.s_LASTNAME = ""; testData.s_AGE = "0"; testData.s_SALARY = "0"; testData.Save(); }