in

The ORM Foundation

Get the facts!

Does the Readme note for non-LINQ outputs still apply?

Last post 08-16-2010 19:45 by Matthew Curland. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 08-16-2010 17:59

    Does the Readme note for non-LINQ outputs still apply?

    The ConceptualDB -> DCIL transform appears to be the updated (or processes the results of) R-Map/absorbstoin logic. I haven't quite been able to spend enough time to determine if this DCIL is the one currently used by the SQL outputs. If it is, then I'll probably look into cleaning up the SQL Server SQL output. (Like not spitting out the schema creation statement if the schema is 'dbo', etc..) Thanks, Bill
    Filed under: , ,
  • 08-16-2010 19:45 In reply to

    Re: Does the Readme note for non-LINQ outputs still apply?

    Yes, the comments still apply.

    There are basically two classes of XML schemas used with NORMA. One class has both an in-memory and an XML representation, and you'll see the namespaces for these listed on the root element of the .orm file. The second class of namespaces are used as intermediate formats for code generation only. The original (very outdated) absorption model (schema name http://schemas.orm.net/OIAL) is a class2 format, whereas the newer one also has an in-memory representation (schema name http://schemas.neumont.edu/ORM/Abstraction/2007-06/Core).

    The conceptual database schema (schema name http://schemas.neumont.edu/ORM/Relational/2007-06/ConceptualDatabase) is a class1 format representing a relational model. However, not all of the parts we currently generate are there (check clauses, data types, etc). DCIL (schema name http://schemas.orm.net/DIL/DCIL) is a class2 format that most downstream generators are based on. In general, DCIL represents relational elements (tables, columns, reference constraints, etc) while DIL is an intermediate format representing DDL (create table statements instead of table elements). DIL is then formatted into the different SQL flavors, which are all overrides of the SQL standard. Obviously, any changes need to be made in the appropriate formatter.

    The generation settings dialog will generally show you class 2 dependencies by graying out dependencies. The only behavioral difference in the 'secondary' branch is that the file automatically turns off in the diallog when it is no longer in use. You can see format dependencies in the HKLM\SOFTWARE\ORM Solutions\Natural ORM Architect for Visual Studio 2005\Generators key (adjust for VS2008).

    -Matt

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