/// <summary>
		/// Test Find using the Query class
		/// </summary>
		private void Step_30_TestFindByQuery_Generated()
		{
			using (TransactionManager tm = CreateTransaction())
			{
				//Insert Mock Instance
				TestProduct mock = CreateMockInstance(tm);
				bool result = DataRepository.TestProductProvider.Insert(tm, mock);
				
				Assert.IsTrue(result, "Could Not Test FindByQuery, Insert Failed");

				TestProductQuery query = new TestProductQuery();
			
				if(mock.ProductTypeId != null)
					query.AppendEquals(TestProductColumn.ProductTypeId, mock.ProductTypeId.ToString());
				if(mock.DownloadId != null)
					query.AppendEquals(TestProductColumn.DownloadId, mock.DownloadId.ToString());
				if(mock.ManufacturerId != null)
					query.AppendEquals(TestProductColumn.ManufacturerId, mock.ManufacturerId.ToString());
				if(mock.BrandName != null)
					query.AppendEquals(TestProductColumn.BrandName, mock.BrandName.ToString());
				if(mock.ProductName != null)
					query.AppendEquals(TestProductColumn.ProductName, mock.ProductName.ToString());
				if(mock.ProductCode != null)
					query.AppendEquals(TestProductColumn.ProductCode, mock.ProductCode.ToString());
				if(mock.UniqueIdentifier != null)
					query.AppendEquals(TestProductColumn.UniqueIdentifier, mock.UniqueIdentifier.ToString());
				if(mock.TypeName != null)
					query.AppendEquals(TestProductColumn.TypeName, mock.TypeName.ToString());
				if(mock.ModelName != null)
					query.AppendEquals(TestProductColumn.ModelName, mock.ModelName.ToString());
				if(mock.DisplayName != null)
					query.AppendEquals(TestProductColumn.DisplayName, mock.DisplayName.ToString());
				if(mock.ProductLink != null)
					query.AppendEquals(TestProductColumn.ProductLink, mock.ProductLink.ToString());
				if(mock.ConnectorCode != null)
					query.AppendEquals(TestProductColumn.ConnectorCode, mock.ConnectorCode.ToString());
				if(mock.BaseId != null)
					query.AppendEquals(TestProductColumn.BaseId, mock.BaseId.ToString());
				if(mock.OrgProductId != null)
					query.AppendEquals(TestProductColumn.OrgProductId, mock.OrgProductId.ToString());
				if(mock.ImageFileType != null)
					query.AppendEquals(TestProductColumn.ImageFileType, mock.ImageFileType.ToString());
				if(mock.FullImageFileType != null)
					query.AppendEquals(TestProductColumn.FullImageFileType, mock.FullImageFileType.ToString());
				if(mock.Status != null)
					query.AppendEquals(TestProductColumn.Status, mock.Status.ToString());
				if(mock.AddedBy != null)
					query.AppendEquals(TestProductColumn.AddedBy, mock.AddedBy.ToString());
				if(mock.AddedDate != null)
					query.AppendEquals(TestProductColumn.AddedDate, mock.AddedDate.ToString());
				if(mock.UpdatedBy != null)
					query.AppendEquals(TestProductColumn.UpdatedBy, mock.UpdatedBy.ToString());
				if(mock.UpdatedDate != null)
					query.AppendEquals(TestProductColumn.UpdatedDate, mock.UpdatedDate.ToString());
				
				TList<TestProduct> results = DataRepository.TestProductProvider.Find(tm, query);
				
				Assert.IsTrue(results.Count == 1, "Find is not working correctly.  Failed to find the mock instance");
			}
		}
        /// <summary>
        /// Test Find using the Query class
        /// </summary>
        private void Step_30_TestFindByQuery_Generated()
        {
            using (TransactionManager tm = CreateTransaction())
            {
                //Insert Mock Instance
                TestProduct mock   = CreateMockInstance(tm);
                bool        result = DataRepository.TestProductProvider.Insert(tm, mock);

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

                TestProductQuery query = new TestProductQuery();

                if (mock.ProductTypeId != null)
                {
                    query.AppendEquals(TestProductColumn.ProductTypeId, mock.ProductTypeId.ToString());
                }
                if (mock.DownloadId != null)
                {
                    query.AppendEquals(TestProductColumn.DownloadId, mock.DownloadId.ToString());
                }
                if (mock.ManufacturerId != null)
                {
                    query.AppendEquals(TestProductColumn.ManufacturerId, mock.ManufacturerId.ToString());
                }
                if (mock.BrandName != null)
                {
                    query.AppendEquals(TestProductColumn.BrandName, mock.BrandName.ToString());
                }
                if (mock.ProductName != null)
                {
                    query.AppendEquals(TestProductColumn.ProductName, mock.ProductName.ToString());
                }
                if (mock.ProductCode != null)
                {
                    query.AppendEquals(TestProductColumn.ProductCode, mock.ProductCode.ToString());
                }
                if (mock.UniqueIdentifier != null)
                {
                    query.AppendEquals(TestProductColumn.UniqueIdentifier, mock.UniqueIdentifier.ToString());
                }
                if (mock.TypeName != null)
                {
                    query.AppendEquals(TestProductColumn.TypeName, mock.TypeName.ToString());
                }
                if (mock.ModelName != null)
                {
                    query.AppendEquals(TestProductColumn.ModelName, mock.ModelName.ToString());
                }
                if (mock.DisplayName != null)
                {
                    query.AppendEquals(TestProductColumn.DisplayName, mock.DisplayName.ToString());
                }
                if (mock.ProductLink != null)
                {
                    query.AppendEquals(TestProductColumn.ProductLink, mock.ProductLink.ToString());
                }
                if (mock.ConnectorCode != null)
                {
                    query.AppendEquals(TestProductColumn.ConnectorCode, mock.ConnectorCode.ToString());
                }
                if (mock.BaseId != null)
                {
                    query.AppendEquals(TestProductColumn.BaseId, mock.BaseId.ToString());
                }
                if (mock.OrgProductId != null)
                {
                    query.AppendEquals(TestProductColumn.OrgProductId, mock.OrgProductId.ToString());
                }
                if (mock.ImageFileType != null)
                {
                    query.AppendEquals(TestProductColumn.ImageFileType, mock.ImageFileType.ToString());
                }
                if (mock.FullImageFileType != null)
                {
                    query.AppendEquals(TestProductColumn.FullImageFileType, mock.FullImageFileType.ToString());
                }
                if (mock.Status != null)
                {
                    query.AppendEquals(TestProductColumn.Status, mock.Status.ToString());
                }
                if (mock.AddedBy != null)
                {
                    query.AppendEquals(TestProductColumn.AddedBy, mock.AddedBy.ToString());
                }
                if (mock.AddedDate != null)
                {
                    query.AppendEquals(TestProductColumn.AddedDate, mock.AddedDate.ToString());
                }
                if (mock.UpdatedBy != null)
                {
                    query.AppendEquals(TestProductColumn.UpdatedBy, mock.UpdatedBy.ToString());
                }
                if (mock.UpdatedDate != null)
                {
                    query.AppendEquals(TestProductColumn.UpdatedDate, mock.UpdatedDate.ToString());
                }

                TList <TestProduct> results = DataRepository.TestProductProvider.Find(tm, query);

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