Code On Time: Application Factory

Blog

Application Factory

Saturday, December 8, 2012Print Subscribe

Sample database HR (Human Resources) comes standard with Oracle database server. Let’s create a web application straight from this database.

Getting Oracle on Your Computer

First, download the Oracle Database Express Edition 11g Release 2 installation files.

When the download is complete, extract the zip folder. Run the file at DISK1\setup.exe. Follow the steps to install Oracle Express Edition 11g on your computer.

When the database server has been installed, log in to the management website. The link to the page is available at C:\oraclexe\app\oracle\product\11.2.0\server\Get_Started.url. In the web browser, click on the Application Express tab, and create a workspace in order to access the database.

Native vs. Managed Data Provider

Code On Time web application generator creates web apps based on Microsoft ASP.NET, a component of Microsoft.NET technology. Database vendors offer middleware that allows ASP.NET applications to communicate with their servers. Oracle offers two providers:

The ODP.NET (Oracle Data Provider) is included in the Oracle Data Access Components (ODAC) for Windows package. The provider is a managed .NET wrapper that “speaks” to unmanaged native API of Oracle database server.

Because of this mix of managed and unmanaged code, there is a need to install both 32-bit and 64-bit versions of ODP.NET when working with Windows 7 and 8. Some components of development tools for Windows support only 32-bit architecture. Each version of ODP is around 230 MB in size.

The ODP.NET, Managed Driver is less than 2 MB in size and written purely in .NET. It has better performance and is easier to configure. This is the recommended .NET provider for ASP.NET web applications.

Click on one of the links above and install one of the providers for Oracle.

Creating a Web Application

Start the code generator, and click on the Create a new web application link on the start page. Select Web Site Factory to create the project.

Assign the project a name of “HR”, select the programming language of your choice (C# or Visual Basic), and press Create.

Leave the default Namespace and Framework values and press Next.

Select the desired ODP provider in the Data Provider dropdown, and click on the “…” button next to Connection String field to access the Oracle Connection screen.

Enter your Server name, User name, and Password in the appropriate fields.

If you are working with Oracle Express Edition and using ODP.NET Managed Driver, leave the Server name blank. If you are using ODP.NET , then enter “127.0.0.1” in the Server name.

Press the Test button to test the connection string.

Press OK to dismiss the Connection Status window, and press OK to insert the configured connection string into the field.

Press Next twice to reach the Reporting page. Check the box to enable reporting.

Press Next to reach the Themes page. Select Social from the list box.

Hold down Shift, and press Next to skip to the Summary screen.

Press Generate to start the code generation. A window will open in your default web browser with the web app when complete.

Learn how to configure Custom Membership and Role Provider for your Oracle database.

Labels: Application Builder, Application Factory, ASP.NET Membership, Code Generator, Installation, Oracle, Tutorials, Web Application Generator

Thursday, December 6, 2012Print Subscribe

“Page Orientation” Property

When a report is created from a view that has more than seven fields, the report is rendered with landscape orientation, such as the example shown below. When a report has less than seven fields, the report is rendered in portrait orientation.

The report orientation can also be forced to render portrait or landscape by using the “Page Orientation” property.

Let’s change the Customers report displayed above to be presented in portrait orientation.

Start the Project Designer. In the Project Explorer, switch to the Controllers tab. Double-click on Customers / Views / grid1 node.

Change the following:

Property	New Value
Page Orientation	Portrait

Press OK to save. On the toolbar, press Browse.

Navigate to the Customers page. On the action bar, press Report | PDF Document.

Open the PDF file that was saved to your hard drive. The report will be in portrait orientation.

Labels: Application Factory, Reports, Web Application Generator

Saturday, December 1, 2012Print Subscribe

Minimal Membership Provider for Oracle

Requirements

A minimal membership provider requires a dedicated table to keep track of user names and passwords.

This is a sample “Users” table with “identity” primary key. It is necessary to create a sequence and trigger to update the identity key every time a new user is created.

SQL:

create sequence users_seq;

create table users
(
    user_id int not null primary key,
    user_name varchar2(128) not null,
    password varchar2(128) not null
);

create or replace trigger users_trigger
    before insert
    on users
    for each row
declare
    u_id users.user_id%type;
begin
    select users_id_seq.nextval into u_id from dual;
    :new.user_id := u_id;
end users_trigger;
/

Here is how the table may look if a “unique identifier” primary key is implemented. Oracle will automatically assign a unique identifier when a new user is created.

SQL:

create table users
(
    user_id raw(16) default sys_guid() not null primary key,
    user_name varchar2(128) not null,
    password varchar2(128) not null
);

User roles are hardcoded in the minimal Role Provider implementation.

Configuration

Create a table in your database using one of the scripts specified above.

Select the project name on the start page of the application generator and choose Settings.

Proceed to Authentication and Membership.

Select “Enable custom membership and role providers” option and enter the following configuration settings.

table Users=Users
column [int|uiid] UserID = user_id
column [text] UserName = user_name
column [text] Password = password

role Administrators = admin
role Users = admin, user
role Everybody = *

The configuration maps logical table Users required for membership provider implementation to the physical database table Users. It also defines three user roles – Administrators, Users, and Everybody.

Generate the project to see the membership provider in action.

Labels: Application Factory, Features, Oracle, Security, Tutorials, Web Application Generator