/// <summary>
        /// Test Find using the Query class
        /// </summary>
        private void Step_30_TestFindByQuery_Generated()
        {
            using (TransactionManager tm = CreateTransaction())
            {
                //Insert Mock Instance
                Vendor mock   = CreateMockInstance(tm);
                bool   result = DataRepository.VendorProvider.Insert(tm, mock);

                Assert.IsTrue(result, "Could Not Test FindByQuery, Insert Failed");

                VendorQuery query = new VendorQuery();

                query.AppendEquals(VendorColumn.VendorId, mock.VendorId.ToString());
                query.AppendEquals(VendorColumn.AccountNumber, mock.AccountNumber.ToString());
                query.AppendEquals(VendorColumn.Name, mock.Name.ToString());
                query.AppendEquals(VendorColumn.CreditRating, mock.CreditRating.ToString());
                query.AppendEquals(VendorColumn.PreferredVendorStatus, mock.PreferredVendorStatus.ToString());
                query.AppendEquals(VendorColumn.ActiveFlag, mock.ActiveFlag.ToString());
                if (mock.PurchasingWebServiceUrl != null)
                {
                    query.AppendEquals(VendorColumn.PurchasingWebServiceUrl, mock.PurchasingWebServiceUrl.ToString());
                }
                query.AppendEquals(VendorColumn.ModifiedDate, mock.ModifiedDate.ToString());

                TList <Vendor> results = DataRepository.VendorProvider.Find(tm, query);

                Assert.IsTrue(results.Count == 1, "Find is not working correctly.  Failed to find the mock instance");
            }
        }