Thank You for using AspxFormsGen 4.5 Professional+. Listed below are the Middle-Tier, Data-Tier, and SQL code generated by AspxFormsGen 4.5 Professional+.
All generated code listed here are located in the App_code folder, except for the Stored Procedures which are directly generated in MS SQL Server.

Business Object Classes	Features
Categories.cs CustomerDemographics.cs Customers.cs Employees.cs OrderDetails.cs Orders.cs Products.cs Region.cs Shippers.cs Suppliers.cs Territories.cs	Note: The only code you call from your application Used as the gateway middle layer object the client calls Most CRUD calls can be made in one (1) line of code Inherits from the respective BusinessObjectBase class You can add additional code here (it will not be overwritten by the generator) One Class is generated per table Located in the \BusinessObject\ folder
Business Object Base Classes	Features
CategoriesBase.cs CustomerDemographicsBase.cs CustomersBase.cs EmployeesBase.cs OrderDetailsBase.cs OrdersBase.cs ProductsBase.cs RegionBase.cs ShippersBase.cs SuppliersBase.cs TerritoriesBase.cs	Used as the base class to the Business Object class Do not add or edit code here Contains table fields as properties Encapsulates calls to the data layer One Class is generated per table Located in the \BusinessObjectBase\ folder
Business Object Collection Classes	Features
CategoriesCollection.cs CustomerDemographicsCollection.cs CustomersCollection.cs EmployeesCollection.cs OrderDetailsCollection.cs OrdersCollection.cs ProductsCollection.cs RegionCollection.cs ShippersCollection.cs SuppliersCollection.cs TerritoriesCollection.cs	Used as the Collection of the Business Object Class Do not add or edit code here One Class is generated per table Located in the \BusinessObjectCollection\ folder
Data Layer Classes	Features
CategoriesDataLayer.cs CustomerDemographicsDataLayer.cs CustomersDataLayer.cs EmployeesDataLayer.cs OrderDetailsDataLayer.cs OrdersDataLayer.cs ProductsDataLayer.cs RegionDataLayer.cs ShippersDataLayer.cs SuppliersDataLayer.cs TerritoriesDataLayer.cs	Used as the gateway data layer object the middle tier objects call Inherits from the respective DataLayerBase class You can add additional code here (it will not be overwritten by the generator) One Class is generated per table Located in the \DataLayer\ folder
Data Layer Base Classes	Features
CategoriesDataLayerBase.cs CustomerDemographicsDataLayerBase.cs CustomersDataLayerBase.cs EmployeesDataLayerBase.cs OrderDetailsDataLayerBase.cs OrdersDataLayerBase.cs ProductsDataLayerBase.cs RegionDataLayerBase.cs ShippersDataLayerBase.cs SuppliersDataLayerBase.cs TerritoriesDataLayerBase.cs	Used as the base class to the Data Layer class Do not add or edit code here Encapsulates calls to Stored Procedures or Dynamic SQL One Class is generated per table Located in the \DataLayerBase\ folder
Code Examples	Features
CategoriesExample.cs CustomerDemographicsExample.cs CustomersExample.cs EmployeesExample.cs OrderDetailsExample.cs OrdersExample.cs ProductsExample.cs RegionExample.cs ShippersExample.cs SuppliersExample.cs TerritoriesExample.cs	Generated solely to show how to use the Generated Code Example code can be copied and pasted directly to your client code (ASP.Net web forms, Win Forms, Web Services, etc.) You can delete the whole directory if you don't need it One Class is generated per table Located in the \Example\ folder
Stored Procedures	Features
[dbo].[aspx_Categories_Delete] [dbo].[aspx_Categories_GetRecordCount] [dbo].[aspx_Categories_Insert] [dbo].[aspx_Categories_SelectAll] [dbo].[aspx_Categories_SelectAllWhereDynamic] [dbo].[aspx_Categories_SelectByPrimaryKey] [dbo].[aspx_Categories_SelectDropDownListData] [dbo].[aspx_Categories_SelectSkipAndTake] [dbo].[aspx_Categories_Update] [dbo].[aspx_CustomerCustomerDemo_Delete] [dbo].[aspx_CustomerCustomerDemo_GetRecordCount] [dbo].[aspx_CustomerCustomerDemo_SelectAllByCustomerID] [dbo].[aspx_CustomerCustomerDemo_SelectAllByCustomerTypeID] [dbo].[aspx_CustomerCustomerDemo_Insert] [dbo].[aspx_CustomerCustomerDemo_SelectAll] [dbo].[aspx_CustomerCustomerDemo_SelectAllByCustomerID] [dbo].[aspx_CustomerCustomerDemo_SelectAllByCustomerTypeID] [dbo].[aspx_CustomerCustomerDemo_SelectAllWhereDynamic] [dbo].[aspx_CustomerCustomerDemo_SelectSkipAndTake] [dbo].[aspx_CustomerCustomerDemo_SelectAllByCustomerID] [dbo].[aspx_CustomerCustomerDemo_SelectAllByCustomerTypeID] [dbo].[aspx_CustomerDemographics_Delete] [dbo].[aspx_CustomerDemographics_GetRecordCount] [dbo].[aspx_CustomerDemographics_Insert] [dbo].[aspx_CustomerDemographics_SelectAll] [dbo].[aspx_CustomerDemographics_SelectAllWhereDynamic] [dbo].[aspx_CustomerDemographics_SelectByPrimaryKey] [dbo].[aspx_CustomerDemographics_SelectDropDownListData] [dbo].[aspx_CustomerDemographics_SelectSkipAndTake] [dbo].[aspx_CustomerDemographics_Update] [dbo].[aspx_Customers_Delete] [dbo].[aspx_Customers_GetRecordCount] [dbo].[aspx_Customers_Insert] [dbo].[aspx_Customers_SelectAll] [dbo].[aspx_Customers_SelectAllWhereDynamic] [dbo].[aspx_Customers_SelectByPrimaryKey] [dbo].[aspx_Customers_SelectDropDownListData] [dbo].[aspx_Customers_SelectSkipAndTake] [dbo].[aspx_Customers_Update] [dbo].[aspx_Employees_Delete] [dbo].[aspx_Employees_GetRecordCount] [dbo].[aspx_Employees_SelectAllByReportsTo] [dbo].[aspx_Employees_Insert] [dbo].[aspx_Employees_SelectAll] [dbo].[aspx_Employees_SelectAllByReportsTo] [dbo].[aspx_Employees_SelectAllWhereDynamic] [dbo].[aspx_Employees_SelectByPrimaryKey] [dbo].[aspx_Employees_SelectDropDownListData] [dbo].[aspx_Employees_SelectSkipAndTake] [dbo].[aspx_Employees_SelectAllByReportsTo] [dbo].[aspx_Employees_Update] [dbo].[aspx_EmployeeTerritories_Delete] [dbo].[aspx_EmployeeTerritories_GetRecordCount] [dbo].[aspx_EmployeeTerritories_SelectAllByEmployeeID] [dbo].[aspx_EmployeeTerritories_SelectAllByTerritoryID] [dbo].[aspx_EmployeeTerritories_Insert] [dbo].[aspx_EmployeeTerritories_SelectAll] [dbo].[aspx_EmployeeTerritories_SelectAllByEmployeeID] [dbo].[aspx_EmployeeTerritories_SelectAllByTerritoryID] [dbo].[aspx_EmployeeTerritories_SelectAllWhereDynamic] [dbo].[aspx_EmployeeTerritories_SelectSkipAndTake] [dbo].[aspx_EmployeeTerritories_SelectAllByEmployeeID] [dbo].[aspx_EmployeeTerritories_SelectAllByTerritoryID] [dbo].[aspx_OrderDetails_Delete] [dbo].[aspx_OrderDetails_GetRecordCount] [dbo].[aspx_OrderDetails_SelectAllByOrderID] [dbo].[aspx_OrderDetails_SelectAllByProductID] [dbo].[aspx_OrderDetails_Insert] [dbo].[aspx_OrderDetails_SelectAll] [dbo].[aspx_OrderDetails_SelectAllByOrderID] [dbo].[aspx_OrderDetails_SelectAllByProductID] [dbo].[aspx_OrderDetails_SelectAllWhereDynamic] [dbo].[aspx_OrderDetails_SelectByPrimaryKey] [dbo].[aspx_OrderDetails_SelectDropDownListData] [dbo].[aspx_OrderDetails_SelectSkipAndTake] [dbo].[aspx_OrderDetails_SelectAllByOrderID] [dbo].[aspx_OrderDetails_SelectAllByProductID] [dbo].[aspx_OrderDetails_SelectTotals] [dbo].[aspx_OrderDetails_Update] [dbo].[aspx_Orders_Delete] [dbo].[aspx_Orders_GetRecordCount] [dbo].[aspx_Orders_SelectAllByCustomerID] [dbo].[aspx_Orders_SelectAllByEmployeeID] [dbo].[aspx_Orders_SelectAllByShipVia] [dbo].[aspx_Orders_Insert] [dbo].[aspx_Orders_SelectAll] [dbo].[aspx_Orders_SelectAllByCustomerID] [dbo].[aspx_Orders_SelectAllByEmployeeID] [dbo].[aspx_Orders_SelectAllByShipVia] [dbo].[aspx_Orders_SelectAllWhereDynamic] [dbo].[aspx_Orders_SelectByPrimaryKey] [dbo].[aspx_Orders_SelectDropDownListData] [dbo].[aspx_Orders_SelectSkipAndTake] [dbo].[aspx_Orders_SelectAllByCustomerID] [dbo].[aspx_Orders_SelectAllByEmployeeID] [dbo].[aspx_Orders_SelectAllByShipVia] [dbo].[aspx_Orders_SelectTotals] [dbo].[aspx_Orders_Update] [dbo].[aspx_Products_Delete] [dbo].[aspx_Products_GetRecordCount] [dbo].[aspx_Products_SelectAllBySupplierID] [dbo].[aspx_Products_SelectAllByCategoryID] [dbo].[aspx_Products_Insert] [dbo].[aspx_Products_SelectAll] [dbo].[aspx_Products_SelectAllBySupplierID] [dbo].[aspx_Products_SelectAllByCategoryID] [dbo].[aspx_Products_SelectAllWhereDynamic] [dbo].[aspx_Products_SelectByPrimaryKey] [dbo].[aspx_Products_SelectDropDownListData] [dbo].[aspx_Products_SelectSkipAndTake] [dbo].[aspx_Products_SelectAllBySupplierID] [dbo].[aspx_Products_SelectAllByCategoryID] [dbo].[aspx_Products_SelectTotals] [dbo].[aspx_Products_Update] [dbo].[aspx_Region_Delete] [dbo].[aspx_Region_GetRecordCount] [dbo].[aspx_Region_Insert] [dbo].[aspx_Region_SelectAll] [dbo].[aspx_Region_SelectAllWhereDynamic] [dbo].[aspx_Region_SelectByPrimaryKey] [dbo].[aspx_Region_SelectDropDownListData] [dbo].[aspx_Region_SelectSkipAndTake] [dbo].[aspx_Region_Update] [dbo].[aspx_Shippers_Delete] [dbo].[aspx_Shippers_GetRecordCount] [dbo].[aspx_Shippers_Insert] [dbo].[aspx_Shippers_SelectAll] [dbo].[aspx_Shippers_SelectAllWhereDynamic] [dbo].[aspx_Shippers_SelectByPrimaryKey] [dbo].[aspx_Shippers_SelectDropDownListData] [dbo].[aspx_Shippers_SelectSkipAndTake] [dbo].[aspx_Shippers_Update] [dbo].[aspx_Suppliers_Delete] [dbo].[aspx_Suppliers_GetRecordCount] [dbo].[aspx_Suppliers_Insert] [dbo].[aspx_Suppliers_SelectAll] [dbo].[aspx_Suppliers_SelectAllWhereDynamic] [dbo].[aspx_Suppliers_SelectByPrimaryKey] [dbo].[aspx_Suppliers_SelectDropDownListData] [dbo].[aspx_Suppliers_SelectSkipAndTake] [dbo].[aspx_Suppliers_Update] [dbo].[aspx_Territories_Delete] [dbo].[aspx_Territories_GetRecordCount] [dbo].[aspx_Territories_SelectAllByRegionID] [dbo].[aspx_Territories_Insert] [dbo].[aspx_Territories_SelectAll] [dbo].[aspx_Territories_SelectAllByRegionID] [dbo].[aspx_Territories_SelectAllWhereDynamic] [dbo].[aspx_Territories_SelectByPrimaryKey] [dbo].[aspx_Territories_SelectDropDownListData] [dbo].[aspx_Territories_SelectSkipAndTake] [dbo].[aspx_Territories_SelectAllByRegionID] [dbo].[aspx_Territories_Update]	Created in the database and used for CRUD operations Do not rewrite or edit generated stored procedure, instead, add a new one Generated Stored Procedures may include; select all, select by primary key, insert, update, delete, and more operations Generated only when the Stored Procedure option is selected At least 5 Stored Procedures are generated per table (for most tables) Located directly in the database
Helper Classes	Features
Dbase.cs Functions.cs	Contains minimal helper methods Dbase.cs contains static/shared methods/functions that connect to the database Dbase.cs contains the connection string to the database Functions.cs contains static/shared functions/methods used in GridViews Located in the \Helper\ folder