public void LoadByPrimaryKey()
        {
            Assert.IsTrue(aggTest.Query.Load());
            int primaryKey = aggTest.ID;

            aggTest.FlushData();

            Assert.IsTrue(aggTest.LoadByPrimaryKey(primaryKey));
            Assert.AreEqual(1, 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();
        }