Blog: Posts from March, 2012

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(8) OAuth Scopes(1) OAuth2(11) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(10) PKCE(2) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(180) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(80) 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
Posts from March, 2012
Saturday, March 31, 2012PrintSubscribe
Auto Highlight in Data Views

The following screen shot shows the automatically generated page Suppliers from the Northwind sample. If you navigate to the page and sort or filter records then only the master data view Suppliers is visible.

Standard master/detail page 'Suppliers' in the 'Northwind' sample created with Code On Time web application generator

Click on any data row and it will become highlighted. Linked detail records will be displayed at the bottom of the page.

Linked 'Products' are displayed if a user clicks on a master row of 'Suppliers' view

Sometimes it may be desirable to highlight the first row in the master view automatically.

Start the application generator, click on the project name, choose Design, and select the master data view of the page in Project Explorer.

Data view selected in Project Explorer

Check the box labeled “Auto Highlight First Row” under the Presentation section of the data view properties and click OK.

'Auto Highlight First Row' property of a data view

Click Browse button on the tool bar to view the page in the web browser.

The very first visible row will be automatically highlighted. Linked details will be displayed as well.

The initial state of the page loaded in a web browser if 'Auto Highlight First Row' property of the master view is enabled

Friday, March 30, 2012PrintSubscribe
What is Windows Azure Platform?

Azure Factory allows rapid development of web applications for Microsoft Windows Azure cloud. In minutes you can create cross-browser web applications that look similar to the one in the picture.

Sample Azure Factory application created with Code On Time

Curious what Windows Azure is? Read on or take a look at the Azure Factory tutorial explaining how to create an Azure Factory project and deploy it to the cloud with Code On Time web application generator.

What is Windows Azure Platform?

Windows Azure Platform is a cloud hosting service run by Microsoft that enables you to store data, as well as build and connect apps. Everything is stored in a Microsoft data center - the only thing you have to manage is your application. The applications are hosted on cloud operating systems called Windows Azure. This operating system serves as a runtime for your application. While it can't be accessed directly, it can be interacted with using the Azure Portal. You can create, edit, and delete hosted services, and storage accounts. Rich SQL Azure reporting capabilities are also present.

What is the Windows Azure Platform?

Typical "On-Premise" Application Setup

The usual application setup in your own on-premise data center will include the following items:

  • Firewall
  • Load balancer
  • Application server
  • Database server
  • Other services (access control, security)

This setup will take an exhaustive amount of time and money to implement, and that's just the hardware side. You will also need to install the operating systems and configure them to work together. And how long will this system run until you have to start updating, patching, and fixing everything? When traffic increases, you'll also have to scale this system. Windows Azure offers a better solution.

Typical 'On-Premise' Application Setup

Using Windows Azure

Switch your application to Windows Azure - all the hardware is stored in a Microsoft data center, and there is no need to manage the operating system. All you have to do is deploy your application to the cloud, and everything will take care of itself. This allows you to focus on adding business value and key features to your applications.

With Azure Factory, your job becomes even easier. Point to your database and press Generate. In a few minutes, you will have a full featured web application that is sure to impress peers and customers. Then, press Publish, and you will have everything you need to deploy to Windows Azure.

Using Windows Azure

SQL Azure

Windows Azure allows you to store and run your application in the cloud. SQL Azure will store the the data for your application. It is a relational database using SQL technology, that runs in the Azure cloud. Use the online Database Manager provided by Microsoft, or connect to the database with SQL Server Management Studio 2008 R2. SQL Azure also supports T-SQL.

The database is highly scalable - availability will increase with demand, and price will be dictated by usage. All data is distributed across many nodes, with at least three copies, to insure fault tolerance. If one copy goes down, another copy is automatically activated to insure a seamless experience.

SQL 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.