public void Insert() { aggTest.AddNew(); Assert.IsFalse(aggTest.IsColumnNull(AggregateTestSchema.IsActive.FieldName)); Assert.IsFalse(aggTest.IsColumnNull(AggregateTestSchema.IsActive2.FieldName)); Assert.IsFalse(aggTest.IsColumnNull(AggregateTestSchema.DateCreated.FieldName)); aggTest.s_DepartmentID = "3"; aggTest.s_FirstName = "John"; aggTest.s_LastName = "Doe"; aggTest.s_Age = "30"; aggTest.s_HireDate = "2000-02-16 00:00:00"; aggTest.s_Salary = "34.71"; aggTest.s_IsActive = "true"; aggTest.s_IsActive2 = "Y"; aggTest.Save(); Assert.IsFalse(aggTest.IsColumnNull(AggregateTestSchema.ID.FieldName)); Assert.IsFalse(aggTest.IsColumnNull(AggregateTestSchema.Ts.FieldName)); aggTest.AddNew(); Assert.IsFalse(aggTest.IsColumnNull(AggregateTestSchema.IsActive.FieldName)); Assert.IsFalse(aggTest.IsColumnNull(AggregateTestSchema.IsActive2.FieldName)); Assert.IsFalse(aggTest.IsColumnNull(AggregateTestSchema.DateCreated.FieldName)); aggTest.s_DepartmentID = "3"; aggTest.s_FirstName = "Matt"; aggTest.s_LastName = "Noonan"; aggTest.s_Age = "35"; aggTest.s_HireDate = "2003-01-01 00:00:00"; aggTest.s_Salary = "65"; aggTest.s_IsActive = "false"; aggTest.s_IsActive2 = "N"; aggTest.Save(); Assert.IsFalse(aggTest.IsColumnNull(AggregateTestSchema.ID.FieldName)); Assert.IsFalse(aggTest.IsColumnNull(AggregateTestSchema.Ts.FieldName)); aggTest.GetChanges(); Assert.AreEqual(0, aggTest.RowCount); }
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.DefaultCommandType = CommandType.Text; Assert.IsTrue(obj.LoadByPrimaryKey(primaryKey)); obj.HireDate = DateTime.Now; obj.Save(); aggTest.Save(); }
private static void RefreshAggregateTest() { AggregateTest obj = new AggregateTest(); obj.DatabaseInstanceName = "SQLUnitTests"; obj.DefaultCommandType = System.Data.CommandType.Text; obj.LoadAll(); obj.DeleteAll(); obj.Save(); // Turn IDENTITY insert on obj.IdentityInsert = true; int i = 1; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "3"; obj.s_FirstName = "David"; obj.s_LastName = "Doe"; obj.s_Age = "16"; obj.s_HireDate = "2000-02-16 00:00:00"; obj.s_Salary = "34.71"; obj.s_IsActive = "true"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "1"; obj.s_FirstName = "Sarah"; obj.s_LastName = "McDonald"; obj.s_Age = "28"; obj.s_HireDate = "1999-03-25 00:00:00"; obj.s_Salary = "11.06"; obj.s_IsActive = "true"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "3"; obj.s_FirstName = "David"; obj.s_LastName = "Vincent"; obj.s_Age = "43"; obj.s_HireDate = "2000-10-17 00:00:00"; obj.s_Salary = "10.27"; obj.s_IsActive = "false"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "2"; obj.s_FirstName = "Fred"; obj.s_LastName = "Smith"; obj.s_Age = "15"; obj.s_HireDate = "1999-03-15 00:00:00"; obj.s_Salary = "15.15"; obj.s_IsActive = "true"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "3"; obj.s_FirstName = "Sally"; obj.s_LastName = "Johnson"; obj.s_Age = "30"; obj.s_HireDate = "2000-10-07 00:00:00"; obj.s_Salary = "14.36"; obj.s_IsActive = "true"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "5"; obj.s_FirstName = "Jane"; obj.s_LastName = "Rapaport"; obj.s_Age = "44"; obj.s_HireDate = "2002-05-02 00:00:00"; obj.s_Salary = "13.56"; obj.s_IsActive = "false"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "4"; obj.s_FirstName = "Paul"; obj.s_LastName = "Gellar"; obj.s_Age = "16"; obj.s_HireDate = "2000-09-27 00:00:00"; obj.s_Salary = "18.44"; obj.s_IsActive = "true"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "2"; obj.s_FirstName = "John"; obj.s_LastName = "Jones"; obj.s_Age = "31"; obj.s_HireDate = "2002-04-22 00:00:00"; obj.s_Salary = "17.65"; obj.s_IsActive = "true"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "3"; obj.s_FirstName = "Michelle"; obj.s_LastName = "Johnson"; obj.s_Age = "45"; obj.s_HireDate = "2003-11-14 00:00:00"; obj.s_Salary = "16.86"; obj.s_IsActive = "false"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "2"; obj.s_FirstName = "David"; obj.s_LastName = "Costner"; obj.s_Age = "17"; obj.s_HireDate = "2002-04-11 00:00:00"; obj.s_Salary = "21.74"; obj.s_IsActive = "true"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "4"; obj.s_FirstName = "William"; obj.s_LastName = "Gellar"; obj.s_Age = "32"; obj.s_HireDate = "2003-11-04 00:00:00"; obj.s_Salary = "20.94"; obj.s_IsActive = "false"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "3"; obj.s_FirstName = "Sally"; obj.s_LastName = "Rapaport"; obj.s_Age = "39"; obj.s_HireDate = "2002-04-01 00:00:00"; obj.s_Salary = "25.82"; obj.s_IsActive = "true"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "5"; obj.s_FirstName = "Jane"; obj.s_LastName = "Vincent"; obj.s_Age = "18"; obj.s_HireDate = "2003-10-25 00:00:00"; obj.s_Salary = "25.03"; obj.s_IsActive = "true"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "2"; obj.s_FirstName = "Fred"; obj.s_LastName = "Costner"; obj.s_Age = "33"; obj.s_HireDate = "1998-05-20 00:00:00"; obj.s_Salary = "24.24"; obj.s_IsActive = "false"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "1"; obj.s_FirstName = "John"; obj.s_LastName = "Johnson"; obj.s_Age = "40"; obj.s_HireDate = "2003-10-15 00:00:00"; obj.s_Salary = "29.12"; obj.s_IsActive = "true"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "3"; obj.s_FirstName = "Michelle"; obj.s_LastName = "Rapaport"; obj.s_Age = "19"; obj.s_HireDate = "1998-05-10 00:00:00"; obj.s_Salary = "28.32"; obj.s_IsActive = "true"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "4"; obj.s_FirstName = "Sarah"; obj.s_LastName = "Doe"; obj.s_Age = "34"; obj.s_HireDate = "1999-12-03 00:00:00"; obj.s_Salary = "27.53"; obj.s_IsActive = "false"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "4"; obj.s_FirstName = "William"; obj.s_LastName = "Jones"; obj.s_Age = "41"; obj.s_HireDate = "1998-04-30 00:00:00"; obj.s_Salary = "32.41"; obj.s_IsActive = "true"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "1"; obj.s_FirstName = "Sarah"; obj.s_LastName = "McDonald"; obj.s_Age = "21"; obj.s_HireDate = "1999-11-23 00:00:00"; obj.s_Salary = "31.62"; obj.s_IsActive = "false"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "4"; obj.s_FirstName = "Jane"; obj.s_LastName = "Costner"; obj.s_Age = "28"; obj.s_HireDate = "1998-04-20 00:00:00"; obj.s_Salary = "36.50"; obj.s_IsActive = "true"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "2"; obj.s_FirstName = "Fred"; obj.s_LastName = "Douglas"; obj.s_Age = "42"; obj.s_HireDate = "1999-11-13 00:00:00"; obj.s_Salary = "35.71"; obj.s_IsActive = "true"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "3"; obj.s_FirstName = "Paul"; obj.s_LastName = "Jones"; obj.s_Age = "22"; obj.s_HireDate = "2001-06-07 00:00:00"; obj.s_Salary = "34.91"; obj.s_IsActive = "false"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "3"; obj.s_FirstName = "Michelle"; obj.s_LastName = "Doe"; obj.s_Age = "29"; obj.s_HireDate = "1999-11-03 00:00:00"; obj.s_Salary = "39.79"; obj.s_IsActive = "true"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "4"; obj.s_FirstName = "Paul"; obj.s_LastName = "Costner"; obj.s_Age = "43"; obj.s_HireDate = "2001-05-28 00:00:00"; obj.s_Salary = "39.00"; obj.s_IsActive = "true"; obj.AddNew(); obj.s_ID = i++.ToString(); obj.AddNew(); obj.s_ID = i++.ToString(); obj.AddNew(); obj.s_ID = i++.ToString(); obj.AddNew(); obj.s_ID = i++.ToString(); obj.AddNew(); obj.s_ID = i++.ToString(); obj.AddNew(); obj.s_ID = i++.ToString(); obj.s_DepartmentID = "0"; obj.s_FirstName = ""; obj.s_LastName = ""; obj.s_Age = "0"; obj.s_Salary = "0"; obj.Save(); }