DNM RAD v.1.20
Connect to any SQL Database - Even Non Dotnetnuke
This DotNetMushroom RAD version (v.1.20) contains the implementation of one of the major features from our roadmap - the ability to link an application built in DotNetMushroom RAD to ANY SQL Database (including those residing outside the DotNetNuke Framework) via a Connection String. This has also been one of the most requested features that you have requested. In conjuntion with this feature, we have introduced the concepts of Linked Tables and Direct Queries. We have also enhanced the Packaging feature so as to be able to handle applications that are making use of external data sources (external Databases). This new enhancement now enables the packaging of external data with your application
We also took the opportunity of this release so as to introduce syntax highlighting for HTML, SQL and JavaScript. This should make it easier for you to design and debug your applications within DotNetMushroom RAD itself.
 |
External DataSources: You can connect to external SQL databases using a connection string |
 |
Linked Tables: Tables can be created using the connection string specified in datasources |
 |
Direct Queries: Direct queries can be used to call a table directly without going through the DNM Parser. This will give access to the user to query tables that are being called using external datasources |
 |
Query Designer: The query designer UI is now more rich giving the user clear distinction between reserved words and other syntax |
 |
Javascript Designer: The JavaScript designer UI is now more rich giving the user clear distinction between reserved words and other syntax |
 |
Template Designer: The template designer UI is now more rich giving the user clear distinction between HTML tags and other syntax |
 |
Line Numbers & Maximize: All designers include line numbers and a maximize function |
 |
Packaging: Packaging has beed upgraded to handle external datasources therefore if you are using an application with EDS and unpackage it to another installation, all you need to do is to change the connection string, if necessary, and you’re all set up to go online |
Screenshots

Screen 1: The External Datasources Feature

Screen 2: Connecting to an External Datasource via a Connection String

Screen 3: Linking to an External Table

Screen 4: Syntax Highlighting in the Template Designer

Screen 5: Pressing the maximize button opens the Template Designer in a new tab for easier editing

Screen 6: Direct Queries and the new SQL syntax highlighting