ChinookDatabase Work Item Rss Feed

Created Issue: Indexes based on primary keys should be UNIQUE

ErikEJ — Mon, 10 Aug 2009 14:14:48 GMT

If not, ORM tools like CodeSmith do not work as expected (as a non-unique index indicates that more rows will be returned per key). I had planned to feature Chinook in a blog post, but this must be fixed for the following tables/indexes, before I can do that:

CREATE INDEX IPK_Genre ON Genre(GenreId);
CREATE INDEX IPK_MediaType ON MediaType(MediaTypeId);
CREATE INDEX IPK_Artist ON Artist(ArtistId);
CREATE INDEX IPK_ProductItem ON Album(AlbumId);
CREATE INDEX IPK_Track ON Track(TrackId);
CREATE INDEX IPK_Employee ON Employee(EmployeeId);
CREATE INDEX IPK_Customer ON Customer(CustomerId);
CREATE INDEX IPK_Invoice ON Invoice(InvoiceId);
CREATE INDEX IPK_InvoiceLine ON InvoiceLine(InvoiceLineId);
CREATE INDEX IPK_Playlist ON Playlist(PlaylistId);
CREATE INDEX IPK_PlaylistTrack ON PlaylistTrack(PlaylistId);

should be

CREATE UNIQUE INDEX IPK_Genre ON Genre(GenreId);
CREATE UNIQUE INDEX IPK_MediaType ON MediaType(MediaTypeId);
CREATE UNIQUE INDEX IPK_Artist ON Artist(ArtistId);
CREATE UNIQUE INDEX IPK_ProductItem ON Album(AlbumId);
CREATE UNIQUE INDEX IPK_Track ON Track(TrackId);
CREATE UNIQUE INDEX IPK_Employee ON Employee(EmployeeId);
CREATE UNIQUE INDEX IPK_Customer ON Customer(CustomerId);
CREATE UNIQUE INDEX IPK_Invoice ON Invoice(InvoiceId);
CREATE UNIQUE INDEX IPK_InvoiceLine ON InvoiceLine(InvoiceLineId);
CREATE UNIQUE INDEX IPK_Playlist ON Playlist(PlaylistId);
CREATE UNIQUE INDEX IPK_PlaylistTrack ON PlaylistTrack(PlaylistId);

Likewise, the enclosed chinook.sdf file needs to be recreated.

Created Feature: Feature Request: Schema change to allow implementation of inheritance mapping strategies

lerocha — Sun, 26 Apr 2009 22:30:24 GMT

This request is from Rub member of the uNhAddIns project (Unofficial addins for NHibernate): http://code.google.com/p/unhaddins/

Change the schema to allow developers to implement the three basic strategies for inheritance mapping:

1. Table per Class Hierarchy
2. Table per Subclass
3. Table per Concrete Class

For more info, see:
http://www.nhforge.org/doc/nh/en/index.html#inheritance

Created Feature: Support for NHibernate using HiLo generator

lerocha — Mon, 20 Apr 2009 05:15:15 GMT

This request is from Rub member of the uNhAddIns project (Unofficial addins for NHibernate): http://code.google.com/p/unhaddins/

The current scripts use Identity to auto-generate primary keys. Although NHibernate supports Identity, it is not a good solution for it, as described below:
http://nhforge.org/blogs/nhibernate/archive/2008/12/21/identity-the-never-ending-story.aspx

We need to add support for nhibernate HiLo generation. For example, the Genre table would be:

CREATE TABLE Genre
(
GenreId INTEGER NOT NULL, // IDENTITY - no identity here
Name NVARCHAR(120),
PRIMARY KEY(GenreId)
);

Created Feature: Feature Request

lerocha — Mon, 20 Apr 2009 04:55:25 GMT

Feature requests by Evoluteur:
- script to drop all tables (because it needs to drop ref integrity first).
- triggers to update order total.
- a few records in Chinese or Japanese

Closed Issue: Error when creating database for the first time in SQL Server Express

lerocha — Tue, 06 Jan 2009 03:00:44 GMT

When trying to create the Chinook Database for the first time (SQL Express only) we get the following error:

Msg 911, Level 16, State 1, Server VM-MCPD\SQLEXPRESS, Line 13
Could not locate entry in sysdatabases for database 'Chinook'. No entry found with that name. Make sure that the name is entered correctly.

The scripts for the other databases do not have this issue.

Workaround:
Edit the Scripts\SqlServer\CreateDB.sql and add the GO command line right after the CREATE DATABASE line:

IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'Chinook') DROP DATABASE [Chinook];
CREATE DATABASE [Chinook];
GO

Created Issue: Error when creating database using SQL Express 2005

lerocha — Mon, 05 Jan 2009 21:30:12 GMT

When trying to create the Chinook Database using SQL Express 2005 we get the following error:

Msg 911, Level 16, State 1, Server VM-MCPD\SQLEXPRESS, Line 13
Could not locate entry in sysdatabases for database 'Chinook'. No entry found with that name. Make sure that the name is entered correctly.

This only happens when:
1. Using SQL Express 2005.
2. It is the first time that the Chinook Database is created on the DB Server.

Workaround:
Edit the Scripts\SqlServer\CreateDB.sql and add the GO command line right after the CREATE DATABASE line:

IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'Chinook') DROP DATABASE [Chinook];
CREATE DATABASE [Chinook];
GO

Closed Task: Change Chinook database schema representation

lerocha — Mon, 05 Jan 2009 04:03:34 GMT

The Chinook schema database is represented by a DataSet schema, which is used by T4 templates to generate the SQL scripts.

Investigate if it is feasible to use a newer representation (dbml or edmx) instead, and if so, convert the current schema and update the T4 templates.

Closed Task: Need to create additional sample data for customers

lerocha — Sun, 04 Jan 2009 08:07:12 GMT

Create additional sample data for the customers table.

Need to use Customers from different countries and use valid address that will correctly appear in Google maps.

Closed Task: Add support for SQL Server Compact

lerocha — Tue, 30 Dec 2008 05:25:16 GMT

One of our users sent a script for SQL Server Compact. We need to update the T4 templates in order to also generate this script.

Closed Task: Change version number to 1.1

lerocha — Mon, 29 Dec 2008 07:51:32 GMT

Need to change the scripts version number to 1.1 in DataSetHelper.tt before the main release.

Closed Task: Add a many-to-many relationship to the schema

lerocha — Mon, 29 Dec 2008 07:51:31 GMT

There is no many-to-many relationship in the current schema. Although we want to keep this schema as simple as possible, we still want to provide at least one many-to-many relationship.

Suggestion: Create a new entity Playlist which has a many-to-many relationship with the Track entity. This will result in two new tables: Playlist and PlaylistTrack tables.

Created Task: Change version number to 1.1

lerocha — Sat, 27 Dec 2008 23:23:08 GMT

Need to change the scripts version number to 1.1 in DataSetHelper.tt before the main release.

Created Task: Add support for SQL Server Compact

lerocha — Sat, 27 Dec 2008 22:14:03 GMT

One of our users sent a script for SQL Server Compact. We need to update the T4 templates in order to also generate this script.

Created Task: Add a many-to-many relationship to the schema

lerocha — Sat, 27 Dec 2008 22:11:09 GMT

Created Task: Need to create additional sample data for customers

lerocha — Sat, 27 Dec 2008 21:59:39 GMT

Create additional sample data for the customers table.

Need to use Customers from different countries and use valid address that will correctly appear in Google maps.

Created Task: Change Chinook database schema representation

lerocha — Sat, 27 Dec 2008 21:54:38 GMT