public void SerializeDeserialize()
        {
            aggTest.LoadAll();
            aggTest.LastName = "Griffinski";
            aggTest.GetChanges();
            string str = aggTest.Serialize();

            aggClone.Deserialize(str);
            Assert.AreEqual(1, aggClone.RowCount);
            Assert.AreEqual("Modified", aggClone.RowState().ToString());
            Assert.AreEqual("Griffinski", aggClone.s_LastName);
        }
        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);
        }