Thank You for using AspxFormsGen MVC 5 Professional+. Listed below are the Middle-Tier, Data-Tier, and SQL code generated by AspxFormsGen MVC 5 Professional+.

Business Object Classes (Infrastructure/BusinessObject folder) 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 (Infrastructure/BusinessObjectBase folder) 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 (Infrastructure/BusinessObjectCollection folder) 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 (Infrastructure/DataLayer folder) 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 (Infrastructure/DataLayerBase folder) 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 (Infrastructure/Example folder) 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 (Generated in SQL Server) Features
  • [dbo].[sp_Categories_Delete]
  • [dbo].[sp_Categories_GetRecordCount]
  • [dbo].[sp_Categories_GetRecordCountWhereDynamic]
  • [dbo].[sp_Categories_Insert]
  • [dbo].[sp_Categories_SelectAll]
  • [dbo].[sp_Categories_SelectAllWhereDynamic]
  • [dbo].[sp_Categories_SelectByPrimaryKey]
  • [dbo].[sp_Categories_SelectDropDownListData]
  • [dbo].[sp_Categories_SelectSkipAndTake]
  • [dbo].[sp_Categories_SelectSkipAndTakeWhereDynamic]
  • [dbo].[sp_Categories_Update]

  • [dbo].[sp_CustomerDemographics_Delete]
  • [dbo].[sp_CustomerDemographics_GetRecordCount]
  • [dbo].[sp_CustomerDemographics_GetRecordCountWhereDynamic]
  • [dbo].[sp_CustomerDemographics_Insert]
  • [dbo].[sp_CustomerDemographics_SelectAll]
  • [dbo].[sp_CustomerDemographics_SelectAllWhereDynamic]
  • [dbo].[sp_CustomerDemographics_SelectByPrimaryKey]
  • [dbo].[sp_CustomerDemographics_SelectDropDownListData]
  • [dbo].[sp_CustomerDemographics_SelectSkipAndTake]
  • [dbo].[sp_CustomerDemographics_SelectSkipAndTakeWhereDynamic]
  • [dbo].[sp_CustomerDemographics_Update]

  • [dbo].[sp_Customers_Delete]
  • [dbo].[sp_Customers_GetRecordCount]
  • [dbo].[sp_Customers_GetRecordCountWhereDynamic]
  • [dbo].[sp_Customers_Insert]
  • [dbo].[sp_Customers_SelectAll]
  • [dbo].[sp_Customers_SelectAllWhereDynamic]
  • [dbo].[sp_Customers_SelectByPrimaryKey]
  • [dbo].[sp_Customers_SelectDropDownListData]
  • [dbo].[sp_Customers_SelectSkipAndTake]
  • [dbo].[sp_Customers_SelectSkipAndTakeWhereDynamic]
  • [dbo].[sp_Customers_Update]

  • [dbo].[sp_Employees_Delete]
  • [dbo].[sp_Employees_GetRecordCount]
  • [dbo].[sp_Employees_GetRecordCountByReportsTo]
  • [dbo].[sp_Employees_GetRecordCountWhereDynamic]
  • [dbo].[sp_Employees_Insert]
  • [dbo].[sp_Employees_SelectAll]
  • [dbo].[sp_Employees_SelectAllByReportsTo]
  • [dbo].[sp_Employees_SelectAllWhereDynamic]
  • [dbo].[sp_Employees_SelectByPrimaryKey]
  • [dbo].[sp_Employees_SelectDropDownListData]
  • [dbo].[sp_Employees_SelectSkipAndTake]
  • [dbo].[sp_Employees_SelectSkipAndTakeByReportsTo]
  • [dbo].[sp_Employees_SelectSkipAndTakeWhereDynamic]
  • [dbo].[sp_Employees_Update]

  • [dbo].[sp_OrderDetails_Delete]
  • [dbo].[sp_OrderDetails_GetRecordCount]
  • [dbo].[sp_OrderDetails_GetRecordCountByOrderID]
  • [dbo].[sp_OrderDetails_GetRecordCountByProductID]
  • [dbo].[sp_OrderDetails_GetRecordCountWhereDynamic]
  • [dbo].[sp_OrderDetails_Insert]
  • [dbo].[sp_OrderDetails_SelectAll]
  • [dbo].[sp_OrderDetails_SelectAllByOrderID]
  • [dbo].[sp_OrderDetails_SelectAllByProductID]
  • [dbo].[sp_OrderDetails_SelectAllWhereDynamic]
  • [dbo].[sp_OrderDetails_SelectByPrimaryKey]
  • [dbo].[sp_OrderDetails_SelectDropDownListData]
  • [dbo].[sp_OrderDetails_SelectSkipAndTake]
  • [dbo].[sp_OrderDetails_SelectSkipAndTakeByOrderID]
  • [dbo].[sp_OrderDetails_SelectSkipAndTakeByProductID]
  • [dbo].[sp_OrderDetails_SelectTotals]
  • [dbo].[sp_OrderDetails_SelectSkipAndTakeWhereDynamic]
  • [dbo].[sp_OrderDetails_Update]

  • [dbo].[sp_Orders_Delete]
  • [dbo].[sp_Orders_GetRecordCount]
  • [dbo].[sp_Orders_GetRecordCountByCustomerID]
  • [dbo].[sp_Orders_GetRecordCountByEmployeeID]
  • [dbo].[sp_Orders_GetRecordCountByShipVia]
  • [dbo].[sp_Orders_GetRecordCountWhereDynamic]
  • [dbo].[sp_Orders_Insert]
  • [dbo].[sp_Orders_SelectAll]
  • [dbo].[sp_Orders_SelectAllByCustomerID]
  • [dbo].[sp_Orders_SelectAllByEmployeeID]
  • [dbo].[sp_Orders_SelectAllByShipVia]
  • [dbo].[sp_Orders_SelectAllWhereDynamic]
  • [dbo].[sp_Orders_SelectByPrimaryKey]
  • [dbo].[sp_Orders_SelectDropDownListData]
  • [dbo].[sp_Orders_SelectSkipAndTake]
  • [dbo].[sp_Orders_SelectSkipAndTakeByCustomerID]
  • [dbo].[sp_Orders_SelectSkipAndTakeByEmployeeID]
  • [dbo].[sp_Orders_SelectSkipAndTakeByShipVia]
  • [dbo].[sp_Orders_SelectTotals]
  • [dbo].[sp_Orders_SelectSkipAndTakeWhereDynamic]
  • [dbo].[sp_Orders_Update]

  • [dbo].[sp_Products_Delete]
  • [dbo].[sp_Products_GetRecordCount]
  • [dbo].[sp_Products_GetRecordCountBySupplierID]
  • [dbo].[sp_Products_GetRecordCountByCategoryID]
  • [dbo].[sp_Products_GetRecordCountWhereDynamic]
  • [dbo].[sp_Products_Insert]
  • [dbo].[sp_Products_SelectAll]
  • [dbo].[sp_Products_SelectAllBySupplierID]
  • [dbo].[sp_Products_SelectAllByCategoryID]
  • [dbo].[sp_Products_SelectAllWhereDynamic]
  • [dbo].[sp_Products_SelectByPrimaryKey]
  • [dbo].[sp_Products_SelectDropDownListData]
  • [dbo].[sp_Products_SelectSkipAndTake]
  • [dbo].[sp_Products_SelectSkipAndTakeBySupplierID]
  • [dbo].[sp_Products_SelectSkipAndTakeByCategoryID]
  • [dbo].[sp_Products_SelectTotals]
  • [dbo].[sp_Products_SelectSkipAndTakeWhereDynamic]
  • [dbo].[sp_Products_Update]

  • [dbo].[sp_Region_Delete]
  • [dbo].[sp_Region_GetRecordCount]
  • [dbo].[sp_Region_GetRecordCountWhereDynamic]
  • [dbo].[sp_Region_Insert]
  • [dbo].[sp_Region_SelectAll]
  • [dbo].[sp_Region_SelectAllWhereDynamic]
  • [dbo].[sp_Region_SelectByPrimaryKey]
  • [dbo].[sp_Region_SelectDropDownListData]
  • [dbo].[sp_Region_SelectSkipAndTake]
  • [dbo].[sp_Region_SelectSkipAndTakeWhereDynamic]
  • [dbo].[sp_Region_Update]

  • [dbo].[sp_Shippers_Delete]
  • [dbo].[sp_Shippers_GetRecordCount]
  • [dbo].[sp_Shippers_GetRecordCountWhereDynamic]
  • [dbo].[sp_Shippers_Insert]
  • [dbo].[sp_Shippers_SelectAll]
  • [dbo].[sp_Shippers_SelectAllWhereDynamic]
  • [dbo].[sp_Shippers_SelectByPrimaryKey]
  • [dbo].[sp_Shippers_SelectDropDownListData]
  • [dbo].[sp_Shippers_SelectSkipAndTake]
  • [dbo].[sp_Shippers_SelectSkipAndTakeWhereDynamic]
  • [dbo].[sp_Shippers_Update]

  • [dbo].[sp_Suppliers_Delete]
  • [dbo].[sp_Suppliers_GetRecordCount]
  • [dbo].[sp_Suppliers_GetRecordCountWhereDynamic]
  • [dbo].[sp_Suppliers_Insert]
  • [dbo].[sp_Suppliers_SelectAll]
  • [dbo].[sp_Suppliers_SelectAllWhereDynamic]
  • [dbo].[sp_Suppliers_SelectByPrimaryKey]
  • [dbo].[sp_Suppliers_SelectDropDownListData]
  • [dbo].[sp_Suppliers_SelectSkipAndTake]
  • [dbo].[sp_Suppliers_SelectSkipAndTakeWhereDynamic]
  • [dbo].[sp_Suppliers_Update]

  • [dbo].[sp_Territories_Delete]
  • [dbo].[sp_Territories_GetRecordCount]
  • [dbo].[sp_Territories_GetRecordCountByRegionID]
  • [dbo].[sp_Territories_GetRecordCountWhereDynamic]
  • [dbo].[sp_Territories_Insert]
  • [dbo].[sp_Territories_SelectAll]
  • [dbo].[sp_Territories_SelectAllByRegionID]
  • [dbo].[sp_Territories_SelectAllWhereDynamic]
  • [dbo].[sp_Territories_SelectByPrimaryKey]
  • [dbo].[sp_Territories_SelectDropDownListData]
  • [dbo].[sp_Territories_SelectSkipAndTake]
  • [dbo].[sp_Territories_SelectSkipAndTakeByRegionID]
  • [dbo].[sp_Territories_SelectSkipAndTakeWhereDynamic]
  • [dbo].[sp_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, select/skip/take, select dynamic (search), get record count 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 (Infrastructure/Helper folder) Features
  • Functions.cs
  • Contains minimal helper methods
  • Functions.cs contains static/shared functions/methods used in GridViews
  • Located in the \Helper\ folder
Helper Classes (Domain folder) Features
  • CrudOperation.cs
  • FieldType.cs
  • Contains helper enum methods
  • Located in the \Domain\ folder