The demo app implements the core features necessary for any complete, secure, data-intense web application:

• Application security via SSL, MVC Route security, and anti-XSS/SQL Injection data encoding
• User Login and password maintenance, with automatically expiring user sessions and optional 'RememberMe' encrypted credential storage
• Navigation
• Full CRUD rendering of resultsets, including custom validation
• Dataset management control over large resultsets fetched from the database
• Paging functionality that easily handles paging through even large resultsets
• Sorting, filtering, column selection and download/export of data
• Admin functionality for user role and object assignment
• Error Logging
• Theming to render a recognizable look to data by area or individual

To get a good look at the demo application, give it a spin by logging in. A user name and password will be provided for you. Take a test drive. The dbRender demo app includes general as well as technical descriptive information about its features. Look for the Feature Notes accessible by the icon at the top of every page in the app.

Technical Details
This is an SSL-Protected, ASP.NET MVC hosted solution with a SQL Server 2019 backend. It renders info for a fictional company called MountainTreks, based on SQL Server’s AdventureWorks sample database. The Production.Product table in the AdventureWorks database has been inserted in a loop to generate over 1 million records to demonstrate larger resultset paging and performance. It is a Single View Solution, which enables a one-time loading of site-wide files (such as the background videos), and enables control of what gets loaded where, providing a true API interface.

The solution was built in Visual Studio 2019, using C#, JavaScript, JQuery/AJAX, CSS and Razor for the views. Most of the coding is custom, rather than Visual Studio built-in helper code. The validation on the Product Edit screens is all custom code that accommodates business custom validation rules.

This app will render on current versions of the major browsers: Chrome, Edge, Internet Explorer, Firefox, and Opera, as well as Safari. It is not a mobile app, and JavaScript/JQuery must be enabled. The app design uses only one cookie: in the optional “Remember Me” function that stores user name and password in encrypted form. The app also auto-generates an anti-forgery token in a cookie that assures requests are coming only from the application.

Take the Demo App for a Test Drive