public jsResponse<EmployeesCollection, Employees> EmployeesCollection_LoadAll()
        {
            jsResponse<EmployeesCollection, Employees> response = new jsResponse<EmployeesCollection, Employees>();

            try
            {
                EmployeesQuery q = new EmployeesQuery();
                q.Select(q.EmployeeID, q.FirstName, q.LastName);

                EmployeesCollection collection = new EmployeesCollection();
                collection.Load(q);

                if(collection.Count == 0)
                {
                    EnsureData();

                    collection = new EmployeesCollection();
                    collection.LoadAll();
                }

                response.collection = collection;
            }
            catch (Exception ex)
            {
                response.exception = ex.Message;
            }

            return response;
        }

		public jsResponse<CategoriesCollection, Categories> CategoriesCollection_Save(CategoriesCollection collection)
		{
			jsResponse<CategoriesCollection, Categories> response = new jsResponse<CategoriesCollection, Categories>();

			try
			{
				collection.Save();
				response.collection = collection;
			}
			catch (Exception ex)
			{
				response.exception = ex.Message;
			}

			return response;
		}

        public jsResponse<EmployeesCollection, Employees> EmployeesCollection_Save(EmployeesCollection collection)
        {
            jsResponse<EmployeesCollection, Employees> response = new jsResponse<EmployeesCollection, Employees>();

            try
            {
                collection.Save();
                response.collection = collection;
            }
            catch (Exception ex)
            {
                response.exception = ex.Message;
            }

            return response;
        }

		public jsResponse<CategoriesCollection, Categories> CategoriesCollection_LoadAll()
		{
			jsResponse<CategoriesCollection, Categories> response = new jsResponse<CategoriesCollection, Categories>();

			try
			{
				CategoriesCollection collection = new CategoriesCollection();
				collection.LoadAll();
				response.collection = collection;
			}
			catch (Exception ex)
			{
				response.exception = ex.Message;
			}

			return response;
		}

		public jsResponse<CategoriesCollection, Categories> Categories_LoadByPrimaryKey(System.Int32 categoryID)
		{
			jsResponse<CategoriesCollection, Categories> response = new jsResponse<CategoriesCollection, Categories>();

			try
			{
				Categories entity = new Categories();
				if (entity.LoadByPrimaryKey(categoryID))
				{
					response.entity = entity;
				}
			}
			catch (Exception ex)
			{
				response.exception = ex.Message;
			}

			return response;
		}

        public jsResponse<EmployeesCollection, Employees> Employees_LoadHierarchical()
        {
            jsResponse<EmployeesCollection, Employees> response = new jsResponse<EmployeesCollection, Employees>();

            try
            {
                // The Main Query
                EmployeesQuery q = new EmployeesQuery("e");
                q.Select(q.EmployeeID, q.FirstName, q.LastName, q.City, q.Country, q.HomePhone, q.Region, q.PostalCode, q.Title);
                q.Where(q.EmployeeID < 7);

                // The OrdersCollection
                OrdersQuery o1 = q.Prefetch<OrdersQuery>(Employees.Prefetch_OrdersCollectionByEmployeeID);
                EmployeesQuery emp1 = o1.GetQuery<EmployeesQuery>();
                o1.Where(emp1.EmployeeID < 7);

                // The OrdersDetailsCollection
                OrderDetailsQuery od = q.Prefetch<OrderDetailsQuery>(Employees.Prefetch_OrdersCollectionByEmployeeID, Orders.Prefetch_OrderDetailsCollectionByOrderID);
                EmployeesQuery emp2 = od.GetQuery<EmployeesQuery>();
                OrdersQuery o2 = od.GetQuery<OrdersQuery>();
                od.Where(emp2.EmployeeID < 7);

                // Load It
                EmployeesCollection coll = new EmployeesCollection();
                if (coll.Load(q))
                {
                    response.collection = coll;

                    response.columnCollection["Employees"] = jsColumn.PopulateColumns(coll[0]);
                    response.columnCollection["Orders"] = jsColumn.PopulateColumns(coll[0].OrdersCollectionByEmployeeID[0]);
                    response.columnCollection["OrderDetails"] = jsColumn.PopulateColumns(coll[0].OrdersCollectionByEmployeeID[0].OrderDetailsCollectionByOrderID[0]);
                }
            }
            catch (Exception ex)
            {
                response.exception = ex.Message;
            }

            return response;
        }

		public jsResponse<OrdersCollection, Orders> OrdersCollection_LoadAll()
		{
			jsResponse<OrdersCollection, Orders> response = new jsResponse<OrdersCollection, Orders>();

			try
			{
				OrdersCollection collection = new OrdersCollection();
				collection.LoadAll();
				response.collection = collection;
			}
			catch (Exception ex)
			{
				response.exception = ex.Message;
			}

			return response;
		}

		public jsResponse<TerritoriesCollection, Territories> EmployeeTerritories_UpToTerritoriesByTerritoryID(System.Int32 employeeID, System.String territoryID)
		{
			jsResponse<TerritoriesCollection, Territories> response = new jsResponse<TerritoriesCollection, Territories>();

			try
			{
				EmployeeTerritories entity = new EmployeeTerritories();
				entity.EmployeeID = employeeID;
				entity.TerritoryID = territoryID;
				response.entity = entity.UpToTerritoriesByTerritoryID;
			}
			catch (Exception ex)
			{
				response.exception = ex.Message;
			}

			return response;		
		}

		public jsResponse<ProductsCollection, Products> OrderDetails_UpToProductsByProductID(System.Int32 orderID, System.Int32 productID)
		{
			jsResponse<ProductsCollection, Products> response = new jsResponse<ProductsCollection, Products>();

			try
			{
				OrderDetails entity = new OrderDetails();
				entity.OrderID = orderID;
				entity.ProductID = productID;
				response.entity = entity.UpToProductsByProductID;
			}
			catch (Exception ex)
			{
				response.exception = ex.Message;
			}

			return response;		
		}

		public jsResponse<EmployeeTerritoriesCollection, EmployeeTerritories> EmployeeTerritoriesCollection_LoadAll()
		{
			jsResponse<EmployeeTerritoriesCollection, EmployeeTerritories> response = new jsResponse<EmployeeTerritoriesCollection, EmployeeTerritories>();

			try
			{
				EmployeeTerritoriesCollection collection = new EmployeeTerritoriesCollection();
				collection.LoadAll();
				response.collection = collection;
			}
			catch (Exception ex)
			{
				response.exception = ex.Message;
			}

			return response;
		}

		public jsResponse<CustomerCustomerDemoCollection, CustomerCustomerDemo> CustomerCustomerDemo_LoadByPrimaryKey(System.String customerID, System.String customerTypeID)
		{
			jsResponse<CustomerCustomerDemoCollection, CustomerCustomerDemo> response = new jsResponse<CustomerCustomerDemoCollection, CustomerCustomerDemo>();

			try
			{
				CustomerCustomerDemo entity = new CustomerCustomerDemo();
				if (entity.LoadByPrimaryKey(customerID, customerTypeID))
				{
					response.entity = entity;
				}
			}
			catch (Exception ex)
			{
				response.exception = ex.Message;
			}

			return response;
		}

		public jsResponse<OrdersCollection, Orders> Orders_LoadByPrimaryKey(System.Int32 orderID)
		{
			jsResponse<OrdersCollection, Orders> response = new jsResponse<OrdersCollection, Orders>();

			try
			{
				Orders entity = new Orders();
				if (entity.LoadByPrimaryKey(orderID))
				{
					response.entity = entity;
				}
			}
			catch (Exception ex)
			{
				response.exception = ex.Message;
			}

			return response;
		}

		public jsResponse<CustomerDemographicsCollection, CustomerDemographics> CustomerDemographicsCollection_Save(CustomerDemographicsCollection collection)
		{
			jsResponse<CustomerDemographicsCollection, CustomerDemographics> response = new jsResponse<CustomerDemographicsCollection, CustomerDemographics>();

			try
			{
				collection.Save();
				response.collection = collection;
			}
			catch (Exception ex)
			{
				response.exception = ex.Message;
			}

			return response;
		}

		public jsResponse<OrdersCollection, Orders> Customers_OrdersCollectionByCustomerID(System.String customerID)
		{
			jsResponse<OrdersCollection, Orders> response = new jsResponse<OrdersCollection, Orders>();

			try
			{
				Customers entity = new Customers();
				entity.CustomerID = customerID;
				response.collection = entity.OrdersCollectionByCustomerID;
			}
			catch (Exception ex)
			{
				response.exception = ex.Message;
			}

			return response;		
		}

        public jsResponse<EmployeesCollection, Employees> Employees_Save(Employees entity)
        {
            jsResponse<EmployeesCollection, Employees> response = new jsResponse<EmployeesCollection, Employees>();

            try
            {
                entity.Save();
                response.entity = entity;
            }
            catch (Exception ex)
            {
                response.exception = ex.Message;
            }

            return response;
        }

		public jsResponse<CustomersCollection, Customers> Customers_LoadByPrimaryKey(System.String customerID)
		{
			jsResponse<CustomersCollection, Customers> response = new jsResponse<CustomersCollection, Customers>();

			try
			{
				Customers entity = new Customers();
				if (entity.LoadByPrimaryKey(customerID))
				{
					response.entity = entity;
				}
			}
			catch (Exception ex)
			{
				response.exception = ex.Message;
			}

			return response;
		}

		public jsResponse<CustomerDemographicsCollection, CustomerDemographics> Customers_UpToCustomerDemographicsCollection(System.String customerID)
		{
			jsResponse<CustomerDemographicsCollection, CustomerDemographics> response = new jsResponse<CustomerDemographicsCollection, CustomerDemographics>();

			try
			{
				Customers entity = new Customers();
				entity.CustomerID = customerID;
				response.collection = entity.UpToCustomerDemographicsCollection;
			}
			catch (Exception ex)
			{
				response.exception = ex.Message;
			}

			return response;		
		}

		public jsResponse<CustomersCollection, Customers> CustomerCustomerDemo_UpToCustomersByCustomerID(System.String customerID, System.String customerTypeID)
		{
			jsResponse<CustomersCollection, Customers> response = new jsResponse<CustomersCollection, Customers>();

			try
			{
				CustomerCustomerDemo entity = new CustomerCustomerDemo();
				entity.CustomerID = customerID;
				entity.CustomerTypeID = customerTypeID;
				response.entity = entity.UpToCustomersByCustomerID;
			}
			catch (Exception ex)
			{
				response.exception = ex.Message;
			}

			return response;		
		}

		public jsResponse<CustomerCustomerDemoCollection, CustomerCustomerDemo> CustomerDemographics_CustomerCustomerDemoCollectionByCustomerTypeID(System.String customerTypeID)
		{
			jsResponse<CustomerCustomerDemoCollection, CustomerCustomerDemo> response = new jsResponse<CustomerCustomerDemoCollection, CustomerCustomerDemo>();

			try
			{
				CustomerDemographics entity = new CustomerDemographics();
				entity.CustomerTypeID = customerTypeID;
				response.collection = entity.CustomerCustomerDemoCollectionByCustomerTypeID;
			}
			catch (Exception ex)
			{
				response.exception = ex.Message;
			}

			return response;		
		}

		public jsResponse<CustomerDemographicsCollection, CustomerDemographics> CustomerDemographics_Save(CustomerDemographics entity)
		{
			jsResponse<CustomerDemographicsCollection, CustomerDemographics> response = new jsResponse<CustomerDemographicsCollection, CustomerDemographics>();

			try
			{
				entity.Save();
				response.entity = entity;
			}
			catch (Exception ex)
			{
				response.exception = ex.Message;
			}

			return response;
		}