| 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 |
|
|
- 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
|