Code On Time: MySQL

Blog

MySQL

Friday, November 9, 2012Print Subscribe

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.

SQL:

create table Users (
    UserID int not null AUTO_INCREMENT primary key,
    UserName varchar(128) not null,
    Password varchar(128) not null
    );

Here is how the table may look if a “unique identifier” primary key is implemented. MySQL does not have built-in unique identifier capabilities, so the ID must be generated by a trigger.

SQL:

create table Users (
    UserID varchar(36) not null primary key default '',
    UserName varchar(128) not null,
    Password varchar(128) not null
    );

delimiter $$
create trigger userinsert
before insert on Users
for each row
begin
    set New.UserID = UUID();
end $$

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 = UserId
column [text] UserName = UserName
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.

Labels: Designer, MySQL, Security, Tutorials, Web Application Generator

Friday, March 9, 2012Print Subscribe

Sakila Sample Database

A majority of examples rely on the Northwind sample database available for Microsoft SQL Server.

If your backend database is MySQL, then try Sakila sample database instead.

Getting MySQL on Your Computer

Download and install the MySQL Installer for Windows at http://dev.mysql.com/tech-resources/articles/mysql-installer-for-windows.html.

If you already have MySQL installed, then you can skip the above step.

By default, Sakila database comes with the MySQL installation. If you do not have the sample database, then you can download the database scripts at http://downloads.mysql.com/docs/sakila-db.zip.

Creating a Web Application

Run Code On Time web application generator and create a new Web Site Factory project.

Give this project the name of “Sakila” and select the programming language of your choice (C# or Visual Basic.NET).

Click Create to create the project. Press Next to reach the Database Connection page.

Change the Data Provider to “MySql.Data.MysqlClient” and press the button next to the Connection String string field.

On the MySQL Connection page, enter your connection string settings. If you installed MySQL locally, enter:

Server Name	localhost
User Name	root
Password	[Your Password]
Database	Sakila

Press Next until you reach the Authentication and Membership page. MySQL can automatically install support for ASP.NET Membership in your database. Just check the first box on the page to enable membership support.

Press Next until you reach the Themes page. Select “Vantage” theme.

Hold down Shift key and press Next. This shortcut is available on any page of the web application generator wizard, and will skip to the Summary page.

Click Generate to start the code generation.

A web browser window will open up when code generation has been completed.

Start using and customizing your own Sakila sample.

You can reference the same database in other projects whenever you need.

The next screenshot shows the built-in membership manager in an application created from MySQL database.

Labels: MySQL, Tutorials, Web Application Generator

Sunday, May 1, 2011Print Subscribe

Deploying Generated Applications to Winhost

Learn how to deploy your Web Site Factory and Web App Factory applications to the popular hosting provider http://www.winhost.com.

Includes instructions for web applications working with Microsoft SQL Server and MySQL databases.

/Documents/CB-Deploying_Your_App_To_WinHost.pdf

Labels: ASP.NET Code Generator, Deployment, MySQL, Web App Generator, Web.Config