Northwind Sample

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(12) 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(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)
Thursday, October 20, 2011PrintSubscribe
Northwind Sample

Many of Code On Time tutorials are using Northwind sample database created by Microsoft to illustrate concepts of database design and implementation with Microsoft SQL Server.

The database is somewhat outdates and does not reflect the latest advancements in Microsoft SQL Server features and capabilities. Nevertheless it provides a perfect dataset to illustrate the concepts of code generation.

We have included the script creating the Northwind sample database with the code generator. The script can be used to create a sample dataset for Microsoft SQL Server 2005, 2008, and SQL Azure.

Please follow this instructions if you want to create your own Northwind database sample.

Getting SQL Server on Your Computer

Download and install Microsoft SQL Server Express edition if you have not done so already. You can download the server along with free development tools that will help you customizing generated web applications at The link provides access to Microsoft Web Platform Installer, which makes the download and installation process extremely simple and pain-free.

If you do have a retail or development version of Microsoft SQL Server then this step is not needed.

If you are developing with other types of databases, such Oracle, DB2, MySQL, Microsoft Access, then getting Microsoft SQL Server Express installed will still help to get started with Code On Time. Generated web applications use provider-independent model to access data. It means that there is no code specific to Microsoft SQL Server in the generated application framework. If your back-end database server is Oracle 11g then exactly the same code will be generated.

Creating a Database

Run Code On Time and start creating a new Web Site Factory project.


Enter project name and choose your programming language (C# or Visual Basic.NET):


Click Next button to advance to Database Connection page of the project wizard.

Click the button next to the Connection String field to open the connection configuration window.


If you just have installed Microsoft SQL Server Express Edition on your computer then enter the following text in the Server field :


The dot in front of “\SQLExpress” indicates that you are connecting to your own computer.

If you already have a database server or working with SQL Azure then enter the actual server name or IP address.

Enter Northwind in the Database field and click Create button to create a blank database. You should see a message stating that the database has been created successfully.

Select Northwind in the drop down under Sample Tables and click Install button. You will notice the activity log displaying various SQL statements executed against the database. A message indicting completion of the process will be displayed.


Click Add button under Membership section to create optional support for ASP.NET Membership in your database. This option is not available in DotNetNuke Factory projects.

Azure Factory project offers additional section to configure session state support for multi-server deployment.

Wait for membership installation to complete and click OK button to save the settings.

Click Next button several times until you reach the summary of data controllers that will be implemented in your web application.


Click Generate to start the code generation.

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

Start using and customizing your own Northwind sample.


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