The ORM Foundation

I'm not sure if this is a bug or me just misunderstanding something but in the object role model which I've i've uploaded below, the entity type Project(.name) is being partially implemented as a VIEW in the generated Sql Server DDL

e.g.

CREATE VIEW Portfolio.Project_UC1 (WebsiteURL)
WITH SCHEMABINDING
AS
    SELECT WebsiteURL
    FROM
        Portfolio.Project
    WHERE WebsiteURL IS NOT NULL
GO

Link to the ORM file: http://www.sendspace.com/file/4selk1

Hi Tom,

The views are created for the uniqueness constraints on optional roles. You'll see a uniqueness constraint applied to this view after it is defined. Whether or not these views are generated depends on the behavior of the target DBMS when applying uniqueness constraints to null. You'll see them for uniqueness constraints that map to nullable columns in the database.

 -Matt

Thanks for the clarification Matt :)