CRUD Wizard for SQL Azure

Last Revised On: 15/10/2009

Project Overview

The third version of the SQL CRUD Application Wizard for PHP includes the ability to connect to SQL Azure. The wizard performs much the same way as it does for SQL Server. After specifying credentials for a SQL Azure account, the wizard walks through the selection of a table and columns which should be included in the generated CRUD application. Once these selections are made, the wizard collects information for paging, sorting and style of interface. A Silverlight or HTML interface can be selected. That's it. The wizard will then generate a CRUD Application which can connect to and manipulate data hosted in a SQL Azure instance.

Note that in order to create a SQL Azure instance, you must register for the CTP. Please go to the SQL Azure site and click on 'Sign up for the CTP'.

Architecture

The SQL CRUD Wizard for PHP creates a template for data access to either SQL Azure or a Table in an Azure Table Storage account. The template is a PHP page which generates either HTML or XAML, depending on user choice and which includes logic to perform CRUD updates against the specified data. The generated application accesses data stored in Azure via REST and returns formatted data to the client via standard HTTP protocol. Client interaction is also handled through HTTP.