| Generated Razor Pages (.cshtml) | Quick Description (Pages Folder) | 
                                
                                    | 1.  List with Add, Edit Redirect & Delete 
 - 
                                                See Features Visually
                                            
                                        
                                          - Sample Code
 - 
                                        Demo
 | A razor page with a list of items shown in a grid with CRUD functionality.  Adding or updating an item redirects to another page.  
                                        more info 
 
 
                                        
                                                Contains a JQgrid control that has CRUD (Create, Retrieve, Update, Delete) functionality. Adding a new record redirects to another page Updating an existing record redirects to another page Delete functionality uses a JQuery UI Pop-up for delete confirmation JQgrid control shows Sort Direction Image in the header JQgrid uses Paging in the footer List retrieves data on demand using Skip/Take logic Uses JSON to retrieve small amounts of data for every page or sort operation One ASP.NET Core 3.1 Razor Page is generated per table | 
                                
                                    | 2.  Add New Record 
 - 
                                                See Features Visually
                                            
                                        
                                          - Sample Code
 - 
                                        Demo
 | A razor page with validated input controls used for adding a new record.
                                        more info 
 
 
                                        
                                                Contains JQuery Validation Contains JQuery UI Date Controls for date fields Contains bound DropDownList for foreign fields You can get here from the "List with Add, Edit Redirect, & Delete" Razor Page when clicking the Add New Record link One ASP.NET Core 3.1 Razor Page is generated per table | 
                                
                                    | 3.  Update Record 
 - 
                                                See Features Visually
                                            
                                        
                                          - Sample Code
 - 
                                        Demo
 | A razor page with validated input controls used for updating an existing record.
                                        more info 
 
 
                                        
                                                Contains JQuery Validation Contains JQuery UI Date Controls for date fields Contains bound DropDownList for foreign fields You can get here from the "List with Add, Edit Redirect, & Delete" Razor Page when clicking the Edit button One ASP.NET Core 3.1 Razor Page is generated per table | 
                                
                                    | 4.  Record Details (Read Only) 
 - 
                                                See Features Visually
                                            
                                        
                                          - Sample Code
 - 
                                        Demo
 | A razor page with read-only details of a record.
                                        more info 
 
 
                                        
                                               Shows details of a record (Read-Only) You can get here from the "List (Read-Only)" Razor Page when clicking the foreign key links One ASP.NET Core 3.1 Razor Page is generated per table | 
                                
                                    | 5.  List (Read-Only) 
 - 
                                                See Features Visually
                                            
                                        
                                          - Sample Code
 - 
                                        Demo
 | A razor page with a list of items shown in a grid. No CRUD functionality.
                                        more info 
 
 
                                        
                                                Contains a JQgrid Control. No CRUD functionality (read-only). A pop-up link is provided for all Foreign Key columns (for details on the foreign key) JQgrid control shows Sort Direction Image in the header JQgrid uses Paging in the footer List retrieves data on demand using Skip/Take logic Uses JSON to retrieve small amounts of data for every page or sort operation One ASP.NET Core 3.1 Razor Page is generated per table | 
                                
                                    | 6.  List with Add, Edit, & Delete (Same Page) 
 - 
                                                See Features Visually
                                            
                                        
                                          - Sample Code
 - 
                                        Demo
 | A razor page with a list of items shown in a grid with CRUD functionality.  A pop-up shows when adding or updating an item.
                                        more info 
 
 
                                        
                                                Contains a JQgrid Control that has CRUD (Create, Retrieve, Update, Delete) functionality. Add a new record on the same page with JQuery dialog with validation Update an existing record on the same page with JQuery dialog with validation Delete functionality uses a JQuery UI Pop-up for delete confirmation JQgrid control shows Sort Direction Image in the header JQgrid uses Paging in the footer List retrieves data on demand using Skip/Take logic Uses JSON to retrieve small amounts of data for every page or sort operation One ASP.NET Core 3.1 Razor Page is generated per table | 
                                
                                    | 7.  List with Grouping 
 - 
                                                See Features Visually
                                            
                                        
                                          - Sample Code
 - 
                                        Demo
 | A razor page with a list of grouped items (e.g. Employees by DepartmentID).  No CRUD functionality.
                                        more info 
 
 
                                        
                                                Contains a JQgrid Control. No CRUD functionality (read-only). Shows grouping by the respective group Shows count per respective group Collapsible or expandable grid per group E.g. List of Orders by Shipper, List of Territories by Region JQgrid control shows Sort Direction Image in the header JQgrid uses Paging in the footer List retrieves data on demand using Skip/Take logic Uses JSON to retrieve small amounts of data for every page or sort operation One ASP.NET Core 3.1 Razor Page is generated for each table referencing the current table | 
                                
                                    | 8.  List with Totals 
 - 
                                                See Features Visually
                                            
                                        
                                          - Sample Code
 - 
                                        Demo
 | A razor page with a list of items with totals in the footer shown in a grid.  No CRUD functionality.
                                        more info 
 
 
                                        
                                               Contains a JQgrid Control. No CRUD functionality (read-only). Shows totals on the footer for money fields JQgrid control shows Sort Direction Image in the header JQgrid uses Paging in the footer List retrieves data on demand using Skip/Take logic Uses JSON to retrieve small amounts of data for every page or sort operation One ASP.NET Core 3.1 Razor Page is generated for tables that have money data fields only | 
                                
                                    | 9.  List with Totals and Grouping 
 - 
                                                See Features Visually
                                            
                                        
                                          - Sample Code
 - 
                                        Demo
 | A razor page with a list of grouped items (e.g. Employees by DepartmentID) with total count per group in the footer.  No CRUD functionality.
                                        more info 
 
 
                                        
                                                Contains a JQgrid Control. No CRUD functionality (read-only). Shows grouping by the respective group Shows count per respective group Collapsible or expandable grid per group E.g. List of Orders by Shipper, List of Territories by Region JQgrid control shows Sort Direction Image in the header JQgrid uses Paging in the footer List retrieves data on demand using Skip/Take logic Uses JSON to retrieve small amounts of data for every page or sort operation Shows totals on the footer of each group for money fields One ASP.NET Core 3.1 Razor Page is generated for tables that have money data fields only | 
                                
                                    | 10.  List with Search 
 - 
                                                See Features Visually
                                            
                                        
                                          - Sample Code
 - 
                                        Demo
 | A razor page with a list of items shown in a grid with CRUD and Search functionality.  You can filter grid results by entering values in the input controls show on the header.
                                        more info 
 
 
                                        
                                                Contains a JQgrid Control. No CRUD functionality (read-only). Contains search functionality in the header of each searchable column Search uses the "AND" operator to satisfy all search filters JQgrid control shows Sort Direction Image in the header JQgrid uses Paging in the footer List retrieves data on demand using Skip/Take logic Uses JSON to retrieve small amounts of data for every page or sort operation One ASP.NET Core 3.1 Razor Page is generated per table | 
                                
                                    | 11.  List with Scroll-Loading Data 
 - 
                                                See Features Visually
                                            
                                        
                                          - Sample Code
 - 
                                        Demo
 | A razor page with a list of items shown in a grid. No CRUD functionality.  Items are dynamically paged as you scroll through the grid.
                                        more info 
 
 
                                        
                                                Contains a JQgrid Control. No CRUD functionality (read-only). Data dynamically loads as you scroll through the list. JQgrid control shows Sort Direction Image in the header No paging controls in the botton of JQGrid List retrieves data on demand using Skip/Take logic Uses JSON to retrieve small amounts of data for every page or sort operation One ASP.NET Core 3.1 Razor Page is generated per table | 
                                
                                    | 12.  List with Inline Add and Edit 
 - 
                                                See Features Visually
                                            
                                        
                                          - Sample Code
 - 
                                        Demo
 | A razor page with a list of items shown in a grid with CRUD functionality.  Add a new record and update an existing item inline with the grid.
                                        more info 
 
 
                                        
                                                Contains a JQgrid Control. Add a new record on the same page inline the header of the List. Update an existing record inline on the same page Delete funtionality uses a JQuery UI Pop-up for delete confirmation JQgrid control shows Sort Direction Image in the header JQgrid uses Paging in the footer List retrieves data on demand using Skip/Take logic Uses JSON to retrieve small amounts of data for every page, and sort operation One ASP.NET Core 3.1 Razor Page is generated per table | 
                                
                                    | 13.  List with Manual For Each Loop 
 - 
                                                See Features Visually
                                            
                                        
                                          - Sample Code
 - 
                                        Demo
 | A razor page with a list of manually-looped items shown in a grid with CRUD functionality.  Adding or updating an item redirects to another page.
                                        more info 
 
 
                                        
                                                No JQgrid control.  The list is manually created using a Foreach loop. Has CRUD (Create, Retrieve, Update, Delete) functionality. Adding a new record redirects to another page Updating an existing record redirects to another page Delete functionality uses a JQuery UI Pop-up for delete confirmation Sorting and Paging manually-built List shows manually-built Sort Direction Image in the header List retrieves data on demand using Skip/Take logic One ASP.NET Core 3.1 Razor Page is generated per table | 
                                
                                    | 14.  List with Master Detail (Grid) 
 - 
                                                See Features Visually
                                            
                                        
                                          - Sample Code
 - 
                                        Demo
 | A razor page with two grids with a master-detail relationship. No CRUD functionality.  Clicking an item in the first grid loads related items in the second grid.
                                        more info 
 
 
                                        
                                                Contains 2 JQgrid Controls with a Master-Detail relationship, one on top of the other. No CRUD functionality (read-only). Clicking an item in the first (master) grid loads related items in the second (details) grid Both JQgrid controls shows Sort Direction Image in the header Both JQgrid uses Paging in the footer Both list retrieves data on demand using Skip/Take logic Both list Uses JSON to retrieve small amounts of data for every page or sort operation One ASP.NET Core 3.1 Razor Page is generated for each foreign key in each table | 
                                
                                    | 15.  List with Master Detail (Sub Grid) 
 - 
                                                See Features Visually
                                            
                                        
                                          - Sample Code
 - 
                                        Demo
 | A razor page with a grid within another grid with a master-detail relationship. No CRUD functionality.  Expanding an item in the master grid loads related items in the sub grid.
                                        more info 
 
 
                                        
                                                Contains 2 JQgrid Controls with a Master-Detail relationship, a grid (sub grid) within another grid. No CRUD functionality (read-only). Expanding an item in the master grid loads related items in the sub grid Both JQgrid controls shows Sort Direction Image in the header Both JQgrid uses Paging in the footer Both list retrieves data on demand using Skip/Take logic Both list Uses JSON to retrieve small amounts of data for every page or sort operation One ASP.NET Core 3.1 Razor Page is generated for each foreign key in each table | 
                                
                                    | 16.  List with Multiple Delete 
 - 
                                                See Features Visually
                                            
                                        
                                          - Sample Code
 - 
                                        Demo
 | A razor page with a list of items shown in a grid with CRUD functionality.
                                        more info 
 
 
                                            Contains a JQgrid Control with CRUD functionality. Adding a new record redirects to another page Clicking anywhere in the row redirects to another page for Updating an existing record Multiple Delete functionality uses a JQuery UI Pop-up for delete confirmation Select/Unselect All records for delete operation JQgrid control shows Sort Direction Image in the header JQgrid uses Paging in the footer List retrieves data on demand using Skip/Take logic Uses JSON to retrieve small amounts of data for every page or sort operation One ASP.NET Core 3.1 Razor Page is generated per table | 
                                
                                    | 17.  List by Foreign Key 
 - 
                                                See Features Visually
                                            
                                        
                                          - Sample Code
 - 
                                        Demo
 | A razor page with a list of items shown in a grid Listed By a Foreign Key. No CRUD functionality.
                                        more info 
 
 
                                            Contains a JQgrid Control. No CRUD functionality (read-only) Lists items by Foreign Key. A Drop Down box determines related items to list A link to the Record Details page is provided for all Foreign Key columns (for details on the foreign key) JQgrid control shows Sort Direction Image in the header JQgrid uses Paging in the footer List retrieves data on demand using Skip/Take logic Uses JSON to retrieve small amounts of data for every page or sort operation One ASP.NET Core 3.1 Razor Page is generated per table | 
                                
                                    | 18.  Unbound Razor Page 
 - 
                                                See Features Visually
                                            
                                        
                                          - Sample Code
 - 
                                        Demo
 | A razor page with validated input controls which can be used for adding a new record or updating a record.  Not bound/connected to the database so you will need to add your own code to bind it to the database.
                                        more info 
 
 
                                            This is the only razor page that is generated by the AspCoreGen 3.0 Express Edition. Also generated by AspCoreGen 3.0 Professional Edition. Razor Pages that are not bound to the database Contains JQuery Validation Contains JQuery UI Date Controls for date fields Contains unbound DropDownList for foreign fields Can be used when adding a new record or updating an existing record One ASP.NET Core 3.1 Razor Page is generated per table | 
                                
                                    | 19.  Add/Edit Partial Razor Page 
 - Sample Code
 
 
 | A razor page shared by the Add New Record and Update Record razor pages.  It contains objects listed under the Add New Record and Update Record razor pages shown above. |