Thursday, March 1, 2012

Installing Northwind on Microsoft SQL Server

The Database Connection page is the first page you will see after creating a new project. This page allows you to specify your data provider and connection string. We will be using Microsoft SQL Server 2008. Select your data provider from the list, and press the “…” button to compose a connection string.

Database Connection String page in Code On Time web application generator

Enter your server name, credentials, and enter “Northwind” in the Database field.

A typical project will start with selection of an existing database. For this example, we will create a new one. Press Create to the right of Database field, confirm the creation, and the database will be created.

SQL Server Connection Page in Code On Time web app generator

Under Sample Tables, select Northwind from the dropdown. Press Install, and confirm. This will install Northwind sample into the specified database.

Installing Northwind database in SQL Server Connection page in Code On Time generator

You can monitor the progress in the log at the bottom. The web app generator will notify you upon completion.

No comments:

You can find more about Code OnTime Generator, Data Aquarium Framework, and other great products here.


© 2010 Code OnTime LLC. Intelligent code generation software for ASP.NET. Visit us at http://codeontime.com