in

The ORM Foundation

Get the facts!

NORMA incorrectly generating views?

Last post 05-04-2012 19:46 by Anonymous. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 05-04-2012 18:23

    NORMA incorrectly generating views?

    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

    Tom

     

     


  • 05-04-2012 19:37 In reply to

    Re: NORMA incorrectly generating views?

    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

  • 05-04-2012 19:46 In reply to

    Re: NORMA incorrectly generating views?

    Thanks for the clarification Matt :)

Page 1 of 1 (3 items)
© 2008-2014 The ORM Foundation: A UK not-for-profit organisation -------------- Terms of Service