SQL#

Sunday, May 20, 2012

SQL#

Demos

	You are here: SQL#

SQL#: a collection of web component designed to let developers build no-code data-driven ajax web application.

SQL# is the tool build upon the exprerience of year of development of DotNetNuke based protals: it was buid to let portal admins the use of administration across the web of the content that is obtained width a query to a generic database.

The most important result that is obtained width the use of SQL# is the reduction of the need of development of specific module.

Due to the power of the template Engine it is also possible to get HTML output width an extrem precision.

What does it means?

DATA-DRIVEN
The building of the web page only need the knowledge of the data as this will be read directly form the database.

NO-CODE
It is possible to build pages with intreacrtive modules without no need to write any row of code other than SQL and HTML.

AJAX WEB APPLICATION
The refresh (update) of part of the web page will be done without need of refresh the entire page.

How does it work?

TEMPLATE ENGINE
The template engine used is NVelocity, porting on .NET of the famous java project Velocity. It is used to put interction logic width the user and rendering algoritm upon the configuration.

ADO.NET
It is only needded to declare the connection string and it is possible to interact in the same manner width all database vendors.
It is possible to use SqlServer, OleDb, ODBC and OracleClient

Microsoft ASP.NET 2.0 Ajax Framework
Microsoft's Ajax is used to obtain the Ajax paradigm interaction behavior. Only the part of the page subject of the update is refreshed, not the entire page.

What can I do width this?

* Product catalog
* Photo gallery
* Private area width profiled data
* Query to every database type (if support at least OleDb or ODBC)
* Query to the DotNetNuke database
* HTML report