Azure

Labels
AJAX(112) App Studio(7) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(177) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(9) OAuth Scopes(1) OAuth2(13) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(11) PKCE(2) Postgre SQL(1) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(183) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(81) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Azure
Friday, March 30, 2012PrintSubscribe
Azure Factory

With the release of Windows Azure, Microsoft has provided a great cloud database, storage, and computing service platform. Windows Azure offers many benefits, such as guaranteed 99.95% uptime, automatic OS and service  patching, integrated network load balancing, and easy scaling.

While the Windows Azure cloud may offer the perfect platform to deploy your next web application, you still need to build this application. This is where Code On Time’s Azure Factory comes in. All you have to do is paste in your SQL Azure database connection string, and hit Generate. In a minute, your advanced web application will start in your default browser, complete with sorting, adaptive filtering, reporting, charts, and much more. Hit Publish, and the application will be packaged. Upload the published deployment package to Windows Azure, and within minutes you’ll have your app running in the cloud.

Need to add more features and customize your app? Just use the easy to use Designer to make necessary changes to the logical definition of the application. While no coding is needed to make a great app, you can always open the source code in Visual Studio and change it to precisely fit your requirements.

The following article will explain how to generate and deploy an Azure Factory application. View our learning system if you need help setting up a Windows Azure account, creating a database server, or creating a database using SQL Azure tools.

Generating the Azure Factory Project

Launch the web application generator, and create a new project. Choose Azure Factory.

Create a new Azure Factory Project

Give this project the name of “AzureFactory”. Pick the programming language of your choice. Press Create to create the project.

New Azure Factory project with name of 'AzureFactory'

On the next page, you can specify your namespace. We’ll leave the default of “MyCompany” and continue to the next page of the wizard by pressing Next.

New Windows Azure Project screen

This page requires you to specify a database connection. Click on the “…” button next to the Connection String field to configure the string.

In the Server field, enter the database’s Fully Qualified DNS Name. This can be found in the Properties of the server when using Windows Azure Management Portal.

Fully Qualified DNS Name for the Server in Windows Azure Management Portal

Enter your server username and password.

If you already have an SQL Azure database, then enter it’s name in the Database field. If you don’t have a database, you can quickly create one using the web application generator. The next few steps explain how to create a sample Northwind database.

In the Database field, write “Northwind”. Press the Create button to create the database. Press Yes to confirm creation of the database.

Create a Database from Code On Time web application generator

You will be notified that the database has been created. Press OK to close the notification, and select Northwind from the Sample Tables dropdown. Press Install to install the Northwind sample into the database, and press Yes to confirm.

Installing Northwind sample from Code On Time web application generator

Once complete, you will be notified. Press OK to close the notification.

The next steps explain configuration of ASP.NET Membership and Session State management that apply to any database.

Let’s add ASP.NET Membership to this database. Under Membership, press Add. Press OK to confirm installation.

Installing ASP.NET Membership from Code On Time web application generator

Once complete, press OK to close the notification.

By default, Azure Factory applications are configured to use two extra-small server instances in the cloud. If you use multiple instances, then Session State management must be included in the application. Under Session State, press Add. Press OK to confirm the installation.

Installing Session State Management from Code On Time web application generator

Press OK to close the notification, and press OK one more time to save the connection string. Press Next twice to get to the Reporting page.

Configured connection string on Database Connection page of Code On Time web application generator

Check the box to enable reporting, and keep pressing Next to reach the Theme page.

Enable reporting in Code On Time web application generator

Let’s choose the Azure theme. Select Azure from the list.

Azure theme selected in Code On Time web application generator

Hold down Shift key, and press Next. This shortcut will take you to the Summary page. Press the Generate button.

Generate button in Code On Time web application designer

Wait until the generator finishes, and your default browser will open with your new web application. While the application is running on your computer, the database is located in the cloud. You can log in and start using the app immediately.

Azure Factory web application running locally while connected to SQL Azure cloud database

Deploying the Web App

It’s time to deploy the app to Azure. Go back to the generator, and click on the project name. Press Publish.

Publish button on Project page of Code On Time web application generator

The generator will package the web application and create the files necessary for deployment. A Windows Explorer screen will open and display the location of the files.

Published Azure Factory packages ready for deployment

Log in to your Windows Azure Management Portal, and switch to Hosted Services, Storage Accounts & CDN section in the bottom left corner. In the folders, click on Hosted Services. Select your subscription, and press New Hosted Service on the ribbon.

Create and deploy a new hosted service button in Windows Azure Management Portal

Use the following settings for your new hosted service:

Choose a subscription 3-Month Free Trial
Enter a name for your service AzureFactory
Enter a URL Prefix for your service AzureFactory (if not available, use something else)
Choose a region or affinity group Anywhere US (or your closest region)
Deployment options Deploy to stage environment
Deployment name AzureFactory
Package location ~\MyDocuments\CodeOnTime\Publish\Azure Factory\AzureFactory\CloudApp.cspkg
Configuration file ~\MyDocuments\CodeOnTime\Publish\Azure Factory\AzureFactory\ServiceConfiguration.cscfg

Create a New Hosted Service screen in Windows Azure Management Portal

Press OK, and Windows Azure will start the deployment process. This step may take 10-15 minutes. Once the status of the deployment changes to Ready, use the link found under Properties. You will be taken to the fully functional website running in the cloud .

Code On Time web application deployed to Staging environment

If you look at the URL, you will notice that it uses the ID of the deployment, not the requested DNS Name. This is because the deployment is a staging deployment. You can go back to the management portal, and choose Swap VIP to change it into a production deployment. Now you can use the DNS Name you specified during creation of the hosted service.

Deployed Code On Time web application in Production environment

When you are ready to deploy a new project revision, create a new staging deployment. Test the new deployment in the cloud. If everything is working as expected, then swap the virtual IP address of the staging deployment with the production one. Click Swap VIP button on the Management Portal ribbon to do so.

Deployment ribbon in Windows Azure Management Portal

When VIP swapping has finished, the previous application revision will become a staging deployment. Shut it down if you don’t need it. Continue upgrading staging deployment with the new revisions of the application, and swapping them later with production.

Tuesday, March 27, 2012PrintSubscribe
Creating an SQL Azure Database

Log in to your Windows Azure Platform at https://windows.azure.com/ and clicking on Portal. At the bottom, press New and select Data Services | SQL Database | Quick Create. Specify a name of “HR” and login credentials for the database. Press Create SQL Database.

Creating a new SQL Database.

When the database is created, click on the name in the list of all items, and then press Manage on the bottom toolbar.

Managing the database.

Accept the prompt to add a firewall exception. A new tab will open the management screen. Enter your user credentials and press Log on.

You will be taken to a summary screen that shows database statistics.

Administration page of Microsoft SQL Azure database management web app

Click on the Design button in the bottom left corner. This will take you to a list of all tables in the database. As this database has just been created, the list of tables will be currently empty. Let’s add a table by pressing the New table button.

New Table button in Microsoft SQL Azure database management web app

Add the following fields, starting with the Column name and then selecting type:

Column Select type Is Identity? Is Required?
JobID int Yes Yes
Title nvarchar(50)    
Description ntext    

Jobs table created in HR database using SQL Azure database management web app

In the Table Name field above the columns, enter “Jobs”. Save the table by pressing Save on the ribbon at the top.

Click on Design again. Create another table, name it “Employees”, and set up the following field information:

Column Select type Is Identity? Is Required?
EmployeeID int Yes Yes
LastName nvarchar(30)   Yes
FirstName nvarchar(50)   Yes
JobID int    
Salary money    
Notes ntext    
Photo image    
HireDate datetime    

Employees table created in HR database using SQL Azure database management web app

Save the table. Let’s add a foreign key reference for the JobID field between Employees and Jobs. Above the list of columns, click on Indexes and Keys.

Click on the Add a foreign key relationship header on the right side. Check the JobID field, choose the table dbo.Jobs, and select column JobID.

Foreign key relationship between Jobs and Employees table created in HR database using SQL Azure database management web app

Press Save to save the foreign key.

Now it’s time to create a web application from the database and deploy this application to the cloud. For detailed instructions on Azure Factory project creation and deployment, please refer to this article.

Run Code On Time generator and create a new Azure Factory project. Give this project a name, and specify the connection string of the database using the Fully Qualified DNS Name of the server. Enable ASP.NET Membership and Session State Management. Use the Grapello theme. Generate the application, and you will have a full featured web application running locally on your computer and connecting to your SQL Azure database.

To publish, go back to the web application generator, click on the project name, and press Publish. A Windows Explorer window will open with two files necessary for deployment. Go back to the Windows Azure Platform, and open Hosted Services folder. Create a new Hosted Service, and specify the settings. The package and configuration file are in the opened Explorer window. Press OK to create the deployment. It may take a while for the service to start.

Once complete, you will be able to access the website using the link under Properties of the deployment. Click on this link, and you will be taken to the fully functional website. 

Code On Time Azure Factory web application running in Azure staging deployment

If you look at the URL, you will notice that it uses the ID of the deployment, not the requested DNS Name. This is because the deployment is a staging deployment. You can go back to the management portal, and choose to Swap to change it into a production deployment. This will use the URL you specified during creation of the hosted service.

Code On Time Azure Factory web application running in Azure production deployment

Sunday, March 25, 2012PrintSubscribe
Creating an SQL Azure Server

Log in to your Windows Azure Platform at https://windows.azure.com/. Press the New Database Server on the ribbon to create a new SQL Azure server.

New Database Server button in Windows Azure Platform

In the Getting Started area, click on the Create a new SQL Azure Server tile.

Create a new SQL Azure Server tile in Windows Azure platform

You will be prompted to select a Subscription. Select your subscription (for example, 3-Month Free Trial) and press Next.

Subscription selection for new Azure database server

Select the desired region for your server, and press Next. In our case, this is South Central US.

Region selection for new Azure database server

You will now have to enter an administrator username and password. Windows Azure has stringent username and password requirements – you cannot use common usernames such as admin or sa, and your password must have a combination of letters and numbers, without any strings longer than three letters from the username.

Enter your preferred username and password, and press Next.

Administrator username and password for new Azure database server

The next screen will require you to make firewall rules to enable access to the servers. Check the box to “Allow other Windows Azure services to access this server”. Press Add, and create a new rule to allow your current IP address. Your IP will be displayed on the Add Rule screen. Name the rule, and add this rule to the list. Press Finish to create the server.

Firewall rules for SQL Azure database server

In the tree in the upper left corner, find and select the server you just created. From here, you can view the database information. In the Properties section on the right side, you can find the Fully Qualified DNS Name. You will need to use this name to connect to the database. You can also manage databases from this screen.

Server Information Screen in Windows Azure Platform